2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
11
create table t1(n int not null auto_increment primary key)ENGINE=NDB;
12
insert into t1 values (NULL);
14
create table t1 (word char(20) not null)ENGINE=NDB;
15
load data infile 'LOAD_FILE' into table t1 ignore 1 lines;
16
select count(*) from t1;
20
Log_name Pos Event_type Server_id End_log_pos Info
21
master-bin.000001 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4
22
master-bin.000001 # Query 1 # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=NDB
23
master-bin.000001 # Query 1 # BEGIN
24
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
25
master-bin.000001 # Table_map 1 # table_id: # (mysql.ndb_apply_status)
26
master-bin.000001 # Write_rows 1 # table_id: #
27
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
28
master-bin.000001 # Query 1 # COMMIT
29
master-bin.000001 # Query 1 # use `test`; drop table t1
30
master-bin.000001 # Query 1 # use `test`; create table t1 (word char(20) not null)ENGINE=NDB
31
master-bin.000001 # Query 1 # BEGIN
32
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
33
master-bin.000001 # Table_map 1 # table_id: # (mysql.ndb_apply_status)
34
master-bin.000001 # Write_rows 1 # table_id: #
35
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
36
master-bin.000001 # Query 1 # COMMIT
37
show binlog events from 106 limit 1;
38
Log_name Pos Event_type Server_id End_log_pos Info
39
master-bin.000001 # Query 1 # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=NDB
40
show binlog events from 106 limit 2;
41
Log_name Pos Event_type Server_id End_log_pos Info
42
master-bin.000001 # Query 1 # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=NDB
43
master-bin.000001 # Query 1 # BEGIN
44
show binlog events from 106 limit 2,1;
45
Log_name Pos Event_type Server_id End_log_pos Info
46
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
48
create table t3 (a int)ENGINE=NDB;
49
select * from t1 order by 1 asc;
120
select * from t1 order by 1 asc;
192
include/stop_slave.inc
193
include/start_slave.inc
194
create table t2 (n int)ENGINE=NDB;
195
insert into t2 values (1);
196
show binlog events from <binlog_start>;
197
Log_name Pos Event_type Server_id End_log_pos Info
198
master-bin.000001 # Query # # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=NDB
199
master-bin.000001 # Query # # BEGIN
200
master-bin.000001 # Table_map # # table_id: # (test.t1)
201
master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
202
master-bin.000001 # Write_rows # # table_id: #
203
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
204
master-bin.000001 # Query # # COMMIT
205
master-bin.000001 # Query # # use `test`; drop table t1
206
master-bin.000001 # Query # # use `test`; create table t1 (word char(20) not null)ENGINE=NDB
207
master-bin.000001 # Query # # BEGIN
208
master-bin.000001 # Table_map # # table_id: # (test.t1)
209
master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
210
master-bin.000001 # Write_rows # # table_id: #
211
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
212
master-bin.000001 # Query # # COMMIT
213
master-bin.000001 # Rotate # # master-bin.000002;pos=4
214
show binlog events in 'master-bin.000002';
215
Log_name Pos Event_type Server_id End_log_pos Info
216
master-bin.000002 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4
217
master-bin.000002 # Query 1 # use `test`; create table t3 (a int)ENGINE=NDB
218
master-bin.000002 # Query 1 # use `test`; create table t2 (n int)ENGINE=NDB
219
master-bin.000002 # Query 1 # BEGIN
220
master-bin.000002 # Table_map 1 # table_id: # (test.t2)
221
master-bin.000002 # Table_map 1 # table_id: # (mysql.ndb_apply_status)
222
master-bin.000002 # Write_rows 1 # table_id: #
223
master-bin.000002 # Write_rows 1 # table_id: # flags: STMT_END_F
224
master-bin.000002 # Query 1 # COMMIT
233
show binlog events in 'slave-bin.000001' from 4;
234
Log_name Pos Event_type Server_id End_log_pos Info
235
slave-bin.000001 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4
236
slave-bin.000001 # Query 1 # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=NDB
237
slave-bin.000001 # Query 2 # BEGIN
238
slave-bin.000001 # Table_map 2 # table_id: # (test.t1)
239
slave-bin.000001 # Table_map 2 # table_id: # (mysql.ndb_apply_status)
240
slave-bin.000001 # Write_rows 2 # table_id: #
241
slave-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
242
slave-bin.000001 # Query 2 # COMMIT
243
slave-bin.000001 # Query 1 # use `test`; drop table t1
244
slave-bin.000001 # Query 1 # use `test`; create table t1 (word char(20) not null)ENGINE=NDB
245
slave-bin.000001 # Query 2 # BEGIN
246
slave-bin.000001 # Table_map 2 # table_id: # (test.t1)
247
slave-bin.000001 # Table_map 2 # table_id: # (mysql.ndb_apply_status)
248
slave-bin.000001 # Write_rows 2 # table_id: #
249
slave-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
250
slave-bin.000001 # Query 2 # COMMIT
251
slave-bin.000001 # Query 1 # use `test`; create table t3 (a int)ENGINE=NDB
252
slave-bin.000001 # Rotate 2 # slave-bin.000002;pos=4
253
show binlog events in 'slave-bin.000002' from 4;
254
Log_name Pos Event_type Server_id End_log_pos Info
255
slave-bin.000002 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4
256
slave-bin.000002 # Query 1 # use `test`; create table t2 (n int)ENGINE=NDB
257
slave-bin.000002 # Query 2 # BEGIN
258
slave-bin.000002 # Table_map 2 # table_id: # (test.t2)
259
slave-bin.000002 # Table_map 2 # table_id: # (mysql.ndb_apply_status)
260
slave-bin.000002 # Write_rows 2 # table_id: #
261
slave-bin.000002 # Write_rows 1 # table_id: # flags: STMT_END_F
262
slave-bin.000002 # Query 2 # COMMIT
265
Master_Host 127.0.0.1
267
Master_Port MASTER_PORT
269
Master_Log_File master-bin.000002
270
Read_Master_Log_Pos 623
273
Relay_Master_Log_File master-bin.000002
275
Slave_SQL_Running Yes
279
Replicate_Ignore_Table #
280
Replicate_Wild_Do_Table
281
Replicate_Wild_Ignore_Table
285
Exec_Master_Log_Pos 623
290
Master_SSL_Allowed No
296
Seconds_Behind_Master #
297
Master_SSL_Verify_Server_Cert No
302
show binlog events in 'slave-bin.000005' from 4;
303
ERROR HY000: Error when executing command SHOW BINLOG EVENTS: Could not find target log
308
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
311
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
313
create table t1(a int auto_increment primary key, b int);
314
insert into t1 values (NULL, 1);
316
insert into t1 values (NULL, last_insert_id()), (NULL, last_insert_id());
317
show binlog events from <binlog_start>;
318
Log_name Pos Event_type Server_id End_log_pos Info
319
master-bin.000001 # Query # # use `test`; create table t1(a int auto_increment primary key, b int)
320
master-bin.000001 # Query # # BEGIN
321
master-bin.000001 # Table_map # # table_id: # (test.t1)
322
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
323
master-bin.000001 # Query # # COMMIT
324
master-bin.000001 # Query # # BEGIN
325
master-bin.000001 # Table_map # # table_id: # (test.t1)
326
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
327
master-bin.000001 # Query # # COMMIT