How do I optimise a database in phpMyAdmin?

If you update your website regularly, your database will get fragmented over time. A large, fragmented database can make your website load slower.

When you optimise your database, all data gets sorted, like when you defragment your computer. This makes your database run more efficiently and can improve loading time of your website.

Note: Be very careful when you work in phpMyAdmin, as it is not possible to undo changes. We recommend creating a backup, before you make any changes.

• Step 1 - Open your database in phpMyAdmin
• Step 2 - Click Databases in the top menu
• Step 3 - Click the name of the database you want to optimise
• Step 4 - Check tables and optimise
• Step 5 - You're done

Step 1 - Open your database in phpMyAdmin

Read our guide on how to access your database if you don't know how to do this.

Step 2 - Click Databases in the top menu

Step 3 - Click the name of the database you want to optimise

Step 4 - Check tables and optimise

Click Check All to select all tables, or manually check the boxes for the tables you want to optimise.
Select Optimise table in the drop-down menu.

Step 5 - You're done

Your database is now optimised.

Related articles:

• How do I make a backup of my database?
• How do I import a database to phpMyAdmin?