|List:||General Discussion||« Previous MessageNext Message »|
|From:||Larry Martell||Date:||September 27 2012 8:20pm|
|Subject:||checking progress of alter table on an InnoDB table (Was: Re:|
checking progress of alter table on a MyISAM table)
|View as plain text|
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 <rjames@stripped> 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.martell@stripped] >> 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.