Mysqltuner shows a warning “Run OPTIMIZE TABLE to defragment tables for better performance”

You want to optimise your MySQL database through SSH.


MySQL databases can become fragmented over time as database entries are created and deleted. Fragmentation causes MySQL queries to take longer to complete, slowing down your website.


Optimize your MySQL database using the command below:

mysqlcheck -op -u username database_name

Replace username and database_name with your database details.