MySQL Optimization

Private Dock

There is one specific MySQL configuration parameter above all others that will produce significant performance improvements and takes very little understanding to implement.

“query_cache_size”

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

Advertisements
Standard

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s