Debian Codegraph @

mysql-test/suite/innodb/r/sys_truncate_large.result

raw
1 set global innodb_file_per_table=0;
2 Warnings:
3 Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release
4 set global innodb_limit_optimistic_insert_debug=2;
5 set unique_checks=0, foreign_key_checks=0;
6 create table t1(f1 int not null)engine=innodb;
7 begin;
8 insert into t1 select * from seq_1_to_8192;
9 insert into t1 select * from seq_1_to_8192;
10 insert into t1 select * from seq_1_to_65536;
11 commit;
12 create table t2(f1 int not null)engine=innodb;
13 insert into t2 select * from seq_1_to_65536;
14 create table t3(f1 int not null)engine=innodb;
15 insert into t3 select * from seq_1_to_65536;
16 CREATE TABLE t4(f1 int not null)engine=innodb;
17 insert into t4 select * from seq_1_to_65536;
18 drop table t2;
19 drop table t4;
20 InnoDB 0 transactions not purged
21 # restart
22 drop table t3, t1;