Debian Codegraph @

mysql-test/suite/galera/r/galera_query_cache.result

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB;
4 INSERT INTO t1 VALUES (1);
5 connection node_2;
6 RESET QUERY CACHE;
7 FLUSH GLOBAL STATUS;
8 SELECT COUNT(*) FROM t1;
9 COUNT(*)
10 1
11 SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Qcache_queries_in_cache';
12 VARIABLE_VALUE = 1
13 1
14 SELECT COUNT(*) FROM t1;
15 COUNT(*)
16 1
17 SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'Qcache_hits';
18 VARIABLE_VALUE = 1
19 1
20 connection node_1;
21 INSERT INTO t1 VALUES (2);
22 connection node_2;
23 FLUSH GLOBAL STATUS;
24 SELECT VARIABLE_VALUE = 0 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Qcache_queries_in_cache';
25 VARIABLE_VALUE = 0
26 1
27 SELECT COUNT(*) FROM t1;
28 COUNT(*)
29 2
30 SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Qcache_queries_in_cache';
31 VARIABLE_VALUE = 1
32 1
33 SELECT VARIABLE_VALUE = 0 FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'Qcache_hits';
34 VARIABLE_VALUE = 0
35 1
36 SELECT COUNT(*) FROM t1;
37 COUNT(*)
38 2
39 SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'Qcache_hits';
40 VARIABLE_VALUE = 1
41 1
42 connection node_1;
43 ALTER TABLE t1 ADD COLUMN f2 INTEGER;
44 connection node_2;
45 FLUSH GLOBAL STATUS;
46 SELECT VARIABLE_VALUE = 0 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Qcache_queries_in_cache';
47 VARIABLE_VALUE = 0
48 1
49 SELECT COUNT(*) FROM t1;
50 COUNT(*)
51 2
52 SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Qcache_queries_in_cache';
53 VARIABLE_VALUE = 1
54 1
55 SELECT VARIABLE_VALUE = 0 FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'Qcache_hits';
56 VARIABLE_VALUE = 0
57 1
58 SELECT COUNT(*) FROM t1;
59 COUNT(*)
60 2
61 SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'Qcache_hits';
62 VARIABLE_VALUE = 1
63 1
64 DROP TABLE t1;