Diamond Notes

When it comes to benchmarking it is useful to turn your query cache off sometimes. This can be done on both client connection level and the global/server level.

Client level:

to turn the cache off

SET SESSION query_cache_type = OFF;

and then to turn it back on

SET SESSION query_cache_type = ON;

Server level:

to turn off the cache

SET GLOBAL query_cache_type = OFF;

and to turn it back on

SET GLOBAL query_cache_type = ON;