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 optimize your database, all data gets sorted, like when you defragment your computer. This makes your database run more efficient and can improve loading time of your website.
- 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 optimize
- Step 4 - Check tables and optimize
- 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 optimize

Step 4 - Check tables and optimize
Click Check All to select all tables, or manually check the boxes for the tables you want to optimize.
Select Optimize table in the drop-down menu.

Step 5 - You're done
Your database is now optimized.

Related articles: