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