I read that here: http://gabrielcain.com/blog/2009/08/05/mysql-alter-table-and-how-to-observe-progress/comment-page-1/
On Thu, Sep 27, 2012 at 2:26 PM, Rick James <rja...@yahoo-inc.com> wrote: > Isn't ALTER a DDL, not DML? So I don't think you would find anything in undo > logs. > >> -----Original Message----- >> From: Larry Martell [mailto:larry.mart...@gmail.com] >> Sent: Thursday, September 27, 2012 1:20 PM >> To: Rick James >> Cc: mysql mailing list >> Subject: checking progress of alter table on an InnoDB table (Was: Re: >> checking progress of alter table on a MyISAM table) >> >> So we changed the table from MyISAM to InnoDB. I read that the 'undo >> log entries' shown in 'show engine innodb status' would correspond to >> the number of rows that have been operated on throughout the process of >> the ALTER. The table we're altering has 115,096,205 rows, and the >> alter's been running for 28 hours, and the undo log entries is 9309. >> Also that number seems to go up and down. So clearly, it's not what I >> think. >> >> So anyone know a way to monitor the status of the alter now that it's >> an InnoDB table? >> >> >> On Wed, Sep 26, 2012 at 10:31 AM, Rick James <rja...@yahoo-inc.com> >> wrote: >> > 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. >> > >> >> -----Original Message----- >> >> From: Larry Martell [mailto:larry.mart...@gmail.com] >> >> Sent: Wednesday, September 26, 2012 8:52 AM >> >> To: mysql mailing list >> >> Subject: checking progress of alter table on a MyISAM table >> >> >> >> 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: http://lists.mysql.com/mysql > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
