Debian Codegraph @

mysql-test/suite/plugins/t/qc_info.test

raw
1 set @save_query_cache_size=@@global.query_cache_size;
2 --source include/default_charset.inc
3 --source qc_info_init.inc
4
5 # test that hits are correctly incremented
6 reset query cache;
7 --disable_cursor_protocol
8 --disable_ps2_protocol
9 select * from t1;
10 select * from t1;
11 --enable_ps2_protocol
12 --enable_cursor_protocol
13 select hits, statement_text from information_schema.query_cache_info;
14
15 drop table t1;
16 # the query was invalidated
17 select statement_schema, statement_text, result_blocks_count, result_blocks_size from information_schema.query_cache_info;
18
19 set global query_cache_size = 0;
20 select * from information_schema.query_cache_info;
21
22 set global query_cache_size= default;
23 set global query_cache_type=default;
24
25 --error ER_PARSE_ERROR
26 show query_cache_info;
27 --error ER_PARSE_ERROR
28 flush query_cache_info;
29
30 set @@global.query_cache_size=@save_query_cache_size;