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 | 4439943552 | 26 | 4439943552 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 4557293136 | 0 | 0 | 0 | 5 | 46171488 | |
sakila | language | 2814969168 | 25 | 2814969168 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2764455408 | 0 | 0 | 0 | 5 | 50009520 | |
sakila | country | 2124542112 | 3 | 2124542112 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2268330768 | 0 | 0 | 0 | 5 | 90624864 | |
CSV_DB 32 | user | 1987278480 | 124 | 1838778480 | 2 | 148500000 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | film | 1492268448 | 51 | 1492268448 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1834632096 | 0 | 0 | 0 | 5 | 34469952 | |
sakila | category | 991449888 | 25 | 991449888 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1093744608 | 0 | 0 | 0 | 5 | 51164256 | |
sakila | customer | 739204752 | 3 | 739204752 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 973178976 | 0 | 0 | 0 | 5 | 24093696 | |
sys | sys_config | 722608128 | 1 | 722608128 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 994302144 | 0 | 0 | 0 | 5 | 45989856 | |
sakila | city | 543964608 | 3 | 543964608 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 799573104 | 0 | 0 | 0 | 5 | 23751024 | |
sakila | address | 512184288 | 3 | 512184288 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 902156112 | 0 | 0 | 0 | 5 | 23268432 | |
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 | slave_worker_info | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sku | Programmato | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 941304144 | 0 | 0 | 0 | 5 | 34597200 | |
sku | Interpreta | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 902252736 | 0 | 0 | 0 | 5 | 36739824 | |
sku | Cinema | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 886599648 | 0 | 0 | 0 | 5 | 46339392 | |
mysql | slave_master_info | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sku | Film | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 917272224 | 0 | 0 | 0 | 5 | 39497568 | |
sku | Attore | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 847948992 | 0 | 0 | 0 | 5 | 62758080 | |
mysql | index_stats | 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 | table_stats | 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 | 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 |
|