If it still doesn't work. Then you could combine the following 3 together:
When you run "optimize local table yourtable; ", sometimes you get the following:
Table does not support optimize, doing recreate + analyze instead.
For a table about 26M records,
optimize local table yourtable;
alter table yourtable ENGINE='InnoDB';
takes about 30 to 45 minutes. We care about it because it will lock the table.
analyze local table yourtable;
it is instantly.