content_image/869077.jpg
TIME_DISABLED: 2014-12-04 14:20:06 TIME_ELAPSED: 98 TIME_RESET: NULL STATUS: disabled TYPE: status_counter COMMENT: Number of rows inserted 

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

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. 

## 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_ . 

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” . 

## Example 15.12 INNODB_TEMP_TABLE_INFO 

This example demonstrates characteristics of the INNODB_TEMP_TABLE_INFO  table. 

1. Create a simple InnoDB  temporary table: 

