MySQL Forums
Forum List  »  Optimizer & Parser

Table does not support optimize...
Posted by: Piotr Ch
Date: June 02, 2012 12:58AM

I moved the database from MySQL 5.0.4 server to new server MySQL 5.1.61.
While running the optimization of the database tables on the old server, all the tables passed it correctly - "OK".
On the new server in most tables get the error message:
"Table does not support optimize, doing recreate + analyze instead"
This is the same database without any additional changes.
Are of type InnoDB tables (on old and new server).
On the new server mysqltuner show that the most tables are defragmented.
How do I bring to the state such as the old MySQL server?
Please help.


Edited 1 time(s). Last edit at 06/02/2012 12:59AM by Piotr Ch.

Options: ReplyQuote

Written By
Table does not support optimize...
June 02, 2012 12:58AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.