Can't optimize innoDB table

Question

As my first message here, i don't know if i have to answer or post a new message. I have the same problem as here and the one and only given answer doesn't help me (except if the documentation is incorrect). "You can make OPTIMIZE TABLE work on other storage engines", but my engine is InnoDB. I thank you for your help. S.

Answer 1

OPTIMIZE TABLE works fine on InnoDB tables. The message that says "Table does not support optimize, doing recreate + analyze instead" is purely informational. You can safely ignore that message.

Answer 2

You cannot IGNORE the result... that means its doing a VERY intensive operation instead of a light one... one a very large table (>100G) this could be hours instead of minutes.