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
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 |
|