Debian Codegraph @

mysql-test/suite/binlog/r/binlog_gtid_index.result

raw
1 SET GLOBAL binlog_gtid_index= 0;
2 SET GLOBAL binlog_gtid_index= 1;
3 SET @gtid1= @@gtid_binlog_pos;
4 CREATE TABLE t1 (a INT PRIMARY KEY);
5 SET @gtid2= @@gtid_binlog_pos;
6 INSERT INTO t1 VALUES (1);
7 SET @gtid3= @@gtid_binlog_pos;
8 INSERT INTO t1 VALUES (2);
9 INSERT INTO t1 VALUES (3);
10 INSERT INTO t1 VALUES (4);
11 SET @gtid4= @@gtid_binlog_pos;
12 INSERT INTO t1 VALUES (5);
13 SET @gtid5= @@gtid_binlog_pos;
14 SET @gtid6= @@gtid_binlog_pos;
15 INSERT INTO t1 VALUES (106);
16 INSERT INTO t1 VALUES (107);
17 Ok
18 1
19 Ok
20 1
21 Ok
22 1
23 Ok
24 1
25 Ok
26 1
27 Ok
28 1
29 FLUSH BINARY LOGS;
30 Ok
31 1
32 Ok
33 1
34 Ok
35 1
36 Ok
37 1
38 Ok
39 1
40 Ok
41 1
42 *** Test that purge deletes the gtid index files. ***
43 FLUSH BINARY LOGS;
44 INSERT INTO t1 VALUES (200);
45 FLUSH BINARY LOGS;
46 INSERT INTO t1 VALUES (201);
47 FLUSH BINARY LOGS;
48 INSERT INTO t1 VALUES (202);
49 PURGE BINARY LOGS TO 'FILE';
50 *** Test missed index lookup due to missing or corrupt index file.
51 FLUSH NO_WRITE_TO_BINLOG BINARY LOGS;
52 INSERT INTO t1 VALUES (301);
53 INSERT INTO t1 VALUES (302);
54 INSERT INTO t1 VALUES (303);
55 SET @gtid_pos= @@GLOBAL.gtid_binlog_pos;
56 INSERT INTO t1 VALUES (304);
57 INSERT INTO t1 VALUES (305);
58 FLUSH NO_WRITE_TO_BINLOG GLOBAL STATUS;
59 +++ Initial status:
60 SHOW STATUS LIKE 'binlog_gtid_index_%';
61 Variable_name Value
62 Binlog_gtid_index_hit 0
63 Binlog_gtid_index_miss 0
64 +++ GTID Lookup in good index.
65 Gtid_Lookup_Ok
66 1
67 SHOW STATUS LIKE 'binlog_gtid_index_%';
68 Variable_name Value
69 Binlog_gtid_index_hit 1
70 Binlog_gtid_index_miss 0
71 +++ GTID Lookup, index file is missing.
72 Gtid_Lookup_Ok
73 1
74 SHOW STATUS LIKE 'binlog_gtid_index_%';
75 Variable_name Value
76 Binlog_gtid_index_hit 1
77 Binlog_gtid_index_miss 1
78 FLUSH NO_WRITE_TO_BINLOG BINARY LOGS;
79 INSERT INTO t1 VALUES (306);
80 SET @gtid_pos= @@GLOBAL.gtid_binlog_pos;
81 INSERT INTO t1 VALUES (307);
82 INSERT INTO t1 VALUES (308);
83 FLUSH NO_WRITE_TO_BINLOG BINARY LOGS;
84 +++ GTID Lookup, first page of index is corrupt.
85 Gtid_Lookup_Ok
86 1
87 SHOW STATUS LIKE 'binlog_gtid_index_%';
88 Variable_name Value
89 Binlog_gtid_index_hit 1
90 Binlog_gtid_index_miss 2
91 SET @old_page_size= @@GLOBAL.binlog_gtid_index_page_size;
92 SET @old_span_min= @@GLOBAL.binlog_gtid_index_span_min;
93 SET GLOBAL binlog_gtid_index_page_size= 64;
94 SET GLOBAL binlog_gtid_index_span_min= 1;
95 FLUSH NO_WRITE_TO_BINLOG BINARY LOGS;
96 INSERT INTO t1 VALUES (310);
97 INSERT INTO t1 VALUES (311);
98 INSERT INTO t1 VALUES (312);
99 SET @gtid_pos= @@GLOBAL.gtid_binlog_pos;
100 INSERT INTO t1 VALUES (313);
101 INSERT INTO t1 VALUES (314);
102 INSERT INTO t1 VALUES (315);
103 INSERT INTO t1 VALUES (316);
104 FLUSH NO_WRITE_TO_BINLOG BINARY LOGS;
105 SET GLOBAL binlog_gtid_index_page_size= @old_page_size;
106 SET GLOBAL binlog_gtid_index_span_min= @old_span_min;
107 +++ GTID Lookup, root page of index is corrupt.
108 Gtid_Lookup_Ok
109 1
110 SHOW STATUS LIKE 'binlog_gtid_index_%';
111 Variable_name Value
112 Binlog_gtid_index_hit 1
113 Binlog_gtid_index_miss 3
114 *** Test BINLOG_GTID_POS() with too-large offset.
115 FLUSH NO_WRITE_TO_BINLOG BINARY LOGS;
116 INSERT INTO t1 VALUES (401);
117 INSERT INTO t1 VALUES (402);
118 +++ Test the hot index.
119 SELECT BINLOG_GTID_POS('FILE', 100000000);
120 BINLOG_GTID_POS('FILE', 100000000)
121 NULL
122 SHOW STATUS LIKE 'binlog_gtid_index_%';
123 Variable_name Value
124 Binlog_gtid_index_hit 2
125 Binlog_gtid_index_miss 3
126 FLUSH NO_WRITE_TO_BINLOG BINARY LOGS;
127 +++ Test the cold index.
128 SELECT BINLOG_GTID_POS('FILE', 100000000);
129 BINLOG_GTID_POS('FILE', 100000000)
130 NULL
131 SHOW STATUS LIKE 'binlog_gtid_index_%';
132 Variable_name Value
133 Binlog_gtid_index_hit 3
134 Binlog_gtid_index_miss 3
135 DROP TABLE t1;