blob: f8704971878cdca27abd2a8b7cd3b34b2db1e767 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
drop table if exists t1;
create table t1 (a int key) engine=ndb;
reset master;
show binlog events from <binlog_start>;
Log_name Pos Event_type Server_id End_log_pos Info
mysqld-bin.000001 # Incident 1 # #1 (LOST_EVENTS)
mysqld-bin.000001 # Rotate 1 # mysqld-bin.000002;pos=4
PURGE MASTER LOGS TO 'mysqld-bin.000002';
show binlog events from <binlog_start>;
Log_name Pos Event_type Server_id End_log_pos Info
mysqld-bin.000002 # Query 1 # BEGIN
mysqld-bin.000002 # Table_map 1 # table_id: # (test.t1)
mysqld-bin.000002 # Table_map 1 # table_id: # (mysql.ndb_apply_status)
mysqld-bin.000002 # Write_rows 1 # table_id: #
mysqld-bin.000002 # Write_rows 1 # table_id: # flags: STMT_END_F
mysqld-bin.000002 # Query 1 # COMMIT
drop table t1;
|
