MySQL Server Query Cache Use Percent Monitor Monitor

  • ID:  Microsoft.MySQLServer.ManagedServer.Unix.QueryCacheUsePct.Monitor
  • Description:  MySQL Server Query Cache Use Percent Monitor
  • Target:  Monitored MySQL Server (Linux)
  • Enabled:  On Standard Monitoring

Operational States

Name State Description
Under Threshold Success Under Threshold
Over Warning Threshold Warning Over Warning Threshold
Over Error Threshold Error Over Error Threshold

Overridable Parameters

Parameter Name Default Value Description Override
Interval 300 Interval in seconds
Number of Samples 3 Number of Samples
Warning Threshold 85 Warning Threshold
Error Threshold 95 Error Threshold

Alert Details

Monitor State Message Priority Severity Auto Resolution
Over Warning Threshold (Warning) MySQL Server Query Cache Use Percent Medium Match Monitor Health Yes

Run As Profiles

Name
Default

Monitor Knowledgebase

Summary

The percent used of the query cache. The query cache stores the contents of a select statement with the corresponding result; these results are invalidated after an insert, update, or delete statement. The query cache size is controlled using the global variable “query_cache_size”. The size of a query that can be inserted into the query cache is controlled by the global variable “query_cache_limit”. The monitor threshold is analyzed against an average of values returned in polls to the agent where the Number of Samples parameter controls the number of samples included in the calculation of the average.

Causes

An unhealthy state indicates the percentage use of the MySQL query cache is high. The query cache might not have enough storage for recently used queries. The query cache limit for individual queries might be too high causing less queries to be stored and higher percent usage.

Resolutions

To address high query cache usage percent increase the query_cache_size to allow additional queries to be stored. Decreasing query_cache_limit can allow additional queries to be stored in the query cache.

External References
This monitor does not contain any external references.

See Also for Open Source Software Preview Management Pack


Downloads for Open Source Software Preview Management Pack

AZURE OPTIMIZATION ASSESSMENT GET STARTED
MIGRATION TO AZURE GET STARTED
SYSTEM CENTER MIGRATION TO AZURE GET STARTED
MIGRATION TO AZURE FOR SQL AND WINDOWS 2008 GET STARTED