Debian Codegraph @

mysql-test/suite/innodb/t/sys_truncate_large.test

raw
1 --source include/big_test.inc
2 --source include/have_innodb.inc
3 --source include/have_sequence.inc
4 --source include/not_valgrind.inc
5 --source include/have_debug.inc
6
7 set global innodb_file_per_table=0;
8 set global innodb_limit_optimistic_insert_debug=2;
9 set unique_checks=0, foreign_key_checks=0;
10
11 create table t1(f1 int not null)engine=innodb;
12 begin;
13 insert into t1 select * from seq_1_to_8192;
14 insert into t1 select * from seq_1_to_8192;
15 insert into t1 select * from seq_1_to_65536;
16 commit;
17
18 create table t2(f1 int not null)engine=innodb;
19 insert into t2 select * from seq_1_to_65536;
20
21 create table t3(f1 int not null)engine=innodb;
22 insert into t3 select * from seq_1_to_65536;
23
24 CREATE TABLE t4(f1 int not null)engine=innodb;
25 insert into t4 select * from seq_1_to_65536;
26
27 drop table t2;
28 drop table t4;
29 --source include/wait_all_purged.inc
30 --source include/restart_mysqld.inc
31 drop table t3, t1;