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 | city | 2774745072 | 78 | 2774745072 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 2811572544 | 0 | 0 | 0 | 5 | 44243232 | |
sakila | store | 1745632416 | 3 | 1745632416 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1795588608 | 0 | 0 | 0 | 5 | 90959616 | |
sakila | language | 1569262992 | 75 | 1569262992 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1182833520 | 0 | 0 | 0 | 5 | 57882528 | |
sakila | staff | 1184634528 | 2 | 1184634528 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1305955200 | 0 | 0 | 0 | 5 | 33105072 | |
sakila | country | 1167030480 | 75 | 1167030480 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 995729328 | 0 | 0 | 0 | 5 | 40282176 | |
sakila | address | 1159532352 | 27 | 1159532352 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1223125728 | 0 | 0 | 0 | 5 | 40890960 | |
sakila | film | 1052665152 | 78 | 1052665152 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1547977200 | 0 | 0 | 0 | 5 | 31139856 | |
sakila | customer | 1042866528 | 26 | 1042866528 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1705441056 | 0 | 0 | 0 | 5 | 41737872 | |
sakila | film_text | 639499344 | 26 | 639499344 | 0 | 0 | 0 | 0 | 0 | 0 | 52 | 3415 | 979654896 | 0 | 0 | 0 | 32 | 30230112 | |
performance_schema | global_variables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_transactions_summary_by_user_by_event_name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
world | CountryLanguage | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 407 | 334371840 | 0 | 0 | 0 | 4 | 22123728 | |
world | Country | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 1280828736 | 0 | 0 | 0 | 4 | 17182176 | |
world | City | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 392 | 207708864 | 0 | 0 | 0 | 4 | 20565600 | |
mysql | slave_worker_info | 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 | |
performance_schema | events_statements_current | 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 | 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_relay_log_info | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|