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 | address | 2821555440 | 301 | 2821555440 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1476015552 | 0 | 0 | 0 | 5 | 49474656 | |
sakila | actor | 1946089200 | 2 | 1946089200 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2541785664 | 0 | 0 | 0 | 5 | 227551104 | |
sakila | customer | 1873846656 | 2928 | 1873846656 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1309266816 | 0 | 0 | 0 | 5 | 51013248 | |
vedettfak | fa | 1051965552 | 2 | 1051965552 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1051601760 | 0 | 0 | 0 | 5 | 208451232 | |
world | Country | 799551456 | 16 | 799551456 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 984 | 1722736752 | 0 | 0 | 0 | 12 | 84127824 | |
sakila | film | 453302256 | 26 | 453302256 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2103931104 | 0 | 0 | 0 | 5 | 52407168 | |
sakila | city | 192357792 | 25 | 192357792 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 893608320 | 0 | 0 | 0 | 5 | 35482656 | |
sakila | language | 147661536 | 25 | 147661536 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 846984336 | 0 | 0 | 0 | 5 | 44404272 | |
world | City | 52128912 | 5 | 52128912 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 392 | 433712928 | 0 | 0 | 0 | 9 | 52134720 | |
sakila | film_text | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 442 | 337030320 | 0 | 0 | 0 | 4 | 28179360 | |
sakila | payment | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 48 | 835584 | 5174203056 | 0 | 0 | 0 | 5 | 39627984 | |
sakila | inventory | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14 | 278528 | 2375082864 | 0 | 0 | 0 | 5 | 52438320 | |
sakila | film_category | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1010861280 | 0 | 0 | 0 | 5 | 34839552 | |
sakila | film_actor | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1755327552 | 0 | 0 | 0 | 5 | 35516976 | |
sakila | country | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 684519264 | 0 | 0 | 0 | 5 | 50966784 | |
sakila | category | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 883019280 | 0 | 0 | 0 | 5 | 35905056 | |
sakila | staff | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1020108672 | 0 | 0 | 0 | 5 | 44652432 | |
performance_schema | global_variables | 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 |
|