Debian Codegraph @

mysql-test/suite/galera/t/galera_query_cache.test

raw
1 --source include/have_query_cache.inc
2 --source include/galera_cluster.inc
3 --source include/have_innodb.inc
4
5 --disable_ps2_protocol
6
7 #
8 # Ensure that the query cache behaves properly with respect to Galera
9 #
10 # * in the absence of updates, the query cache does serve cached results
11 # * any cache-invalidating query on the remote node also causes the local cache to be invalidated
12 #
13
14 CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB;
15
16 INSERT INTO t1 VALUES (1);
17
18 --connection node_2
19 RESET QUERY CACHE;
20 FLUSH GLOBAL STATUS;
21
22 #
23 # 1. Cache works
24 #
25
26 SELECT COUNT(*) FROM t1;
27 SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Qcache_queries_in_cache';
28
29 SELECT COUNT(*) FROM t1;
30 SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'Qcache_hits';
31
32 #
33 # 2. Cache is invalidated by DML on remote node
34 #
35
36 --connection node_1
37 INSERT INTO t1 VALUES (2);
38
39 --connection node_2
40 FLUSH GLOBAL STATUS;
41
42 SELECT VARIABLE_VALUE = 0 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Qcache_queries_in_cache';
43 SELECT COUNT(*) FROM t1;
44 SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Qcache_queries_in_cache';
45
46 SELECT VARIABLE_VALUE = 0 FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'Qcache_hits';
47 SELECT COUNT(*) FROM t1;
48 SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'Qcache_hits';
49
50 #
51 # 3. Cache is invalidated by DDL on remote node
52 #
53
54 --connection node_1
55 ALTER TABLE t1 ADD COLUMN f2 INTEGER;
56
57 --connection node_2
58 FLUSH GLOBAL STATUS;
59
60 SELECT VARIABLE_VALUE = 0 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Qcache_queries_in_cache';
61 SELECT COUNT(*) FROM t1;
62 SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Qcache_queries_in_cache';
63
64 SELECT VARIABLE_VALUE = 0 FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'Qcache_hits';
65 SELECT COUNT(*) FROM t1;
66 SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'Qcache_hits';
67
68 DROP TABLE t1;
69
70 --enable_ps2_protocol