Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 DROP TABLE IF EXISTS t1, t2;
4 DROP TABLE IF EXISTS x1, x2;
5 connection node_1;
6 CREATE TABLE t1 (f1 INTEGER);
7 CREATE TABLE t2 (f1 INT PRIMARY KEY AUTO_INCREMENT, f2 INTEGER);
8 SET GLOBAL wsrep_mode = REPLICATE_MYISAM;
9 CREATE TABLE x1 (f1 INTEGER) ENGINE=MyISAM;
10 CREATE TABLE x2 (f1 INT PRIMARY KEY AUTO_INCREMENT, f2 INTEGER) ENGINE=MyISAM;
11 INSERT INTO t1 VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
12 INSERT INTO x1 VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
13 INSERT INTO t2 (f2) SELECT 1 FROM t1 AS a1, t1 AS a2, t1 AS a3, t1 AS a4;
14 INSERT INTO x2 (f2) VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
15 connection node_2;
16 # ANALYZE test
17 connection node_2;
18 connection node_1;
19 ANALYZE TABLE t1, t2;
20 Table Op Msg_type Msg_text
21 test.t1 analyze status Engine-independent statistics collected
22 test.t1 analyze status OK
23 test.t2 analyze status Engine-independent statistics collected
24 test.t2 analyze status OK
25 connection node_2;
26 # OPTIMIZE test
27 connection node_2;
28 connection node_1;
29 OPTIMIZE TABLE t1, t2;
30 Table Op Msg_type Msg_text
31 test.t1 optimize note Table does not support optimize, doing recreate + analyze instead
32 test.t1 optimize status OK
33 test.t2 optimize note Table does not support optimize, doing recreate + analyze instead
34 test.t2 optimize status OK
35 connection node_2;
36 # REPAIR test
37 connection node_2;
38 connection node_1;
39 REPAIR TABLE x1, x2;
40 Table Op Msg_type Msg_text
41 test.x1 repair status OK
42 test.x2 repair status OK
43 connection node_2;
44 connection node_2;
45 SELECT COUNT(*) = 10 FROM t1;
46 COUNT(*) = 10
47 1
48 SELECT COUNT(*) = 10 FROM x1;
49 COUNT(*) = 10
50 1
51 SELECT COUNT(*) = 10000 FROM t2;
52 COUNT(*) = 10000
53 1
54 SELECT COUNT(*) = 10 FROM x2;
55 COUNT(*) = 10
56 1
57 connection node_1;
58 DROP TABLE t1, t2;
59 DROP TABLE x1, x2;
60 #
61 # ARIA
62 #
63 connection node_1;
64 CREATE TABLE t1 (f1 INTEGER);
65 CREATE TABLE t2 (f1 INT PRIMARY KEY AUTO_INCREMENT, f2 INTEGER);
66 SET GLOBAL wsrep_mode = REPLICATE_ARIA;
67 CREATE TABLE x1 (f1 INTEGER) ENGINE=ARIA;
68 CREATE TABLE x2 (f1 INT PRIMARY KEY AUTO_INCREMENT, f2 INTEGER) ENGINE=ARIA;
69 INSERT INTO t1 VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
70 INSERT INTO x1 VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
71 INSERT INTO t2 (f2) SELECT 1 FROM t1 AS a1, t1 AS a2, t1 AS a3, t1 AS a4;
72 INSERT INTO x2 (f2) VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
73 connection node_2;
74 # ANALYZE test
75 connection node_2;
76 connection node_1;
77 ANALYZE TABLE t1, t2;
78 Table Op Msg_type Msg_text
79 test.t1 analyze status Engine-independent statistics collected
80 test.t1 analyze status OK
81 test.t2 analyze status Engine-independent statistics collected
82 test.t2 analyze status OK
83 connection node_2;
84 # OPTIMIZE test
85 connection node_2;
86 connection node_1;
87 OPTIMIZE TABLE t1, t2;
88 Table Op Msg_type Msg_text
89 test.t1 optimize note Table does not support optimize, doing recreate + analyze instead
90 test.t1 optimize status OK
91 test.t2 optimize note Table does not support optimize, doing recreate + analyze instead
92 test.t2 optimize status OK
93 connection node_2;
94 # REPAIR test
95 connection node_2;
96 connection node_1;
97 REPAIR TABLE x1, x2;
98 Table Op Msg_type Msg_text
99 test.x1 repair status OK
100 test.x2 repair status OK
101 connection node_2;
102 connection node_2;
103 SELECT COUNT(*) = 10 FROM t1;
104 COUNT(*) = 10
105 1
106 SELECT COUNT(*) = 10 FROM x1;
107 COUNT(*) = 10
108 1
109 SELECT COUNT(*) = 10000 FROM t2;
110 COUNT(*) = 10000
111 1
112 SELECT COUNT(*) = 10 FROM x2;
113 COUNT(*) = 10
114 1
115 connection node_1;
116 DROP TABLE t1, t2;
117 DROP TABLE x1, x2;