Lists the Query Cache configuration metrics and provides a brief description of each.
Table 5.23 Query Cache Configuration Metrics
| Name | Description |
|---|---|
| Limit (Total) | The maximum size (in bytes) of result sets to cache withinthe Query Cache. Result sets larger than this size will not be cached. |
| Min Res Unit (Total) | The minimum size (in bytes) for blocks allocated by the query cache. |
| Query Cache Enabled (Total) | Whether the MySQL server supports the Query Cache or not. |
| Size (Total) | The total amount of memory (in bytes) to allocate for caching query results within the Query Cache. |
| Type (Total) | Controls how the query cache decides whether to cache SELECTstatements, based on the SQL_NO_CACHE and SQL_CACHE keywords. |
| Wlock Invalidate Enabled (Total) | Causes acquisition of a WRITE lock for a table to invalidate any queries in the Query Cache that refer to the table. |