129 lines
2.6 KiB
Plaintext
129 lines
2.6 KiB
Plaintext
call mtr.add_suppression("innodb-rollback-segments");
|
|
#
|
|
# WL7943 Implement INFORMATION_SCHEMA.FILES
|
|
#
|
|
# Mysqld is initialized in this test with with:
|
|
# --innodb_rollback_segments=1
|
|
# --bootstrap --innodb_page_size=4k
|
|
SET default_storage_engine=InnoDB;
|
|
CREATE TABLE t1 (a serial, b text, c text);
|
|
==I_S.FILES== ==I_S.FILES==
|
|
FILE_ID 0
|
|
TABLESPACE_NAME innodb_system
|
|
FILE_NAME MYSQLD_DATADIR/ibdata1
|
|
FILE_TYPE TABLESPACE
|
|
STATUS NORMAL
|
|
ENGINE InnoDB
|
|
EXTENT_SIZE 1048576
|
|
MAXIMUM_SIZE NULL
|
|
AUTOEXTEND_SIZE 67108864
|
|
==I_S.FILES== ==I_S.FILES==
|
|
FILE_ID 4294967278
|
|
TABLESPACE_NAME innodb_undo_002
|
|
FILE_NAME MYSQLD_DATADIR/undo_002
|
|
FILE_TYPE UNDO LOG
|
|
STATUS NORMAL
|
|
ENGINE InnoDB
|
|
EXTENT_SIZE 1048576
|
|
MAXIMUM_SIZE NULL
|
|
==I_S.FILES== ==I_S.FILES==
|
|
FILE_ID 4294967279
|
|
TABLESPACE_NAME innodb_undo_001
|
|
FILE_NAME MYSQLD_DATADIR/undo_001
|
|
FILE_TYPE UNDO LOG
|
|
STATUS NORMAL
|
|
ENGINE InnoDB
|
|
EXTENT_SIZE 1048576
|
|
MAXIMUM_SIZE NULL
|
|
==I_S.FILES== ==I_S.FILES==
|
|
TABLESPACE_NAME innodb_temporary
|
|
FILE_NAME MYSQLD_DATADIR/ibtmp1
|
|
FILE_TYPE TEMPORARY
|
|
STATUS NORMAL
|
|
ENGINE InnoDB
|
|
EXTENT_SIZE 1048576
|
|
INITIAL_SIZE 12582912
|
|
MAXIMUM_SIZE NULL
|
|
AUTOEXTEND_SIZE 67108864
|
|
==I_S.FILES== ==I_S.FILES==
|
|
TABLESPACE_NAME test/t1
|
|
FILE_NAME MYSQLD_DATADIR/test/t1.ibd
|
|
FILE_TYPE TABLESPACE
|
|
STATUS NORMAL
|
|
ENGINE InnoDB
|
|
DATA_FREE 0
|
|
FREE_EXTENTS 0
|
|
TOTAL_EXTENTS 0
|
|
EXTENT_SIZE 1048576
|
|
INITIAL_SIZE 28672
|
|
MAXIMUM_SIZE NULL
|
|
AUTOEXTEND_SIZE 1048576
|
|
#
|
|
# Populate t1 with about 3MB of data
|
|
#
|
|
CREATE PROCEDURE populate_t1()
|
|
BEGIN
|
|
DECLARE i INT DEFAULT 1;
|
|
while (i <= 6000) DO
|
|
INSERT INTO t1 (b,c) VALUES (repeat('b', 250), repeat('c', 250));
|
|
SET i = i + 1;
|
|
END WHILE;
|
|
END |
|
|
BEGIN;
|
|
CALL populate_t1();
|
|
FLUSH TABLE t1;
|
|
==I_S.FILES== ==I_S.FILES==
|
|
TABLESPACE_NAME test/t1
|
|
FILE_NAME MYSQLD_DATADIR/test/t1.ibd
|
|
FILE_TYPE TABLESPACE
|
|
STATUS NORMAL
|
|
ENGINE InnoDB
|
|
DATA_FREE 4194304
|
|
FREE_EXTENTS 1
|
|
TOTAL_EXTENTS 12
|
|
EXTENT_SIZE 1048576
|
|
INITIAL_SIZE 28672
|
|
MAXIMUM_SIZE NULL
|
|
AUTOEXTEND_SIZE 1048576
|
|
#
|
|
# Populate t1 with another 3MB of data
|
|
#
|
|
CALL populate_t1();
|
|
FLUSH TABLE t1;
|
|
==I_S.FILES== ==I_S.FILES==
|
|
TABLESPACE_NAME test/t1
|
|
FILE_NAME MYSQLD_DATADIR/test/t1.ibd
|
|
FILE_TYPE TABLESPACE
|
|
STATUS NORMAL
|
|
ENGINE InnoDB
|
|
DATA_FREE 4194304
|
|
FREE_EXTENTS 1
|
|
TOTAL_EXTENTS 16
|
|
EXTENT_SIZE 1048576
|
|
INITIAL_SIZE 28672
|
|
MAXIMUM_SIZE NULL
|
|
AUTOEXTEND_SIZE 4194304
|
|
#
|
|
# Delete the half of the records.
|
|
#
|
|
DELETE FROM t1 WHERE a % 2 = 1;
|
|
FLUSH TABLE t1;
|
|
==I_S.FILES== ==I_S.FILES==
|
|
TABLESPACE_NAME test/t1
|
|
FILE_NAME MYSQLD_DATADIR/test/t1.ibd
|
|
FILE_TYPE TABLESPACE
|
|
STATUS NORMAL
|
|
ENGINE InnoDB
|
|
DATA_FREE 4194304
|
|
FREE_EXTENTS 1
|
|
TOTAL_EXTENTS 16
|
|
EXTENT_SIZE 1048576
|
|
INITIAL_SIZE 28672
|
|
MAXIMUM_SIZE NULL
|
|
AUTOEXTEND_SIZE 4194304
|
|
#
|
|
# Cleanup
|
|
#
|
|
DROP TABLE t1;
|
|
DROP PROCEDURE populate_t1;
|