content_image/724900.jpg
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: 

•The mutex_instances  table 

•The rwlock_instances  table 

•The cond_instances  table 

•The file_instances  table 

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

## Note 

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: 

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

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

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. 

