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

View File Name : ndb_binlog_manual_apply.test

-- source include/have_ndb.inc
-- source include/have_binlog_format_row.inc

# Let's create some Binlog

show variables like '%binlog_format%';

use test;
create table test.t1 (a int primary key, b int) engine=myisam;
create table test.notes (a varchar(1000)) engine=myisam;
reset master;

# Autocommit, transaction per statement

insert into test.notes values ("Scattered single statement transactions");
insert into test.t1 values (1,1);
insert into test.t1 values (2,2);
update test.t1 set b=20 where a=2;
delete from test.t1 where a=1;

insert into test.notes values ("Some composite transactions, starting with diff ops");
begin;
insert into t1 values (10,10);
update t1 set b=11 where a=10;
commit;

begin;
update t1 set b=20 where a=10;
insert into t1 values (21,21);
commit;

begin;
delete from t1 where a=10;
update t1 set b=22 where a=21;
commit;

insert into test.notes values ("Some composite transactions with multiple ops");
begin;
insert into t1 values (30,30);
insert into t1 values (31,31);
insert into t1 values (32,32);
insert into t1 values (33,33);
insert into t1 values (34,34);
insert into t1 values (35,35);
insert into t1 values (36,36);
insert into t1 values (37,37);
insert into t1 values (38,38);
insert into t1 values (39,39);
commit;

begin;
update t1 set b=b+10 where a >= 30;
commit;

begin;
delete from t1 where a >= 30;
commit;

flush logs;

drop table test.t1;
drop table test.notes;

create table test.t1 (a int primary key, b int) engine=ndb;
create table test.notes (a varchar(1000)) engine=ndb;

let $MYSQLD_DATADIR= `select @@datadir;`;
--exec $MYSQL_BINLOG $MYSQLD_DATADIR/mysqld-bin.000001 > $MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql
--exec $MYSQL -uroot < $MYSQLTEST_VARDIR/tmp/ndb_binlog_mysqlbinlog.sql

--sorted_result
select * from test.t1;

drop table test.t1;
drop table test.notes;