InnoDB Integration with MySQL Performance Schema For additional information about the instrumented  InnoDB  objects, you can query Performance Schema instances tables, which provide additional information about instrumented objects. Instance tables relevant to  InnoDB  include: Mutexes and RW-locks related to the  InnoDB  buffer pool are not included in this coverage; the same applies to the output of the  SHOW ENGINE INNODB MUTEX command. For example, to view information about instrumented  InnoDB  file objects seen by the Performance Schema when executing file I/O instrumentation, you might issue the following query: If you are only interested in  InnoDB -related objects, use the clause  WHERE EVENT_NAME LIKE ’%innodb%’  or  WHERE NAME LIKE ’%innodb%’  (as required) when querying these tables. •The  mutex_instances  table •The  rwlock_instances  table •The  cond_instances  table •The  file_instances  table •You should be familiar with  performance_schema  tables that store  InnoDB  event data. Tables relevant to  InnoDB -related events include: •The Wait Event tables, which store wait events. •The Summary tables, which provide aggregated information for terminated events over time. Summary tables include file I/O summary tables, which aggregate information about I/O operations. •Stage Event tables, which store event data for  InnoDB ALTER TABLE  and buffer pool load operations. For more information, see Section 15.16.1, “Monitoring ALTER TABLE Progress for InnoDB Tables Using Performance Schema” , and Monitoring Buffer Pool Load Progress Using Performance Schema. 3333 mysql>  SELECT * FROM performance_schema.file_instances WHERE EVENT_NAME LIKE ’%innodb%’\G *************************** 1. row ***************************  FILE_NAME: /path/to/mysql-8.0/data/ibdata1 EVENT_NAME: wait/io/file/innodb/innodb_data_file OPEN_COUNT: 3 *************************** 2. row ***************************  FILE_NAME: /path/to/mysql-8.0/data/ib_logfile0 EVENT_NAME: wait/io/file/innodb/innodb_log_file OPEN_COUNT: 2 *************************** 3. row ***************************  FILE_NAME: /path/to/mysql-8.0/data/ib_logfile1 EVENT_NAME: wait/io/file/innodb/innodb_log_file OPEN_COUNT: 2 *************************** 4. row ***************************  FILE_NAME: /path/to/mysql-8.0/data/mysql/engine_cost.ibd EVENT_NAME: wait/io/file/innodb/innodb_data_file OPEN_COUNT: 3 ... Note