⚝
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_purge.result
Test binlog purging, especially 'automatic' purging Test expire-log-days handling as part of normal operation Logs are rotated as part of transaction COMMIT (to avoid a transaction being split across 2 files), rotation checks expire-logs-days to decide whether to purge, and purging calls into the Ndb handler to think about deleting rows from ndb_binlog_index. The delete from ndb_binlog_index is itself a SQL statement executing *during* the COMMIT of some other transaction, potentially in some other engine. Don't want to think about that too closely show variables like 'log_bin'; Variable_name Value log_bin ON use test; create table test.tm (b varchar(1000)) engine=myisam; create table test.tn (b varchar(1000)) engine=ndb; create procedure go_forth_and_make_binlog(loops int) begin set @x = 0; repeat insert into test.tm values (repeat('C', 1000)); insert into test.tm values (repeat('C', 1000)); insert into test.tm values (repeat('C', 1000)); insert into test.tm values (repeat('C', 1000)); insert into test.tm values (repeat('C', 1000)); insert into test.tm values (repeat('C', 1000)); insert into test.tm values (repeat('C', 1000)); insert into test.tn values (repeat('N', 1000)); delete from test.tm; delete from test.tn; select sleep(0.1); set @x = @x + 1; until @x = loops end repeat; end% call go_forth_and_make_binlog(40); Now test binlog expiration at startup... Disable the 'immediate expiration' mechanism set global debug=''; Create some binlogs... call go_forth_and_make_binlog(40); Now restart, should re-pickup the expire-log-days debug setting from the config file, and perform expire-logs action at restart... # restart drop procedure go_forth_and_make_binlog; drop table tm; drop table tn;