How To Optimize SQL Database

Every once in a while it’s a good idea to optimize your website’s SQL database tables. This will ensure things are running at their full potential.


First, log in to cPanel on your hosted server.

Server Login


Scroll down and find phpMyAdmin.

Database Tools



Log in with your database credentials. Note: If you are unsure of your credentials, go to MySQLDatabases in the Database Tools.

phpMyAdmin Login


Once logged in to phpMyAdmin, select your website’s database on the left-hand side.

phpMyAdmin Database


Scroll down and click on check all tables. Click on the With selected: box.

phpMyAdmin Check All


Select Optimize table.

phpMyAdmin Optimize Table


The query will instantly optimize the tables.

phpMyAdmin Successful Query



Notify of