Debian Codegraph @

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

raw
1 # restart
2 SET GLOBAL innodb_file_per_table= 0;
3 Warnings:
4 Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release
5 SET GLOBAL innodb_limit_optimistic_insert_debug = 2;
6 CREATE TABLE t1(f1 INT NOT NULL, f2 INT NOT NULL, f3 INT NOT NULL)ENGINE=InnoDB;
7 INSERT INTO t1 SELECT seq, seq, seq FROM seq_1_to_16384;
8 SET GLOBAL innodb_file_per_table= default;
9 Warnings:
10 Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release
11 CREATE TABLE t2(f1 INT NOT NULL PRIMARY KEY,f2 VARCHAR(40))ENGINE=InnoDB PARTITION BY KEY() PARTITIONS 256;
12 INSERT INTO t1 SELECT seq, seq, seq FROM seq_1_to_16384;
13 DROP TABLE t2, t1;
14 InnoDB 0 transactions not purged
15 set GLOBAL innodb_fast_shutdown= 0;
16 # restart
17 FOUND 1 /InnoDB: Moving the data from extents 4096 through 22016/ in mysqld.1.err
18 FOUND 1 /InnoDB: Defragmentation of system tablespace is successful/ in mysqld.1.err
19 select name, file_size<$fsize shrunk
20 from information_schema.innodb_sys_tablespaces where space=0;
21 name shrunk
22 innodb_system 1
23 # restart