InnoDB Table Compression on the  CREATE TABLE  or  ALTER TABLE  statements, and how the options appear in the output of  SHOW TABLE STATUS . When  innodb_strict_mode  is  OFF , MySQL creates or alters the table, but ignores certain settings as shown below. You can see the warning messages in the MySQL error log. When  innodb_strict_mode is  ON , these specified combinations of options generate errors, and the table is not created or altered. To see the full description of the error condition, issue the  SHOW ERRORS  statement: example: When  innodb_strict_mode  is  ON , MySQL rejects invalid  ROW_FORMAT  or  KEY_BLOCK_SIZE parameters and issues errors. Strict mode is  ON  by default. When  innodb_strict_mode  is  OFF , MySQL issues warnings instead of errors for ignored invalid parameters. It is not possible to see the chosen  KEY_BLOCK_SIZE  using  SHOW TABLE STATUS . The statement  SHOW CREATE TABLE  displays the  KEY_BLOCK_SIZE  (even if it was ignored when creating the table). The real compressed page size of the table cannot be displayed by MySQL. 3160 mysql>  CREATE TABLE x (id INT PRIMARY KEY, c INT) ->  ENGINE=INNODB KEY_BLOCK_SIZE=33333; ERROR 1005 (HY000): Can’t create table ’test.x’ (errno: 1478) mysql>  SHOW ERRORS; +-------+------+-------------------------------------------+ | Level | Code | Message | +-------+------+-------------------------------------------+ | Error | 1478 | InnoDB: invalid KEY_BLOCK_SIZE=33333. | | Error | 1005 | Can’t create table ’test.x’ (errno: 1478) | +-------+------+-------------------------------------------+ Table 15.13 CREATE/ALTER TABLE Warnings and Errors when InnoDB Strict Mode is OFF Syntax Warning or Error Condition Resulting  ROW_FORMAT , as shown in  SHOW TABLE STATUS ROW_FORMAT=REDUNDANT None REDUNDANT ROW_FORMAT=COMPACT None COMPACT ROW_FORMAT=COMPRESSED or  ROW_FORMAT=DYNAMIC  or KEY_BLOCK_SIZE  is specified Ignored for file-per- table tablespaces unless innodb_file_per_table  is enabled. General tablespaces support all row formats. See Section 15.6.3.3, “General Tablespaces” . the default row format for file-per-table tablespaces; the specified row format for general tablespaces Invalid  KEY_BLOCK_SIZE  is specified (not 1, 2, 4, 8 or 16) KEY_BLOCK_SIZE  is ignored the specified row format, or the default row format ROW_FORMAT=COMPRESSED and valid  KEY_BLOCK_SIZE  are specified None;  KEY_BLOCK_SIZE specified is used COMPRESSED KEY_BLOCK_SIZE  is specified with  REDUNDANT ,  COMPACT  or DYNAMIC  row format KEY_BLOCK_SIZE  is ignored REDUNDANT ,  COMPACT  or DYNAMIC ROW_FORMAT  is not one of REDUNDANT ,  COMPACT ,  DYNAMIC or  COMPRESSED Ignored if recognized by the MySQL parser. Otherwise, an error is issued. the default row format or N/A