Lists the Query Cache Activity metrics and provides a brief description of each.
Table 4.21 Query Cache Activity Metrics
Name | Description |
---|---|
Free Blocks (Total) | The number of free memory blocks in the Query Cache. |
Free Memory (Total) | The amount of free memory (in bytes) for the Query Cache. |
Hits (Delta) | The number of Query Cache hits. |
Inserts (Delta) | The number of queries added to the Query Cache. |
Lowmem Prunes (Delta) | The number of queries that were deleted from the Query Cache because of low memory. |
Not Cached (Delta) | The number of noncached queries (not cacheable, or not cached due to the query_cache_type setting). |
Queries In Cache (Total) | The number of queries registered in the Query Cache. |
Total Blocks (Total) | The total number of blocks in the Query Cache. |
Average Free Block Size (KB) | The average size in kilobytes of free blocks within the Query Cache. |
Used Blocks | The number of used memory blocks in the Query Cache. |
Free Memory (MB) | The amount of free memory in megabytes within the Query Cache. |