New answers tagged fragmentation
ASPECT #1 The message you saw did not say "Table does not support optimize, do recreate + analyze instead OK" but the message said "Table does not support optimize, doing recreate + analyze instead OK" This means the InnoDB Storage Engine already executed ALTER TABLE GEO ENGINE='InnoDB'; ANALYZE TABLE GEO; There was no need to do it ...
Tables won't have zero fragmentation in the best of circumstances. You've done everything recommended to reduce its fragmentation. It's time to move on to the next problem.
Top 50 recent answers are included