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