MySQL Database Optimization
A slow database is the #1 cause of a sluggish website. Over time, databases collect "overhead"fragments of data left behind by deleted plugins or old post revisions.
How to Optimize via phpMyAdmin:
-
Open phpMyAdmin from your dashboard.
-
Select your database from the left-hand list.
-
Scroll to the bottom and click Check All.
-
In the "With selected" dropdown menu, choose Optimize table.
-
The Result: The system defragments your tables, often reducing the size of your database and speeding up query response times instantly.
