List:InnoDB Storage Engine« Previous MessageNext Message »
From:Shashank Raj Holavanalli Date:April 26 2013 9:58pm
Subject:INNODB OPTIMIZE TABLE Query
View as plain text  
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