drop table if exists t1, t2; drop database if exists mysqltest; create database mysqltest; use mysqltest; drop database mysqltest; use test; reset master; create table t1 (a int primary key) engine=ndb; insert into t1 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); select @max_epoch:=max(epoch)-1 from mysql.ndb_binlog_index; @max_epoch:=max(epoch)-1 # delete from t1; alter table t1 add (b int); Warnings: Warning 1478 Converted FIXED field to DYNAMIC to enable on-line ADD COLUMN insert into t1 values (3,3),(4,4); alter table t1 rename t2; begin; insert into t2 values (1,1),(2,2); update t2 set b=1 where a=3; delete from t2 where a=4; commit; drop table t2; select inserts from mysql.ndb_binlog_index where epoch > @max_epoch and inserts > 5; inserts 10 select deletes from mysql.ndb_binlog_index where epoch > @max_epoch and deletes > 5; deletes 10 select inserts,updates,deletes from mysql.ndb_binlog_index where epoch > @max_epoch and updates > 0; inserts updates deletes 2 1 1 flush logs; purge master logs before now(); create table t1 (a int primary key, b int) engine=ndb; create database mysqltest; use mysqltest; create table t1 (c int, d int primary key) engine=ndb; use test; insert into mysqltest.t1 values (2,1),(2,2); select @max_epoch:=max(epoch)-1 from mysql.ndb_binlog_index; @max_epoch:=max(epoch)-1 # drop table t1; drop database mysqltest; select inserts,updates,deletes from mysql.ndb_binlog_index where epoch > @max_epoch and inserts > 0; inserts updates deletes 2 0 0