public marks

PUBLIC MARKS from camel with tags mysql & cache

20 December 2005 17:30

Using and Tuning of the Query Cache

by 1 other (via)
MySQL provides a mechanism to cache a query and its result set for reuse by all users. This can be extremely effective in environments where a large number of small, lexically equivalent queries are repeated often. Parameters Affecting the Query Cache Parameters in the my.cnf file exist to enable, configure and tune the query cache. Pay careful attention to the values of query_cache_size and query_cache_type because they interact in a non-standard way and can cause confusion.