Description
The query_cache_type variable is used to query the query cache type.
Note
This variable is currently not in effect.
Privilege requirements
Query variables
Users of the
systenant and all user tenants can execute theSHOW VARIABLESstatement or view theinformation_schema.GLOBAL_VARIABLESview (MySQL mode) to query the value of a global system variable.Modify variables
systenantYou can directly modify the value of a global system variable in the
systenant.MySQL user tenant
You must have the
SUPERorALTER SYSTEMprivilege to modify the value of a global system variable.Oracle user tenant
You must have the
ALTER SYSTEMprivilege to modify the value of a global system variable.
Attributes
| Attribute | Description |
|---|---|
| Type | varchar |
| Default value | OFF |
| Value range | SELECT SQL_NO_CACHE ... statement.SELECT SQL_CACHE ... statement. |
| Scope | Global |
| Modifiable | This variable can be specified when a tenant is created. After a tenant is created, you cannot modify the value of this variable through an SQL statement. For more information, see Set variables. |