The MySQL query cache stores the most recent SELECT queries performed by the MySQL database server, together with the result sets of those queries. This can reduce much of the parsing overhead, and logical or physical I/O, associated with those queries if and when the queries are repeated.
The Query Cache Hit Rate alarm fires when the proportion of SQL queries that can be found in the MySQL query cache drops below a specified threshold.
You may be able to tune the performance of the query cache by modifying configuration variables to:
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center
