5

Increase MySQL performance with query cache query_cache

view full story
linux-howto

http://www.go2linux.org – In order to increase the performance of MySQL server, query_cache may be turned on. What this is going to do is make that the queries that are repeated will be cached and not actually executed each time they are requested by the code, this aproach is really good specially for php / MySQL based web pages, if a site grows and get lots of visits a day, tunning it is a must to better use the hardware resources, and not limit the webserver because of MySQL problems. Let's see how to enable query_cache. <!--break--> Edit the file my.cnf and add at least these two line (HowTos)