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 | country | 18914777904 | 107 | 18914777904 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 803909568 | 0 | 0 | 0 | 5 | 17952879648 | |
sakila | city | 12303793392 | 360 | 12303793392 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 11064458064 | 0 | 0 | 0 | 5 | 31069632 | |
sakila | category | 4802549664 | 11 | 4802549664 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4691547168 | 0 | 0 | 0 | 5 | 98465664 | |
test19 | pilote | 4072394304 | 2 | 4072394304 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4173829440 | 0 | 0 | 0 | 5 | 64103952 | |
test19 | voiture | 4012173792 | 5 | 4012173792 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 4131735168 | 0 | 0 | 0 | 5 | 54288432 | |
sakila | film | 3781287840 | 509 | 3781287840 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 5523529968 | 0 | 0 | 0 | 5 | 39521328 | |
Table_insertion | pilote | 3765082992 | 3 | 3765082992 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3904125456 | 0 | 0 | 0 | 5 | 46685232 | |
sakila | inventory | 2208792432 | 172 | 2208792432 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 4412423136 | 0 | 0 | 0 | 5 | 63686832 | |
test19 | ecurie | 2062798320 | 10 | 2062798320 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1252992048 | 0 | 0 | 0 | 5 | 64477776 | |
sku | Attore | 1750239744 | 4 | 1750239744 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1694045232 | 0 | 0 | 0 | 5 | 110596992 | |
sakila | address | 1347603312 | 635 | 1347603312 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1884065040 | 0 | 0 | 0 | 5 | 44252208 | |
sakila | language | 1329463872 | 74 | 1329463872 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 735336624 | 0 | 0 | 0 | 5 | 40480704 | |
sakila | payment | 1243276848 | 7 | 1243276848 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1202861088 | 0 | 0 | 0 | 5 | 49471488 | |
sakila | rental | 1145067264 | 309 | 1145067264 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 980915232 | 0 | 0 | 0 | 5 | 45743808 | |
sakila | store | 1096153344 | 36 | 1096153344 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 846993840 | 0 | 0 | 0 | 5 | 83825280 | |
sakila | staff | 1078163856 | 46 | 1078163856 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 817543584 | 0 | 0 | 0 | 5 | 39596832 | |
sys | sys_config | 988433424 | 2 | 988433424 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1111619520 | 0 | 0 | 0 | 5 | 81937680 | |
Stefano | vulcano | 982466496 | 3 | 982466496 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 900486576 | 0 | 0 | 0 | 5 | 321475440 | |
sakila | actor | 926292048 | 10 | 926292048 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 854578032 | 0 | 0 | 0 | 5 | 45589632 | |
sakila | film_actor | 895709232 | 4 | 895709232 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 2185924752 | 0 | 0 | 0 | 5 | 41766384 | |
sakila | film_text | 679427232 | 20 | 679427232 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 565 | 510323616 | 0 | 0 | 0 | 14 | 111524688 | |
sakila | customer | 193881600 | 401 | 193881600 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2507291952 | 0 | 0 | 0 | 5 | 73562016 | |
world | City | 124833984 | 12 | 124833984 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 392 | 275253792 | 0 | 0 | 0 | 9 | 103990128 | |
world | Country | 18532272 | 2 | 18532272 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 2508063360 | 0 | 0 | 0 | 4 | 24237840 | |
mysql | dd_properties | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|