38 lines
1.6 KiB
Plaintext
38 lines
1.6 KiB
Plaintext
use test;
|
|
create table t1 (data longblob);
|
|
insert into t1 values (repeat('a', 100));
|
|
set global consensus_checksum=ON;
|
|
insert into t1 values (repeat('a', 10*1024*1024));
|
|
insert into t1 values (repeat('a', 10*1024*1024));
|
|
insert into t1 values (repeat('a', 10*1024*1024));
|
|
insert into t1 values (repeat('a', 10*1024*1024));
|
|
insert into t1 select * from t1 limit 5;
|
|
insert into t1 values (repeat('a', 40*1024*1024));
|
|
set global consensus_checksum=OFF;
|
|
insert into t1 values (repeat('a', 10*1024*1024));
|
|
insert into t1 values (repeat('a', 10*1024*1024));
|
|
insert into t1 values (repeat('a', 10*1024*1024));
|
|
insert into t1 values (repeat('a', 10*1024*1024));
|
|
insert into t1 select * from t1 limit 5;
|
|
insert into t1 values (repeat('a', 40*1024*1024));
|
|
drop table t1;
|
|
set global consensus_log_cache_size=1;
|
|
create table t1 (data longblob);
|
|
insert into t1 values (repeat('a', 100));
|
|
set global consensus_checksum=ON;
|
|
insert into t1 values (repeat('a', 10*1024*1024));
|
|
insert into t1 values (repeat('a', 10*1024*1024));
|
|
insert into t1 values (repeat('a', 10*1024*1024));
|
|
insert into t1 values (repeat('a', 10*1024*1024));
|
|
insert into t1 select * from t1 limit 5;
|
|
insert into t1 values (repeat('a', 40*1024*1024));
|
|
set global consensus_checksum=OFF;
|
|
insert into t1 values (repeat('a', 10*1024*1024));
|
|
insert into t1 values (repeat('a', 10*1024*1024));
|
|
insert into t1 values (repeat('a', 10*1024*1024));
|
|
insert into t1 values (repeat('a', 10*1024*1024));
|
|
insert into t1 select * from t1 limit 5;
|
|
insert into t1 values (repeat('a', 40*1024*1024));
|
|
drop table t1;
|
|
set global consensus_log_cache_size=64*1024*1024;
|