Enable MySQL Query Caching

Add another caching layer to your system: make sure to properly cache MySQL queries. This relies on settings you find (or should insert) in your my.cnf configuration file on your server. According to Nadeau software, the MySQL query caching can boost performance by 5-15%. It is important to regularly monitor your MySQL caching performance to see if the allocated RAM for caching is still appropriate.

From Nadeau Software:

The query cache is empty when it is first enabled. As Drupal issues queries to the database, MySQL finds the requested data and saves it in the cache. After awhile, much of the data Drupal needs from page to page is quickly found in the cache.

Advantages

  • Reduce MySQL query load

References

Morningtime