There is one specific MySQL configuration parameter above all others that will produce significant performance improvements and takes very little understanding to implement.
This configuration directive tells the MySQL server to store the result of the query in memory—much faster than accessing from disk.
In a hosting environment with 1 GB RAM, this allows for a query cache size of 64 MB or larger depending on other memory use factors, such as other services running on the server.
This allows 64 MB of queries to be stored in the very fast RAM, or memory of your hosting environment, as opposed to having to access the disk each time this query is executed or each time the page is loaded. This is an extremely large amount of data.
Invaldating a subset of a sufficiently large query cache can take a long time. During this time the server is efficiently frozen…
View original post 460 more words