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_variants.result

create table ba(ks int primary key, st int, lp int) engine = ndb;
insert into ba values (1, 1, 1), (2,2,2), (3,3,3), (4,4,4);
update ba set lp=40 where ks=4;
delete from ba where ks=2;
flush logs;
flush logs;
flush logs;
flush logs;
delete from ba;
show variables like 'ndb_log_update%';
Variable_name	Value
ndb_log_update_as_write	ON
ndb_log_updated_only	ON
select txt from binlog_stmts where txt not like '%ndb_apply_status%' order by txt;
txt
DELETE FROM `test`.`ba` WHERE   @1=2
INSERT INTO `test`.`ba` SET   @1=1   @2=1   @3=1
INSERT INTO `test`.`ba` SET   @1=2   @2=2   @3=2
INSERT INTO `test`.`ba` SET   @1=3   @2=3   @3=3
INSERT INTO `test`.`ba` SET   @1=4   @2=4   @3=4
INSERT INTO `test`.`ba` SET   @1=4   @3=40
select * from ba order by ks;
ks	st	lp
1	1	1
3	3	3
4	4	40
delete from ba;
show variables like 'ndb_log_update%';
Variable_name	Value
ndb_log_update_as_write	ON
ndb_log_updated_only	OFF
select txt from binlog_stmts where txt not like '%ndb_apply_status%' order by txt;
txt
DELETE FROM `test`.`ba` WHERE   @1=2   @2=2   @3=2
INSERT INTO `test`.`ba` SET   @1=1   @2=1   @3=1
INSERT INTO `test`.`ba` SET   @1=2   @2=2   @3=2
INSERT INTO `test`.`ba` SET   @1=3   @2=3   @3=3
INSERT INTO `test`.`ba` SET   @1=4   @2=4   @3=4
INSERT INTO `test`.`ba` SET   @1=4   @2=4   @3=40
select * from ba order by ks;
ks	st	lp
1	1	1
3	3	3
4	4	40
delete from ba;
show variables like 'ndb_log_update%';
Variable_name	Value
ndb_log_update_as_write	OFF
ndb_log_updated_only	ON
select txt from binlog_stmts where txt not like '%ndb_apply_status%' order by txt;
txt
DELETE FROM `test`.`ba` WHERE   @1=2
INSERT INTO `test`.`ba` SET   @1=1   @2=1   @3=1
INSERT INTO `test`.`ba` SET   @1=2   @2=2   @3=2
INSERT INTO `test`.`ba` SET   @1=3   @2=3   @3=3
INSERT INTO `test`.`ba` SET   @1=4   @2=4   @3=4
UPDATE `test`.`ba` WHERE   @1=4   @3=4 SET   @1=4   @3=40
select * from ba order by ks;
ks	st	lp
1	1	1
3	3	3
4	4	40
delete from ba;
show variables like 'ndb_log_update%';
Variable_name	Value
ndb_log_update_as_write	OFF
ndb_log_updated_only	OFF
select txt from binlog_stmts where txt not like '%ndb_apply_status%' order by txt;
txt
DELETE FROM `test`.`ba` WHERE   @1=2   @2=2   @3=2
INSERT INTO `test`.`ba` SET   @1=1   @2=1   @3=1
INSERT INTO `test`.`ba` SET   @1=2   @2=2   @3=2
INSERT INTO `test`.`ba` SET   @1=3   @2=3   @3=3
INSERT INTO `test`.`ba` SET   @1=4   @2=4   @3=4
UPDATE `test`.`ba` WHERE   @1=4   @2=4   @3=4 SET   @1=4   @2=4   @3=40
select * from ba order by ks;
ks	st	lp
1	1	1
3	3	3
4	4	40
drop table ba;
reset master;
show variables like 'ndb_log_update%';
Variable_name	Value
ndb_log_update_as_write	ON
ndb_log_updated_only	ON
create table bah (tst int primary key, cvy int, sqs int, unique(sqs)) engine=ndb;
insert into bah values (1,1,1);
update bah set cvy= 2 where tst=1;
select * from bah order by tst;
tst	cvy	sqs
1	2	1
drop table bah;
Manually applying captured binlog
select * from bah order by tst;
tst	cvy	sqs
1	2	1
drop table bah;
reset master;
show variables like '%log_update%';
Variable_name	Value
ndb_log_update_as_write	ON
ndb_log_updated_only	ON
CREATE TABLE `t1` (
`charId` varchar(60) NOT NULL,
`enumId` enum('A','B','C') NOT NULL,
`val` bigint(20) NOT NULL,
`version` int(11) NOT NULL,
PRIMARY KEY (`charId`,`enumId`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
INSERT INTO t1 VALUES ('', 'A', 0, 1);
FLUSH LOGS;
UPDATE t1 SET val = val + 1 WHERE charId = '';
FLUSH LOGS;
DELETE FROM t1 WHERE charId = '';
FLUSH LOGS;
Manually applying captured binlog
select * from t1;
charId	enumId	val	version
drop table t1;
reset master;
show variables like '%log_update%';
Variable_name	Value
ndb_log_update_as_write	ON
ndb_log_updated_only	ON
create table t1 (pk int not null primary key, name varchar(256)) engine = ndb;
FLUSH LOGS;
insert into t1 values (0, "zero"),(1,"one"),(2,"two"),(3,"three"),(4,"four"),(5,"five"),(6,"six"),(7,"seven"),(8,"eight"),(9,"nine");
select * from t1 order by pk;
pk	name
0	zero
1	one
2	two
3	three
4	four
5	five
6	six
7	seven
8	eight
9	nine
update t1 set name = "even" where pk in (0,2,4,6,8);
update t1 set name = "odd" where pk in (1,3,5,7,9);
delete from t1 where name = "odd";
select * from t1 order by pk;
pk	name
0	even
2	even
4	even
6	even
8	even
FLUSH LOGS;
truncate t1;
insert into t1 values (0, "zero"),(1,"one"),(2,"two"),(3,"three"),(4,"four"),(5,"five"),(6,"six"),(7,"seven"),(8,"eight"),(9,"nine");
select * from t1 order by pk;
pk	name
0	zero
1	one
2	two
3	three
4	four
5	five
6	six
7	seven
8	eight
9	nine
FLUSH LOGS;
Manually applying captured binlog
select * from t1 order by pk;
pk	name
0	even
2	even
4	even
6	even
8	even
drop table t1;

${this.title}

Code Editor : ndb_binlog_variants.result