From: Karen Abgarian Date: September 28 2012 12:23am Subject: Re: checking progress of alter table on a MyISAM table List-Archive: http://lists.mysql.com/mysql/228282 Message-Id: <7F4BBA03-F2B8-4406-A911-24E6593E46F0@apple.com> References: <2E7DD7ADE53B044C8C8BCD9C5829E1EB148CF91C30@SP2-EX07VS01.ds.corp.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; CHARSET=US-ASCII Content-Transfer-Encoding: 7BIT 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 >