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.

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