How To Optimizing MySQL server

Posted by cikul | Posted in Internet, Linux, web | Posted on 20-04-2009-05-2008

11

mysqlFor the web server that using mysql as a database engine. Sometimes the process in mysql need a large resource, especially if server has a high traffic. According to my experience, to the high traffic server, the MySQL process itself can spend more than 30% of server resources. So, I will give you tips for optimizing mysql on the server that has high traffic.

Mysql configuration located in the my.cnf file, usually this file is in the /etc directory, but can also in other folders. For more safe, you can search my.cnf file to make sure the location of the file. Read the rest of this entry »

Incoming search terms:

optimize mysql server | how to optimize mysql server | optimize mysql | your applications are not closing mysql connections properly | rails your applications are not closing mysql connections properly | cpanel MySQL hardening and optimize | mysql tuner windows server 2003 | optimazation mysql server | optimize mysql configuration 1gb of ram | optimize mysql for high traffic | 

Share and Enjoy