1--source include/have_ndb.inc 2--source include/have_binlog_format_mixed_or_row.inc 3--source suite/ndb_rpl/ndb_master-slave.inc 4 5CREATE TABLE t1 ( 6 id INT UNSIGNED NOT NULL AUTO_INCREMENT, 7 c1 VARCHAR(30), 8 PRIMARY KEY (id) 9 ) ENGINE=ndb; 10 11BEGIN; 12 INSERT INTO t1 (c1) VALUES ('aaa'),('bbb'),('ccc'); 13 DELETE FROM t1 WHERE id IN (1,2,3); 14COMMIT; 15 16--sleep 2 17 18SELECT COUNT(epoch) > 0 FROM mysql.ndb_binlog_index; 19 20CREATE TABLE t2 ( 21 id INT UNSIGNED NOT NULL AUTO_INCREMENT, 22 c1 VARCHAR(30), 23 PRIMARY KEY (id) 24 ) ENGINE=ndb; 25 26set @old_ndb_log_empty_epochs = @@global.ndb_log_empty_epochs; 27set global ndb_log_empty_epochs = on; 28 29BEGIN; 30 INSERT INTO t2 (c1) VALUES ('aaa'),('bbb'),('ccc'); 31 DELETE FROM t2 WHERE id IN (1,2,3); 32COMMIT; 33 34--sleep 2 35 36SELECT COUNT(epoch) > 0 FROM mysql.ndb_binlog_index; 37 38set global ndb_log_empty_epochs = @old_ndb_log_empty_epochs; 39 40--connection master 41DROP TABLE IF EXISTS t1,t2; 42 43--source include/rpl_end.inc 44