content_image/871088.jpg content_image/871091.jpg content_image/871092.jpg
of database pages accessed by ANALYZE TABLE , see Section 15.8.10.3, “Estimating ANALYZE TABLE Complexity for InnoDB Tables” . 

innodb_stats_transient_sample_pages  only applies when innodb_stats_persistent is disabled for a table; when innodb_stats_persistent  is enabled, innodb_stats_persistent_sample_pages  applies instead. Takes the place of innodb_stats_sample_pages . For more information, see Section 15.8.10.2, “Configuring Non- Persistent Optimizer Statistics Parameters” . 

• innodb_status_output 

<img src='content_image/871088.jpg'>

Enables or disables periodic output for the standard InnoDB  Monitor. Also used in combination with innodb_status_output_locks  to enable or disable periodic output for the InnoDB  Lock Monitor. For more information, see Section 15.17.2, “Enabling InnoDB Monitors” . 

• innodb_status_output_locks 

<img src='content_image/871091.jpg'>

Enables or disables the InnoDB  Lock Monitor. When enabled, the InnoDB  Lock Monitor prints additional information about locks in SHOW ENGINE INNODB STATUS  output and in periodic output printed to the MySQL error log. Periodic output for the InnoDB  Lock Monitor is printed as part of the standard InnoDB Monitor output. The standard InnoDB  Monitor must therefore be enabled for the InnoDB  Lock Monitor to print data to the MySQL error log periodically. For more information, see Section 15.17.2, “Enabling InnoDB Monitors” . 

• innodb_strict_mode 

<img src='content_image/871092.jpg'>

