What are the Query Cache Key Performance Indicators?
This article addresses what metrics to look for when assessing the benefits of your query cache. 1. Current Size compared with maximum available size. To calculate the percentage used value for the query cache you can use the following formula: ((query_cache_size-Qcache_free_memory)/query_cache_size)*100 N.B. query_cache_size is a variable, which can be found from a show variables like… Read More »