InnoDB System Variables Minimum Value 1 Maximum Value 50 Command-Line Format --innodb-monitor-disable={counter| module|pattern|all} System Variable innodb_monitor_disable Scope Global Dynamic Yes SET_VAR  Hint Applies No Type String Command-Line Format --innodb-monitor-enable={counter| module|pattern|all} System Variable innodb_monitor_enable Scope Global Dynamic Yes SET_VAR  Hint Applies No Type String Command-Line Format --innodb-monitor-reset={counter| module|pattern|all} System Variable innodb_monitor_reset Scope Global Dynamic Yes Defines a page-full percentage value for index pages that overrides the current  MERGE_THRESHOLD setting for all indexes that are currently in the dictionary cache. This option is only available if debugging support is compiled in using the  WITH_DEBUG CMake  option. For related information, see Section 15.8.11, “Configuring the Merge Threshold for Index Pages” . Disables  InnoDB  metrics counters. Counter data may be queried using the INFORMATION_SCHEMA.INNODB_METRICS  table. For usage information, see Section 15.15.6, “InnoDB INFORMATION_SCHEMA Metrics Table” . innodb_monitor_disable=’latch’  disables statistics collection for  SHOW ENGINE INNODB MUTEX . For more information, see Section 13.7.7.15, “SHOW ENGINE Statement” . Enables  InnoDB  metrics counters. Counter data may be queried using the INFORMATION_SCHEMA.INNODB_METRICS  table. For usage information, see Section 15.15.6, “InnoDB INFORMATION_SCHEMA Metrics Table” . innodb_monitor_enable=’latch’  enables statistics collection for  SHOW ENGINE INNODB MUTEX . For more information, see Section 13.7.7.15, “SHOW ENGINE Statement” . • innodb_monitor_reset • innodb_monitor_enable • innodb_monitor_disable 3266