Debian Codegraph @

mysql-test/suite/innodb/r/gtid_shutdown.result

raw
1 reset master;
2 create table t1 (col1 int primary key);
3
4 Test GTID with innodb_fast_shutdown = 0
5 ---------------------------------------
6 set global innodb_fast_shutdown = 0;
7 select @@innodb_fast_shutdown as shutdown_mode;
8 shutdown_mode
9 0
10 insert into t1 values (1 + 1);
11 insert into t1 values (5*1 + 1);
12 insert into t1 values (7*1 + 1);
13 # restart
14 select * from t1 order by col1;
15 col1
16 2
17 6
18 8
19 select sum(interval_end - interval_start + 1) as count_gtid
20 from mysql.gtid_executed group by source_uuid;
21 count_gtid
22 4
23
24 Test GTID with innodb_fast_shutdown = 1
25 ---------------------------------------
26 set global innodb_fast_shutdown = 1;
27 select @@innodb_fast_shutdown as shutdown_mode;
28 shutdown_mode
29 1
30 insert into t1 values (2 + 1);
31 insert into t1 values (5*2 + 1);
32 insert into t1 values (7*2 + 1);
33 # restart
34 select * from t1 order by col1;
35 col1
36 2
37 3
38 6
39 8
40 11
41 15
42 select sum(interval_end - interval_start + 1) as count_gtid
43 from mysql.gtid_executed group by source_uuid;
44 count_gtid
45 7
46
47 Test GTID with innodb_fast_shutdown = 2
48 ---------------------------------------
49 set global innodb_fast_shutdown = 2;
50 select @@innodb_fast_shutdown as shutdown_mode;
51 shutdown_mode
52 2
53 insert into t1 values (3 + 1);
54 insert into t1 values (5*3 + 1);
55 insert into t1 values (7*3 + 1);
56 # restart
57 select * from t1 order by col1;
58 col1
59 2
60 3
61 4
62 6
63 8
64 11
65 15
66 16
67 22
68 select sum(interval_end - interval_start + 1) as count_gtid
69 from mysql.gtid_executed group by source_uuid;
70 count_gtid
71 10
72
73 drop table t1;