The INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES Table • COMMENT The counter description. Example Notes •You must have the  PROCESS  privilege to query this table. •Use the  INFORMATION_SCHEMA COLUMNS  table or the  SHOW COLUMNS  statement to view additional information about the columns of this table, including data types and default values. •Transaction counter  COUNT  values may differ from the number of transaction events reported in Performance Schema  EVENTS_TRANSACTIONS_SUMMARY  tables.  InnoDB  counts only those transactions that it executes, whereas Performance Schema collects events for all non-aborted transactions initiated by the server, including empty transactions. 26.4.24 The INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES Table The  INNODB_SESSION_TEMP_TABLESPACES  table provides metadata about session temporary tablespaces used for internal and user-created temporary tables. This table was added in MySQL 8.0.13. The  INNODB_SESSION_TEMP_TABLESPACES  table has these columns: • ID • SPACE The process or session ID. The tablespace ID. A range of 400 thousand space IDs is reserved for session temporary tablespaces. Session temporary tablespaces are recreated each time the server is started. Space IDs are not persisted when the server is shut down and may be reused. The tablespace data file path. A session temporary tablespace has an  ibt  file extension. • PATH 4873 mysql>  SELECT * FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE NAME=’dml_inserts’\G *************************** 1. row *************************** NAME: dml_inserts SUBSYSTEM: dml COUNT: 3 MAX_COUNT: 3 MIN_COUNT: NULL AVG_COUNT: 0.046153846153846156 COUNT_RESET: 3 MAX_COUNT_RESET: 3 MIN_COUNT_RESET: NULL AVG_COUNT_RESET: NULL TIME_ENABLED: 2014-12-04 14:18:28 TIME_DISABLED: NULL TIME_ELAPSED: 65 TIME_RESET: NULL STATUS: enabled TYPE: status_counter COMMENT: Number of rows inserted