Description:
The documentation page
https://dev.mysql.com/doc/refman/5.7/en/innodb-page-compression.html
says
Page compression metadata is found in the INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES table, in four columns that were added with the introduction of the Transparent Page Compression feature:
FS_BLOCK_SIZE: The file system block size, which is the unit size used for hole punching.
FILE_SIZE: The apparent size of the file, which represents the maximum size of the file, uncompressed.
ALLOCATED_SIZE: The actual size of the file, which is the amount of space allocated on disk.
COMPRESSION: The current tablespace setting for page compression (Zlib, Lz4, or None). A table may contain a mix of pages with different compression settings.
but
show create table INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES\G
*************************** 1. row ***************************
Table: INNODB_SYS_TABLESPACES
Create Table: CREATE TEMPORARY TABLE `INNODB_SYS_TABLESPACES` (
`SPACE` int(11) unsigned NOT NULL DEFAULT '0',
`NAME` varchar(655) NOT NULL DEFAULT '',
`FLAG` int(11) unsigned NOT NULL DEFAULT '0',
`FILE_FORMAT` varchar(10) DEFAULT NULL,
`ROW_FORMAT` varchar(22) DEFAULT NULL,
`PAGE_SIZE` int(11) unsigned NOT NULL DEFAULT '0',
`ZIP_PAGE_SIZE` int(11) unsigned NOT NULL DEFAULT '0',
`SPACE_TYPE` varchar(10) DEFAULT NULL,
`FS_BLOCK_SIZE` int(11) unsigned NOT NULL DEFAULT '0',
`FILE_SIZE` bigint(21) unsigned NOT NULL DEFAULT '0',
`ALLOCATED_SIZE` bigint(21) unsigned NOT NULL DEFAULT '0'
) ENGINE=MEMORY DEFAULT CHARSET=utf8
1 row in set (0.00 sec)
there is no COMPRESSION column
How to repeat:
run
show create table INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES\G
*************************** 1. row ***************************
Table: INNODB_SYS_TABLESPACES
Create Table: CREATE TEMPORARY TABLE `INNODB_SYS_TABLESPACES` (
`SPACE` int(11) unsigned NOT NULL DEFAULT '0',
`NAME` varchar(655) NOT NULL DEFAULT '',
`FLAG` int(11) unsigned NOT NULL DEFAULT '0',
`FILE_FORMAT` varchar(10) DEFAULT NULL,
`ROW_FORMAT` varchar(22) DEFAULT NULL,
`PAGE_SIZE` int(11) unsigned NOT NULL DEFAULT '0',
`ZIP_PAGE_SIZE` int(11) unsigned NOT NULL DEFAULT '0',
`SPACE_TYPE` varchar(10) DEFAULT NULL,
`FS_BLOCK_SIZE` int(11) unsigned NOT NULL DEFAULT '0',
`FILE_SIZE` bigint(21) unsigned NOT NULL DEFAULT '0',
`ALLOCATED_SIZE` bigint(21) unsigned NOT NULL DEFAULT '0'
) ENGINE=MEMORY DEFAULT CHARSET=utf8
1 row in set (0.00 sec)
