InMotion Hosting Support Center

Optimizing databases can be important for many reasons, most importantly to speed up the rate in which your database displays results. By optimizing the databases, you can dramatically affect how fast your website loads. Typically, optimization will only produce noticeable results if you have a large database. If your database has tables with over 10,000 rows or is over 500MB in size, it may be beneficial to optimize it. Databases smaller in size my not produce any noticeable results from optimization.

Steps to Optimize your database

  1. You can log into phpMyAdmin from your cPanel.
  2. Click on the database name for your website database located on the left.
  3. On the right hand column your tables should be listed. Scroll down till you see the “Check all” link.
  4. Click on that link, make sure all database tables are checked and then from the dropdown next to it, select “Optimize table”.

    This command will not work on all table types.

Support Center Login

Social Media Login

   
Social Login Joomla

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Post a Comment

Name:
Email Address:
Phone Number:
Comment:
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

0 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!