Optimize table in MySQL
If your site seems slow, try optimizing the site database by removing 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.
- Go to your GoDaddy My Products page. You might be prompted to sign in.
- Open my phpMyAdmin.
- Below the list of tables, select Check all tables having overhead.
- From the list select Optimize table.
- Find more information about optimizing tables at mysql.com.