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.
Thread
checking progress of alter table on an InnoDB table (Was: Re:checking progress of alter table on a MyISAM table)Larry Martell27 Sep
  • RE: checking progress of alter table on an InnoDB table (Was: Re:checking progress of alter table on a MyISAM table)Rick James27 Sep
    • Re: checking progress of alter table on an InnoDB table (Was: Re:checking progress of alter table on a MyISAM table)Larry Martell27 Sep
    • Re: checking progress of alter table on an InnoDB table (Was: Re:checking progress of alter table on a MyISAM table)Akshay Suryavanshi27 Sep
      • Re: checking progress of alter table on an InnoDB table (Was: Re:checking progress of alter table on a MyISAM table)Larry Martell27 Sep
        • Re: checking progress of alter table on an InnoDB table (Was: Re:checking progress of alter table on a MyISAM table)Akshay Suryavanshi27 Sep
          • Re: checking progress of alter table on an InnoDB table (Was: Re:checking progress of alter table on a MyISAM table)Larry Martell27 Sep
            • Re: checking progress of alter table on a MyISAM tableReindl Harald27 Sep
          • Re: checking progress of alter table on an InnoDB table (Was: Re:checking progress of alter table on a MyISAM table)Larry Martell28 Sep