If you are noticing slugging performance wits your MySQL database, this simple tutorial is for you. This is particularly important for websites that have a large MySQL database. Please note that you must have root access and SSH access to proceed further. Log into your web hosting via SSH and follow below.
Run this command:
mysqlcheck -u root –auto-repair –optimize –all-databases
If you notice issues you can fix tables by issuing:
mysqlcheck -A -r -p
If everything has been fixed it is highly recommended to restart your MySQL server:
That is all, you should see increase in your MySQL queries and of course better performance.