我已经使用此查询SHOW VARIABLES LIKE ‘%query_cache%’;
检查了查询缓存的状态。同样地,存在用于检查query_cache_type
的值的任何查询或命令。如有任何帮助,我们将不胜感激。
尝试以下任何一种:
SHOW GLOBAL VARIABLES LIKE 'query_cache_type';
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| query_cache_type | ON |
+------------------+-------+
SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='query_cache_type';
+------------------+----------------+
| VARIABLE_NAME | VARIABLE_VALUE |
+------------------+----------------+
| QUERY_CACHE_TYPE | ON |
+------------------+----------------+
SELECT @@query_cache_type;
+--------------------+
| @@query_Cache_type |
+--------------------+
| ON |
+--------------------+
SELECT @@query_cache_type = 'ON' AS is_it_on;
+----------+
| is_it_on |
+----------+
| 1 |
+----------+
尝试
SHOW VARIABLES LIKE 'query_cache_type';