News for hackers. Stuff that matters.
Re:Caching MySQL queries by bigbee on Monday June 02, 2008 @12:31PM (#206869)
The easiest way is to use MySQL's own query cache. Increasing its size yields wonderful results.

On linux, edit my.cnf and add the following:

  [mysqld]
  ...
  query_cache_type=1
  query_cache_limit=1M
  query_cache_size=128M # or more - depends on you total  available RAM
  key_buffer=128M # or more
Note that you'll need to restart mysql to make these changes count

There are no comments on this comment yet.