Can't optimize innoDB table

Question

Hello, 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.