## 28.4.3.30 The schema_table_statistics_with_buffer and x $schema_table_statistics_with_buffer Views 

• io_misc_requests 

The total number of miscellaneous I/O requests for the table. 

• io_misc_latency 

The total wait time of miscellaneous I/O requests for the table. 

These views summarize table statistics, including InnoDB  buffer pool statistics. By default, rows are sorted by descending total wait time (tables with most contention first). 

These views user a helper view, x$ps_schema_table_statistics_io . 

The schema_table_statistics_with_buffer  and x $schema_table_statistics_with_buffer  views have these columns: 

• table_schema 

The schema that contains the table. 

• table_name 

The table name. 

• rows_fetched 

The total number of rows read from the table. 

• fetch_latency 

The total wait time of timed read I/O events for the table. 

• rows_inserted 

The total number of rows inserted into the table. 

• insert_latency 

The total wait time of timed insert I/O events for the table. 

• rows_updated 

The total number of rows updated in the table. 

• update_latency 

The total wait time of timed update I/O events for the table. 

• rows_deleted 

The total number of rows deleted from the table. 

• delete_latency 

The total wait time of timed delete I/O events for the table. 

