Mysqltuner check


#1

Hi there, i run mysqltuner to check mysql’s tables on my server A reccomandation was: Run OPTIMIZE TABLE to defragment tables for better performance

So i run: mysqlcheck -u root -p --auto-repair --optimize --all-databases but server says: The storage engine for the table doesn’t support optimize

Any hint? Thanks


#2

@feedtek1,

Its because, these tabales are InnoDB which doesn’t support for optimization. You can ignore that note.


#3

Optimization = defrag ? When you say “ignore”, i had to force the operation? Thanks


#4

Hi @feedtek1

It’s been a long time, and we haven’t heard from you. It looks like your issue is resolved.

I am closing this support topic for now. Feel free to create a new support topic if you have any queries further. :slight_smile:


#5