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: Linux Hosting | Windows Hosting

  1. Access phpMyAdmin for the database you want to optimize: Linux Hosting | Windows Hosting
  2. Double-click the database name.
  3. At the bottom of the list of tables, click Check all tables having overhead.
  4. From the drop down menu, select Optimize table.

Was This Article Helpful?
Thanks for your feedback. To speak with a customer service representative, please use the support phone number or chat option above.
Glad we helped! Anything more we can do for you?
Sorry about that. Tell us what was confusing or why the solution didn’t solve your problem.