InnoDB System Variables 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 Command-Line Format --innodb-status-output[={OFF|ON}] System Variable innodb_status_output Scope Global Dynamic Yes SET_VAR  Hint Applies No Type Boolean Default Value OFF 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 Command-Line Format --innodb-status-output-locks[={OFF| ON}] System Variable innodb_status_output_locks Scope Global Dynamic Yes SET_VAR  Hint Applies No Type Boolean Default Value OFF Command-Line Format --innodb-strict-mode[={OFF|ON}] System Variable innodb_strict_mode Scope Global, Session Dynamic Yes SET_VAR  Hint Applies No 3286 • innodb_strict_mode 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” .