blob: f2f58580ca2353cfad2279adecef0a4516425e4c (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
SHOW GLOBAL VARIABLES LIKE 'query_cache_type';
Variable_name Value
query_cache_type OFF
SET GLOBAL query_cache_type=ON;
ERROR HY000: Query cache is disabled; restart the server with query_cache_type=1 to enable it
SET GLOBAL query_cache_type=DEMAND;
ERROR HY000: Query cache is disabled; restart the server with query_cache_type=1 to enable it
SET GLOBAL query_cache_type=OFF;
ERROR HY000: Query cache is disabled; restart the server with query_cache_type=1 to enable it
SET GLOBAL query_cache_size=1024*1024;
SHOW GLOBAL VARIABLES LIKE 'query_cache_size';
Variable_name Value
query_cache_size 1048576
SET GLOBAL query_cache_size=0;
|
