mirror of
https://github.com/MariaDB/server.git
synced 2025-11-26 15:39:48 +01:00
d04fc1af3b
- Fixing the sporadic innodb.sys_defragment, innodb.sys_defragment_fail test case by comparing the file_size
23 lines
1 KiB
Text
23 lines
1 KiB
Text
# restart
|
|
SET GLOBAL innodb_file_per_table= 0;
|
|
Warnings:
|
|
Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release
|
|
SET GLOBAL innodb_limit_optimistic_insert_debug = 2;
|
|
CREATE TABLE t1(f1 INT NOT NULL, f2 INT NOT NULL, f3 INT NOT NULL)ENGINE=InnoDB;
|
|
INSERT INTO t1 SELECT seq, seq, seq FROM seq_1_to_16384;
|
|
SET GLOBAL innodb_file_per_table= default;
|
|
Warnings:
|
|
Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release
|
|
CREATE TABLE t2(f1 INT NOT NULL PRIMARY KEY,f2 VARCHAR(40))ENGINE=InnoDB PARTITION BY KEY() PARTITIONS 256;
|
|
INSERT INTO t1 SELECT seq, seq, seq FROM seq_1_to_16384;
|
|
DROP TABLE t2, t1;
|
|
InnoDB 0 transactions not purged
|
|
set GLOBAL innodb_fast_shutdown= 0;
|
|
# restart
|
|
FOUND 1 /InnoDB: Moving the data from extents 4096 through 22016/ in mysqld.1.err
|
|
FOUND 1 /InnoDB: Defragmentation of system tablespace is successful/ in mysqld.1.err
|
|
select name, file_size<$fsize shrunk
|
|
from information_schema.innodb_sys_tablespaces where space=0;
|
|
name shrunk
|
|
innodb_system 1
|
|
# restart
|