drop table if exists t1,t2; create table t2 (a int key) engine=ndb; alter table t2 rename t1; reset master; select * from t1; a 1 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;
Name | Type | Size | Permission | Actions |
---|---|---|---|---|
ndb_binlog_basic.result | File | 1.46 KB | 0644 |
|
ndb_binlog_ddl_multi.result | File | 6.95 KB | 0644 |
|
ndb_binlog_discover.result | File | 786 B | 0644 |
|
ndb_binlog_format.result | File | 1.79 KB | 0644 |
|
ndb_binlog_ignore_db.result | File | 1.77 KB | 0644 |
|
ndb_binlog_log_apply_status.result | File | 1.46 KB | 0644 |
|
ndb_binlog_log_bin.result | File | 3.26 KB | 0644 |
|
ndb_binlog_multi.result | File | 3.91 KB | 0644 |
|
ndb_binlog_restore.result | File | 3.08 KB | 0644 |
|
ndb_binlog_unique_epoch.result | File | 791 B | 0644 |
|
ndb_binlog_variants.result | File | 2.79 KB | 0644 |
|