SELECT * FROM `x$schema_table_statistics`
|
table_schema | table_name | total_latency | rows_fetched | fetch_latency | rows_inserted | insert_latency | rows_updated | update_latency | rows_deleted | delete_latency | io_read_requests | io_read | io_read_latency | io_write_requests | io_write | io_write_latency | io_misc_requests | io_misc_latency | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sakila | customer | 4806112608 | 77 | 4806112608 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 4895344080 | 0 | 0 | 0 | 5 | 39807504 | |
sakila | payment | 4506802608 | 26 | 4506802608 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 868352 | 15756155712 | 0 | 0 | 0 | 5 | 46144560 | |
sakila | city | 4318549488 | 78 | 4318549488 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 4279288464 | 0 | 0 | 0 | 5 | 84980544 | |
sakila | language | 2251615872 | 658 | 2251615872 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 944322720 | 0 | 0 | 0 | 5 | 34028544 | |
sakila | film | 2006330832 | 114 | 2006330832 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2316291120 | 0 | 0 | 0 | 5 | 33571824 | |
sakila | address | 1720964784 | 52 | 1720964784 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1541905728 | 0 | 0 | 0 | 5 | 48178944 | |
sakila | country | 1497054240 | 75 | 1497054240 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1200827760 | 0 | 0 | 0 | 5 | 43324512 | |
sakila | staff | 1465094400 | 28 | 1465094400 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1308392448 | 0 | 0 | 0 | 5 | 31383264 | |
mysql | routines | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | parameters | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | parameter_type_elements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_stages_summary_by_user_by_event_name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | global_variables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | help_category | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | innodb_index_stats | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | events | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | table_lock_waits_summary_by_table | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | table_io_waits_summary_by_table | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | table_stats | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | index_stats | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | catalogs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_statements_current | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | session_variables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | column_statistics | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | slave_worker_info | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|