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 | film_category | 303200450256 | 330000 | 303200450256 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 922111344 | 0 | 0 | 0 | 5 | 22940544 | |
sakila | film | 158603413056 | 308152 | 158603413056 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1337572368 | 0 | 0 | 0 | 5 | 15957744 | |
sakila | film_actor | 60173864784 | 330400 | 60173864784 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1672803264 | 0 | 0 | 0 | 5 | 22492800 | |
sakila | category | 5759050176 | 10270 | 5759050176 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 747234048 | 0 | 0 | 0 | 5 | 22385088 | |
sakila | address | 4507360176 | 26 | 4507360176 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 5004329088 | 0 | 0 | 0 | 5 | 50311536 | |
sakila | city | 1848948288 | 51 | 1848948288 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1633799376 | 0 | 0 | 0 | 5 | 52037040 | |
sakila | country | 1425298512 | 25 | 1425298512 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 551139600 | 0 | 0 | 0 | 5 | 393405408 | |
sakila | rental | 1264907952 | 2 | 1264907952 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1747650960 | 0 | 0 | 0 | 5 | 37663824 | |
sakila | actor | 991020624 | 400 | 991020624 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1060452624 | 0 | 0 | 0 | 5 | 37153776 | |
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 | parameters | 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 | |
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 | |
performance_schema | events_statements_summary_by_digest | 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 | file_summary_by_event_name | 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 | |
mysql | slave_master_info | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | func | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | servers | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|