Portal Home > Knowledgebase > MySQL and PostgreSQL > Optimize MySQL database for more speed

Optimize MySQL database for more speed

If the MySQL database access times seems high and you feel a slow down you need to optimize your MySQL database table or tables. This will reduce the time needed to access the MySQL information. This MySQL optimization is helping to organize the host file system and optimize the MySQL database.

You can optimize your MySQL database on a regular basis, lets say every week if you have a small web site. If you are owner of bigger and higher traffic web site, maybe do MySQL table optimization more frequently.

Here is the manual how to do MySQL table optimization under your web hosting account:

1) Login to your cPanel web hosting account
2) Search and click on the MySQL Database link
3) There at the bottom will see phpMyAdmin link click on it
4) Select the MySQL database you plan to optimize
5) phpMyAdmin will show you all the MySQL tables on the screen. Then at the bottom click "Select All Tables"
6) There will be a checkbox in each of the tables, on the bottom right. Just pick "Optimize Table" and continue

After this finish you will have all MySQL tables optimized and your MySQL database will speed up resulting in faster searches on your web pages.

Was this answer helpful?

Add to Favourites Add to Favourites    Print this Article Print this Article

Also Read

* Minimum sign up periods for cPanel Web Hosting plans: Mini - 3mo., Pro - 1mo., Biz - 1mo., cPanel Reseller Hosting, Linux VPS, Windows VPS, Managed cPanel VPS and Dedicated Servers - 1mo. secret link
Accepted payments: Credit/Debit Card, Paypal, Payza, Skrill, WebMoney, CashU, Ukash, paysafecard, Bitcoin, Perfect Money, SolidTrust Pay, OKPay, EgoPay, Western Union/MG, Wire Transfer and more.