•To enable compression for InnoDB  tables, specify ROW_FORMAT=COMPRESSED . The ROW_FORMAT=COMPRESSED  option is not supported when creating temporary tables. See Section 15.9, “InnoDB Table and Page Compression”  for requirements associated with the COMPRESSED  row format. 

•The row format used in older versions of MySQL can still be requested by specifying the REDUNDANT row format. 

•When you specify a non-default ROW_FORMAT  clause, consider also enabling the innodb_strict_mode  configuration option. 

• ROW_FORMAT=FIXED  is not supported. If ROW_FORMAT=FIXED  is specified while innodb_strict_mode  is disabled, InnoDB  issues a warning and assumes ROW_FORMAT=DYNAMIC . If ROW_FORMAT=FIXED  is specified while innodb_strict_mode  is enabled, which is the default, InnoDB  returns an error. 

•For additional information about InnoDB  row formats, see Section 15.10, “InnoDB Row Formats” . 

For MyISAM  tables, the option value can be FIXED  or DYNAMIC  for static or variable-length row format. myisampack  sets the type to COMPRESSED . See Section 16.2.3, “MyISAM Table Storage Formats” . 

For NDB  tables, the default ROW_FORMAT  is DYNAMIC . 

• STATS_AUTO_RECALC 

Specifies whether to automatically recalculate persistent statistics for an InnoDB  table. The value DEFAULT  causes the persistent statistics setting for the table to be determined by the innodb_stats_auto_recalc  configuration option. The value 1  causes statistics to be recalculated when 10% of the data in the table has changed. The value 0  prevents automatic recalculation for this table; with this setting, issue an ANALYZE TABLE  statement to recalculate the statistics after making substantial changes to the table. For more information about the persistent statistics feature, see Section 15.8.10.1, “Configuring Persistent Optimizer Statistics Parameters” . 

• STATS_PERSISTENT 

Specifies whether to enable persistent statistics for an InnoDB  table. The value DEFAULT  causes the persistent statistics setting for the table to be determined by the innodb_stats_persistent configuration option. The value 1  enables persistent statistics for the table, while the value 0  turns off this feature. After enabling persistent statistics through a CREATE TABLE  or ALTER TABLE  statement, issue an ANALYZE TABLE  statement to calculate the statistics, after loading representative data into the table. For more information about the persistent statistics feature, see Section 15.8.10.1, “Configuring Persistent Optimizer Statistics Parameters” . 

• STATS_SAMPLE_PAGES 

The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE . For more information, see Section 15.8.10.1, “Configuring Persistent Optimizer Statistics Parameters” . 

