InnoDB INFORMATION_SCHEMA Metrics Table 15.15.6 InnoDB INFORMATION_SCHEMA Metrics Table The  INNODB_METRICS  table provides information about  InnoDB  performance and resource-related counters. INNODB_METRICS  table columns are shown below. For column descriptions, see Section 26.4.23, “The INFORMATION_SCHEMA INNODB_METRICS Table” . You can enable, disable, and reset counters using the following variables: Enabling, Disabling, and Resetting Counters • innodb_monitor_enable : Enables counters. • innodb_monitor_disable : Disables counters. • innodb_monitor_reset : Resets counter values to zero. • innodb_monitor_reset_all : Resets all counter values. A counter must be disabled before using innodb_monitor_reset_all . Counters and counter modules can also be enabled at startup using the MySQL server configuration file. For example, to enable the  log  module,  metadata_table_handles_opened  and metadata_table_handles_closed  counters, enter the following line in the  [mysqld]  section of the MySQL server configuration file. When enabling multiple counters or modules in a configuration file, specify the  innodb_monitor_enable variable followed by counter and module names separated by a comma, as shown above. Only the [mysqld] innodb_monitor_enable = module_recovery,metadata_table_handles_opened,metadata_table_handles_closed SET GLOBAL innodb_monitor_reset_all = [counter-name|module_name|pattern|all]; SET GLOBAL innodb_monitor_reset = [counter-name|module_name|pattern|all]; SET GLOBAL innodb_monitor_disable = [counter-name|module_name|pattern|all]; SET GLOBAL innodb_monitor_enable = [counter-name|module_name|pattern|all]; mysql>  SELECT * FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE NAME="dml_inserts" \G *************************** 1. row *************************** NAME: dml_inserts SUBSYSTEM: dml COUNT: 46273 MAX_COUNT: 46273 MIN_COUNT: NULL AVG_COUNT: 492.2659574468085 COUNT_RESET: 46273 MAX_COUNT_RESET: 46273 MIN_COUNT_RESET: NULL AVG_COUNT_RESET: NULL TIME_ENABLED: 2014-11-28 16:07:53 TIME_DISABLED: NULL TIME_ELAPSED: 94 TIME_RESET: NULL STATUS: enabled TYPE: status_counter COMMENT: Number of rows inserted | Innodb_buffer_pool_reads | 558 | | Innodb_buffer_pool_wait_free | 0 | | Innodb_buffer_pool_write_requests | 11985961 | +---------------------------------------+-------------+ 3321