Bug #82462 no COMPRESSION columns in INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES
Submitted: 4 Aug 2016 16:24 Modified: 4 Aug 2016 18:31
Reporter: Vadim Tkachenko Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DDL Severity:S3 (Non-critical)
Version:5.7.14 OS:Any
Assigned to: CPU Architecture:Any

[4 Aug 2016 16:24] Vadim Tkachenko
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)
[4 Aug 2016 18:31] Miguel Solorzano
Thank you for the bug report. Verified as described.