MySQL Manual
6 MySQL Language Reference
- 6.9 MySQL Query Cache
- 6.9.1 How The Query Cache Operates
- 6.9.2 Query Cache Configuration
- 6.9.3 Query Cache Options in
SELECT - 6.9.4 Query Cache Status and Maintenance
6.9.3 Query Cache Options in SELECT
There are two possible query cache related parameters that may be
specified in a SELECT query:
| Option | Description |
SQL_CACHE
| If QUERY_CACHE_TYPE is DEMAND, allow the query to be cached.
If QUERY_CACHE_TYPE is ON, this is the default.
If QUERY_CACHE_TYPE is OFF, do nothing.
|
SQL_NO_CACHE
| Make this query non-cachable, don't allow this query to be stored in the cache. |
