From: hsv Date: September 26 2012 10:46pm Subject: RE: checking progress of alter table on a MyISAM table List-Archive: http://lists.mysql.com/mysql/228272 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" >>>> 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 optimistic. <<<<<<<< And under Windows more misleading--often, if a file is small, the directory listing will show 0 until the very end.