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. |