I’ve always been using MyISAM tables in my WordPress blog, however, recently I moved from standard MySQL to Percona Server and started using the InnoDB for tables.
Every time I run optimize I can see that InnoDB tables aren’t optimized:
“Table does not support optimize, doing recreate + analyze instead”.
- I searched about it and found some posts saying that optimizing
InnoDBtables is bad for performance. Is it true? - Can I keep optimizing my
WordPress InnoDBtables monthly?
Outside of some edge cases that you’re unlikely to encounter, optimization is not necessary for InnoDB tables. I wouldn’t bother.