List:General Discussion« Previous MessageNext Message »
From:Larry Martell Date:September 27 2012 8:33pm
Subject:Re: checking progress of alter table on an InnoDB table (Was: Re:
checking progress of alter table on a MyISAM table)
View as plain text  
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 <rjames@stripped> 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.martell@stripped]
>> 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 <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.
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:    http://lists.mysql.com/mysql
>
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