Increase MySQL Performance

Keyword: MySQL Query Cache

If you want to increase the speed of your MySQL Database (answers), think about activating the Query Cache. That is available since Version 4. It’s really recommendable when you are working a lot with dynamic generated content, that does not change too often. Usually that is the fact for most webservers. In that case the Query Cache will give you back the answers for your sql queries without polling the database – as long as the tables do not change.

Insert in your config (/etc/my.cnf) i.e.:
query_cache_size = 8M

You can control the usage with a sql query:
SHOW STATUS LIKE 'Qcache%';

Thanks to Thomas Schefter for the hint.