Default page

Your IP: 216.73.216.124
Server IP: 50.28.103.30
Server: Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software: nginx/1.28.0
PHP Version: 8.3.12
Buat File | Buat Folder

Dir : ~/www/server/mysql/mysql-test/suite/ndb_binlog/r/

Edit File: 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;