Optimize table in MySQL
If your site seems slow, you can try optimizing the site database to remove gaps in data (also known as overhead). This can help restore speed if the database is at fault, but doesn't fix the scripting that initially created the overhead.
Note: Before you begin, you need to back up your database: Web Hosting (cPanel) | Windows Hosting (Plesk)
- Access phpMyAdmin for the database you want to optimize: Web Hosting (cPanel) | Windows Hosting (Plesk)
- Double-click the database name.
- At the bottom of the list of tables, select Check all tables having overhead.
- From the drop down menu, select Optimize table.
