List:InnoDB Storage Engine« Previous MessageNext Message »
From:Paul Wilson Date:April 26 2013 10:17pm
Subject:Re: INNODB OPTIMIZE TABLE Query
View as plain text  
Please remove me from you emailing list, thanks.

On Fri, Apr 26, 2013 at 4:58 PM, Shashank Raj Holavanalli <
sholavan@stripped> wrote:

> When my table has multiple secondary indexes and i run an optimize table
> query, why does innodb not drop the secondary indexes then optimize the
> table and then restore the indexes back again ?
>
> The existing method does not utilize the fast index creation and also is
> very slow. Can any one please explain ?
>
> --
>
> Thank you,
>
> Shashank Raj Holavanalli
>
> Person Number: 50027381
>

Thread
INNODB OPTIMIZE TABLE QueryShashank Raj Holavanalli26 Apr
  • Re: INNODB OPTIMIZE TABLE QueryPaul Wilson26 Apr
    • Re: INNODB OPTIMIZE TABLE QueryReindl Harald26 Apr