Bug #2603 OPTIMIZE for InnoDB
Submitted: 1 Feb 2004 16:37 Modified: 1 Sep 2004 18:24
Reporter: Federico Razzoli (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S4 (Feature request)
Version:5 OS:
Assigned to: CPU Architecture:Any

[1 Feb 2004 16:37] Federico Razzoli 
Description:
InnoDB doesn't support OPTIMIZE, so there is not an easy way to 
defragment a table. ANALYZE should be supported too.

How to repeat:
n/a

Suggested fix:
n/a
[1 Sep 2004 18:08] Shawn Green 
I concur. These tools should be enhanced to operate on ALL of the storage types supported by the MySQL platform.
[1 Sep 2004 18:24] Heikki Tuuri 
Hi!

InnoDB-4.1.3 does support OPTIMIZE TABLE. It simply rebuilds the whole table.

Best regards,

Heikki

http://dev.mysql.com/doc/mysql/en/InnoDB_news-4.1.3.html
"
C.9.3 MySQL/InnoDB-4.1.3, June 28, 2004

...
OPTIMIZE TABLE for InnoDB tables is now mapped to ALTER TABLE rather than to ANALYZE TABLE. 
"