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
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments