Hi i am working on MySQL 5.5 and trying to do index rebuild using Optimize table query i am getting below error,
Table does not support optimize, doing recreate + analyze instead
What this mean for ? is MySQL engine not allowing to Index Rebuild ? what getting done behind this message at MySQL 5.5 Engine level ?
Best How To :
That's really an informational message.
Likely, you're doing OPTIMIZE on an InnoDB table (table using the InnoDB storage engine, rather thant the MyISAM storage engine).
InnoDB doesn't support the OPTIMIZE the way MyISAM does. It does something different. It creates an empty table, and copies all of the rows from the existing table into it, and essentially deletes the old table and renames the new table, and then runs an ANALYZE to gather statistics. That's the closest that InnoDB can get to doing an OPTIMIZE.
The message you are getting is basically MySQL reporting what the InnoDB storage engine is telling MySQL server... "I don't really do optimize, but I can do something else that will give a similar result".