query_cache_type queries the cache type.
Note
At present, this variable does not take effect.
| Attribute | Description |
|---|---|
| Type | Varchar |
| Default value | OFF |
| Value range | OFF: specifies not to cache or retrieve results.ON: specifies to cache all results except for those of the SELECT SQL_NO_CACHE ... query.DEMAND: specifies to cache only the query results of the SELECT SQL_CACHE ... query. |
| Effective scope | Global |
| Modifiable | You can set the variable when you create a tenant. After the tenant is created, you cannot modify the variable by executing SQL statements. For more information, see Set variables. |