Re: checking progress of alter table on a MyISAM table

[Karen Abgarian]

I try to figure out something observing the stats with SHOW STATUS.   There are some
reads, writes, etc that tell something about what is going on. 
Looking just at the file sizes is likely going to not tell much about the progress.
  
If there is a better way to monitor this progress, I would like to know this...  

On Sep 26, 2012, at 3:46 PM, hsv@stripped wrote:

>>>>> 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.
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>