⚝
One Hat Cyber Team
⚝
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
Eksekusi
Dir :
~
/
www
/
server
/
mysql
/
mysql-test
/
suite
/
ndb_binlog
/
r
/
View File Name :
ndb_binlog_basic.result
drop table if exists t1, t2; drop database if exists mysqltest; create database mysqltest; use mysqltest; drop database mysqltest; use test; reset master; create table t1 (a int primary key) engine=ndb; insert into t1 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); select @max_epoch:=max(epoch)-1 from mysql.ndb_binlog_index; @max_epoch:=max(epoch)-1 # delete from t1; alter table t1 add (b int); Warnings: Warning 1478 Converted FIXED field 'b' to DYNAMIC to enable on-line ADD COLUMN insert into t1 values (3,3),(4,4); alter table t1 rename t2; begin; insert into t2 values (1,1),(2,2); update t2 set b=1 where a=3; delete from t2 where a=4; commit; drop table t2; select inserts from mysql.ndb_binlog_index where epoch > @max_epoch and inserts > 5; inserts 10 select deletes from mysql.ndb_binlog_index where epoch > @max_epoch and deletes > 5; deletes 10 select inserts,updates,deletes from mysql.ndb_binlog_index where epoch > @max_epoch and updates > 0; inserts updates deletes 2 1 1 flush logs; purge master logs before now(); Warnings: Warning 1868 file ./mysqld-bin.000002 was not purged because it is the active log file. create table t1 (a int primary key, b int) engine=ndb; create database mysqltest; use mysqltest; create table t1 (c int, d int primary key) engine=ndb; use test; insert into mysqltest.t1 values (2,1),(2,2); select @max_epoch:=max(epoch)-1 from mysql.ndb_binlog_index; @max_epoch:=max(epoch)-1 # drop table t1; drop database mysqltest; select inserts,updates,deletes from mysql.ndb_binlog_index where epoch > @max_epoch and inserts > 0; inserts updates deletes 2 0 0 create table t1 (c1 int not null primary key, c2 blob default null) engine=ndbcluster default charset=latin1; insert into t1 values (1, null), (2, null), (3, null), (4, null); insert into t1 select c1+4,c2 from t1; insert into t1 select c1+8,c2 from t1; insert into t1 select c1+16,c2 from t1; insert into t1 select c1+32,c2 from t1; insert into t1 select c1+64,c2 from t1; insert into t1 select c1+128,c2 from t1; insert into t1 select c1+256,c2 from t1; insert into t1 select c1+512,c2 from t1; optimize table t1; Table Op Msg_type Msg_text test.t1 optimize status OK drop table t1; SET GLOBAL ndb_log_empty_epochs=ON; SHOW VARIABLES LIKE 'ndb_log_empty_epochs'; Variable_name Value ndb_log_empty_epochs ON create table t1 (c1 int not null primary key, c2 blob default null) engine=ndbcluster default charset=latin1; insert into t1 values (1, null); show binlog events; update t1 set c2=null; select * from t1; c1 c2 1 NULL show binlog events; optimize table t1; Table Op Msg_type Msg_text test.t1 optimize status OK select * from t1; c1 c2 1 NULL drop table t1; create table t1 (c1 int not null primary key, c2 varchar(1024) default null) engine=ndbcluster default charset=latin1; insert into t1 values (3, null); select * from t1; c1 c2 3 NULL show binlog events; optimize table t1; Table Op Msg_type Msg_text test.t1 optimize status OK select * from t1; c1 c2 3 NULL drop table t1; SET GLOBAL ndb_log_empty_epochs=OFF; show binlog events; SHOW VARIABLES LIKE 'ndb_log_empty_epochs'; Variable_name Value ndb_log_empty_epochs OFF create table t1 (c1 int not null primary key, c2 blob default null) engine=ndbcluster default charset=latin1; insert into t1 values (1, null); show binlog events; update t1 set c2=null; select * from t1; c1 c2 1 NULL show binlog events; optimize table t1; Table Op Msg_type Msg_text test.t1 optimize status OK select * from t1; c1 c2 1 NULL drop table t1; create table t1 (c1 int not null primary key, c2 varchar(1024) default null) engine=ndbcluster default charset=latin1; insert into t1 values (3, null); select * from t1; c1 c2 3 NULL show binlog events; optimize table t1; Table Op Msg_type Msg_text test.t1 optimize status OK select * from t1; c1 c2 3 NULL drop table t1; SET GLOBAL ndb_log_empty_epochs=OFF; show binlog events;