checking progress of alter table on a MyISAM table

2012-09-26 Thread Larry Martell
Is there any way to check on the progress of a long running alter table on a MyISAM table? I know it can be done with an InnoDB table, but I haven't found a way to do it on with a MyISAM table. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

RE: checking progress of alter table on a MyISAM table

2012-09-26 Thread Rick James
Not really. You could look at the .TYD and .TYI file sizes and compare to the .MYD and .MYI, but that can be deceptive. If the table is really big, and has lots of indexes, the generation of the indexes might go slower and slower -- hence any math on the sizes would be optimistic.

RE: checking progress of alter table on a MyISAM table

2012-09-26 Thread hsv
2012/09/26 09:31 -0700, Rick James You could look at the .TYD and .TYI file sizes and compare to the .MYD and .MYI, but that can be deceptive. If the table is really big, and has lots of indexes, the generation of the indexes might go slower and slower -- hence any math on the sizes would be