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 | inventory | 4671674304 | 29 | 4671674304 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 5577212256 | 0 | 0 | 0 | 5 | 69709728 | |
sakila | film_actor | 4175828976 | 2 | 4175828976 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 4297677120 | 0 | 0 | 0 | 5 | 42083712 | |
sakila | address | 4121059008 | 54 | 4121059008 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 4697526240 | 0 | 0 | 0 | 5 | 36195984 | |
sakila | country | 2666316576 | 301 | 2666316576 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 909761424 | 0 | 0 | 0 | 5 | 59056272 | |
sakila | city | 2560138416 | 131 | 2560138416 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1108823760 | 0 | 0 | 0 | 5 | 40163904 | |
sakila | film | 2009619744 | 407 | 2009619744 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1588693392 | 0 | 0 | 0 | 5 | 47541120 | |
sakila | language | 1821997584 | 182 | 1821997584 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 813163824 | 0 | 0 | 0 | 5 | 66403920 | |
sakila | staff | 1243889856 | 2 | 1243889856 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1336080768 | 0 | 0 | 0 | 5 | 49763472 | |
sakila | store | 702369888 | 11 | 702369888 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 809269824 | 0 | 0 | 0 | 5 | 33991056 | |
sakila | category | 683068848 | 17 | 683068848 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 785482368 | 0 | 0 | 0 | 5 | 43230000 | |
mysql | index_stats | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | help_keyword | 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 | routines | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | general_log | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 35 | 374192016 | 0 | 0 | 0 | 4 | 72585216 | |
mysql | slow_log | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 35 | 209070576 | 0 | 0 | 0 | 4 | 136112592 | |
mysql | slave_master_info | 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 | catalogs | 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 | 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 | events | 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 | |
mysql | slave_relay_log_info | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|