39 lines
1.3 KiB
Plaintext
39 lines
1.3 KiB
Plaintext
#
|
|
# File purge
|
|
#
|
|
SET @old_innodb_data_file_purge = @@global.innodb_data_file_purge;
|
|
SET @@global.innodb_data_file_purge = ON;
|
|
SET @old_innodb_data_file_purge_max_size = @@global.innodb_data_file_purge_max_size;
|
|
SET @@global.innodb_data_file_purge_max_size = 16;
|
|
SET @old_innodb_data_file_purge_interval = @@global.innodb_data_file_purge_interval;
|
|
SET @@global.innodb_data_file_purge_interval = 10000;
|
|
create database db_x;
|
|
use db_x;
|
|
create table t(id int, col1 varchar(8192))engine = innodb;
|
|
insert into t values(1, repeat('xpchild', 1000));
|
|
insert into t select * from t;
|
|
insert into t select * from t;
|
|
insert into t select * from t;
|
|
insert into t select * from t;
|
|
insert into t select * from t;
|
|
insert into t select * from t;
|
|
insert into t select * from t;
|
|
insert into t select * from t;
|
|
insert into t select * from t;
|
|
insert into t select * from t;
|
|
insert into t select * from t;
|
|
insert into t select * from t;
|
|
insert into t select * from t;
|
|
insert into t select * from t;
|
|
select count(*) from t;
|
|
count(*)
|
|
16384
|
|
drop table t;
|
|
select count(*) from information_schema.innodb_purge_files;
|
|
count(*)
|
|
1
|
|
drop database db_x;
|
|
SET @@global.innodb_data_file_purge=@old_innodb_data_file_purge;
|
|
SET @@global.innodb_data_file_purge_max_size=@old_innodb_data_file_purge_max_size;
|
|
SET @@global.innodb_data_file_purge_interval=@old_innodb_data_file_purge_interval;
|