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.

  • 66 Users Found This Useful
Was this answer helpful?

Related Articles

Can I connect to MySQL from my computer

Yes, you can. Just need to add your IP address in the hosts allowed to connect to MySQL. Adding...

Can’t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

If you receive this error message when connecting to MySQL trough command line on your VPS...

Export and import of MySQL databases from cPanel

For management on databases in your hosting account you can use the web application phpMyAdmin....

Export and import MySQL databases via SSH

If you want to import your MySQL database through SSH on your VPS or dedicated server, use the...

How to see the MySQL variables

Log into your MySQL database and type: show variables; You will see the following: mysql>...