MySQL Query Cache - what you probably didn’t know

I decided to write this post during development of new Download3000 site engine because I think it is the thing that many developers simply forgot to consider when they develop new applications based on MySQL database server.
If you run a busy site, MySQL query cache is a must. It can dramatically decrease server load and save system resources for other services you run on the same server.
When it comes to cache size, small sites can use values under 32MB but if your site is really busy (tens of thousands …

August 28, 2008 at 5:37 pm | MySQL | No comment | 2,620 views