Debian Codegraph @

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

raw
1 #
2 # Test that various admin commands from sql_admin.cc
3 # Currently, REPAIR, OPTIMIZE and ANALYZE are tested.
4 # Jira: PXC-390
5 #
6
7 --source include/galera_cluster.inc
8 --source include/have_aria.inc
9
10 --disable_warnings
11 DROP TABLE IF EXISTS t1, t2;
12 DROP TABLE IF EXISTS x1, x2;
13 --enable_warnings
14
15 --connection node_1
16 CREATE TABLE t1 (f1 INTEGER);
17 CREATE TABLE t2 (f1 INT PRIMARY KEY AUTO_INCREMENT, f2 INTEGER);
18 SET GLOBAL wsrep_mode = REPLICATE_MYISAM;
19 CREATE TABLE x1 (f1 INTEGER) ENGINE=MyISAM;
20 CREATE TABLE x2 (f1 INT PRIMARY KEY AUTO_INCREMENT, f2 INTEGER) ENGINE=MyISAM;
21 INSERT INTO t1 VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
22 INSERT INTO x1 VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
23 INSERT INTO t2 (f2) SELECT 1 FROM t1 AS a1, t1 AS a2, t1 AS a3, t1 AS a4;
24 INSERT INTO x2 (f2) VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
25
26 # Wait until all the data from t2 has been replicated
27 --connection node_2
28 --let $wait_condition = SELECT COUNT(*) = 10 FROM x1;
29 --source include/wait_condition.inc
30 --let $wait_condition = SELECT COUNT(*) = 10 FROM x2;
31 --source include/wait_condition.inc
32 --let $wait_condition = SELECT COUNT(*) = 10 FROM t1;
33 --source include/wait_condition.inc
34 --let $wait_condition = SELECT COUNT(*) = 10000 FROM t2;
35 --source include/wait_condition.inc
36
37 --echo # ANALYZE test
38 --connection node_2
39 --let $wsrep_last_committed_before = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed'`
40
41 --connection node_1
42 ANALYZE TABLE t1, t2;
43
44 --connection node_2
45 --let $wait_condition = SELECT VARIABLE_VALUE = $wsrep_last_committed_before + 1 FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed'
46 --source include/wait_condition.inc
47
48 --echo # OPTIMIZE test
49 --connection node_2
50 --let $wsrep_last_committed_before = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed'`
51
52 --connection node_1
53 OPTIMIZE TABLE t1, t2;
54
55 --connection node_2
56 --let $wait_condition = SELECT VARIABLE_VALUE >= $wsrep_last_committed_before + 1 FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed'
57 --source include/wait_condition.inc
58
59 --echo # REPAIR test
60 --connection node_2
61 --let $wsrep_last_committed_before = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed'`
62
63 --connection node_1
64 REPAIR TABLE x1, x2;
65
66 --connection node_2
67 --let $wait_condition = SELECT VARIABLE_VALUE >= $wsrep_last_committed_before + 1 FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed'
68 --source include/wait_condition.inc
69
70 --connection node_2
71 SELECT COUNT(*) = 10 FROM t1;
72 SELECT COUNT(*) = 10 FROM x1;
73 SELECT COUNT(*) = 10000 FROM t2;
74 SELECT COUNT(*) = 10 FROM x2;
75
76 --connection node_1
77 DROP TABLE t1, t2;
78 DROP TABLE x1, x2;
79
80 --echo #
81 --echo # ARIA
82 --echo #
83 --connection node_1
84 CREATE TABLE t1 (f1 INTEGER);
85 CREATE TABLE t2 (f1 INT PRIMARY KEY AUTO_INCREMENT, f2 INTEGER);
86 SET GLOBAL wsrep_mode = REPLICATE_ARIA;
87 CREATE TABLE x1 (f1 INTEGER) ENGINE=ARIA;
88 CREATE TABLE x2 (f1 INT PRIMARY KEY AUTO_INCREMENT, f2 INTEGER) ENGINE=ARIA;
89 INSERT INTO t1 VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
90 INSERT INTO x1 VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
91 INSERT INTO t2 (f2) SELECT 1 FROM t1 AS a1, t1 AS a2, t1 AS a3, t1 AS a4;
92 INSERT INTO x2 (f2) VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
93
94 # Wait until all the data from t2 has been replicated
95 --connection node_2
96 --let $wait_condition = SELECT COUNT(*) = 10 FROM x1;
97 --source include/wait_condition.inc
98 --let $wait_condition = SELECT COUNT(*) = 10 FROM x2;
99 --source include/wait_condition.inc
100 --let $wait_condition = SELECT COUNT(*) = 10 FROM t1;
101 --source include/wait_condition.inc
102 --let $wait_condition = SELECT COUNT(*) = 10000 FROM t2;
103 --source include/wait_condition.inc
104
105 --echo # ANALYZE test
106 --connection node_2
107 --let $wsrep_last_committed_before = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed'`
108
109 --connection node_1
110 ANALYZE TABLE t1, t2;
111
112 --connection node_2
113 --let $wait_condition = SELECT VARIABLE_VALUE = $wsrep_last_committed_before + 1 FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed'
114 --source include/wait_condition.inc
115
116 --echo # OPTIMIZE test
117 --connection node_2
118 --let $wsrep_last_committed_before = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed'`
119
120 --connection node_1
121 OPTIMIZE TABLE t1, t2;
122
123 --connection node_2
124 --let $wait_condition = SELECT VARIABLE_VALUE >= $wsrep_last_committed_before + 1 FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed'
125 --source include/wait_condition.inc
126
127 --echo # REPAIR test
128 --connection node_2
129 --let $wsrep_last_committed_before = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed'`
130
131 --connection node_1
132 REPAIR TABLE x1, x2;
133
134 --connection node_2
135 --let $wait_condition = SELECT VARIABLE_VALUE >= $wsrep_last_committed_before + 1 FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed'
136 --source include/wait_condition.inc
137
138 --connection node_2
139 SELECT COUNT(*) = 10 FROM t1;
140 SELECT COUNT(*) = 10 FROM x1;
141 SELECT COUNT(*) = 10000 FROM t2;
142 SELECT COUNT(*) = 10 FROM x2;
143
144 --connection node_1
145 DROP TABLE t1, t2;
146 DROP TABLE x1, x2;
147
148 --disable_query_log
149 SET GLOBAL wsrep_mode = DEFAULT;
150 --enable_query_log