Gecko [ www.jdcpatala.org ]

Name	Size	Permission
binlog_multi_engine.result	5.16 KB	-rw-r--r--
ndb_binlog_basic.result	3.78 KB	-rw-r--r--
ndb_binlog_ddl_multi.result	6.87 KB	-rw-r--r--
ndb_binlog_default_format.resu...	754 B	-rw-r--r--
ndb_binlog_discover.result	768 B	-rw-r--r--
ndb_binlog_discover_multi.resu...	861 B	-rw-r--r--
ndb_binlog_eventbuffer.result	668 B	-rw-r--r--
ndb_binlog_flush_log_waits.res...	827 B	-rw-r--r--
ndb_binlog_flush_tables_with_r...	5.5 KB	-rw-r--r--
ndb_binlog_format.result	1.78 KB	-rw-r--r--
ndb_binlog_ignore_db.result	1.75 KB	-rw-r--r--
ndb_binlog_index.result	8.58 KB	-rw-r--r--
ndb_binlog_last_commit_epoch.r...	2.17 KB	-rw-r--r--
ndb_binlog_log_apply_status.re...	1.46 KB	-rw-r--r--
ndb_binlog_log_bin.result	3.23 KB	-rw-r--r--
ndb_binlog_log_reads.result	5.44 KB	-rw-r--r--
ndb_binlog_log_transaction_id....	2.79 KB	-rw-r--r--
ndb_binlog_manual_apply.result	1.46 KB	-rw-r--r--
ndb_binlog_multi.result	3.88 KB	-rw-r--r--
ndb_binlog_purge.result	1.68 KB	-rw-r--r--
ndb_binlog_restore.result	3.05 KB	-rw-r--r--
ndb_binlog_size_based_rotate.r...	2.61 KB	-rw-r--r--
ndb_binlog_test_conflict_flags...	1.46 KB	-rw-r--r--
ndb_binlog_unique_epoch.result	791 B	-rw-r--r--
ndb_binlog_variants.result	4.51 KB	-rw-r--r--

Code Editor : ndb_binlog_log_apply_status.result

create table test.t1(a int primary key) engine=ndb;
set global ndb_log_apply_status=Off;
show variables like '%ndb_log_apply_status%';
Variable_name	Value
ndb_log_apply_status	OFF
reset slave;
reset master;
Should have empty apply status table
select * from mysql.ndb_apply_status;
server_id	epoch	log_name	start_pos	end_pos
Dummy incoming ndb_apply_status updates, should not be logged
begin;
insert into mysql.ndb_apply_status values (555, 12345, 'binlog.000001', 20, 30);
insert into mysql.ndb_apply_status values (666, 67890, 'binlog.000001', 50, 60);
replace into test.t1 values (1);
commit;
Should not see ndb_apply_status updates in the Binlog
show binlog events;
select txt from binlog_stmts where txt like '%binlog.000001%' order by txt;
txt
set global ndb_log_apply_status=On;
show variables like '%ndb_log_apply_status%';
Variable_name	Value
ndb_log_apply_status	ON
reset slave;
reset master;
Should have empty apply status table
select * from mysql.ndb_apply_status;
server_id	epoch	log_name	start_pos	end_pos
Dummy incoming ndb_apply_status updates, should be logged
begin;
insert into mysql.ndb_apply_status values (555, 12345, 'binlog.000001', 20, 30);
insert into mysql.ndb_apply_status values (666, 67890, 'binlog.000001', 50, 60);
replace into test.t1 values (1);
commit;
Should see ndb_apply_status updates in the Binlog
show binlog events;
select txt from binlog_stmts where txt like '%binlog.000001%' order by txt;
txt
set global ndb_log_apply_status=Off;
drop table test.t1;

${this.title}

Code Editor : ndb_binlog_log_apply_status.result