How to Optimize MySQL

2013-11-08 79 words 1 min read

Today I found my websites were very slow. Log into linode system and I found MySQL is over 500% CPU usage.

Just google it. and found a script.


  1. wget https://raw.github.com/major/MySQLTuner-perl/master/mysqltuner.pl

  2. use winscp to change the pl file to 777

  3. use putty to telnet the server.

  4. Just run the pl. ./mysqltuner.pl

  5. The pl will display some setting suggestion.  change ./etc/mysql/my.cnf

  6. Use the following command to optimize database tables
    mysqlcheck --optimize -A -u username -ppassword

  7. service mysql restart

  8. That's all.


 

author

Authored By Jesse Lau

A freelancer living in New Zealand, engaged in website development and program trading. Ever won 1st ranking twice in the Dukascopy Strategy Contest. This article is licensed under a Creative Commons Attribution 4.0 International License.

We notice you're using an adblocker. If you like our webite please keep us running by whitelisting this site in your ad blocker. We’re serving quality, related ads only. Thank you!

I've whitelisted your website.

Not now

Post Your Comments Here:

Our website uses cookies to improve your user experience. If you continue browsing, we assume that you consent to our use of cookies. More information can be found in our privacy policy Got it