InnoDB INFORMATION_SCHEMA Temporary Table Info Table TIME_DISABLED: 2014-12-04 14:20:06 TIME_ELAPSED: 98 TIME_RESET: NULL STATUS: disabled TYPE: status_counter COMMENT: Number of rows inserted Note Wildcard match is supported for counter and module names. For example, instead of specifying the full  dml_inserts  counter name, you can specify dml_i% . You can also enable, disable, or reset multiple counters or modules at once using a wildcard match. For example, specify  dml_%  to enable, disable, or reset all counters that begin with  dml_ . 8. After the counter is disabled, you can reset all counter values using the innodb_monitor_reset_all  option. All values are set to zero or NULL. mysql>  SET GLOBAL innodb_monitor_reset_all = dml_inserts; Query OK, 0 rows affected (0.00 sec) mysql>  SELECT * FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE NAME="dml_inserts"\G *************************** 1. row *************************** NAME: dml_inserts SUBSYSTEM: dml COUNT: 0 MAX_COUNT: NULL MIN_COUNT: NULL AVG_COUNT: NULL COUNT_RESET: 0 MAX_COUNT_RESET: NULL MIN_COUNT_RESET: NULL AVG_COUNT_RESET: NULL TIME_ENABLED: NULL TIME_DISABLED: NULL TIME_ELAPSED: NULL TIME_RESET: NULL STATUS: disabled TYPE: status_counter COMMENT: Number of rows inserted 15.15.7 InnoDB INFORMATION_SCHEMA Temporary Table Info Table INNODB_TEMP_TABLE_INFO  provides information about user-created  InnoDB  temporary tables that are active in the  InnoDB  instance. It does not provide information about internal  InnoDB  temporary tables used by the optimizer. mysql>  SHOW TABLES FROM INFORMATION_SCHEMA LIKE ’INNODB_TEMP%’; +---------------------------------------------+ | Tables_in_INFORMATION_SCHEMA (INNODB_TEMP%) | +---------------------------------------------+ | INNODB_TEMP_TABLE_INFO | +---------------------------------------------+ For the table definition, see Section 26.4.29, “The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table” . This example demonstrates characteristics of the  INNODB_TEMP_TABLE_INFO  table. 1. Create a simple  InnoDB  temporary table: Example 15.12 INNODB_TEMP_TABLE_INFO 3329