sys Schema Views The total number of occurrences of the statement event for the host. The total wait time of timed occurrences of the statement event for the host. The maximum single wait time of timed occurrences of the statement event for the host. The total time waiting for locks by timed occurrences of the statement event for the host. The total number of rows returned by occurrences of the statement event for the host. The total number of rows read from storage engines by occurrences of the statement event for the host. The total number of rows affected by occurrences of the statement event for the host. The total number of full table scans by occurrences of the statement event for the host. Querying views that access the  INNODB_BUFFER_PAGE  table can affect performance. Do not query these views on a production system unless you are aware of the performance impact and have determined it to be acceptable. To avoid impacting performance on a production system, reproduce the issue you want to investigate and query buffer pool statistics on a test instance. The  innodb_buffer_stats_by_schema  and  x$innodb_buffer_stats_by_schema  views have these columns: The total number of bytes allocated for the schema. The schema name for the object, or  InnoDB System  if the table belongs to the  InnoDB  storage engine. The total number of data bytes allocated for the schema. • total_latency • max_latency • lock_latency • rows_sent • rows_examined • rows_affected • full_scans • object_schema • allocated • data Warning 28.4.3.7 The innodb_buffer_stats_by_schema and x$innodb_buffer_stats_by_schema Views 5145 These views summarize the information in the  INFORMATION_SCHEMA INNODB_BUFFER_PAGE  table, grouped by schema. By default, rows are sorted by descending buffer size.