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 | rental | 51661513200 | 16044 | 51661513200 | 0 | 0 | 0 | 0 | 0 | 0 | 51 | 884736 | 34357360752 | 0 | 0 | 0 | 5 | 64747056 | |
sakila | payment | 25614339168 | 16049 | 25614339168 | 0 | 0 | 0 | 0 | 0 | 0 | 48 | 835584 | 4861317648 | 0 | 0 | 0 | 5 | 31580208 | |
world | City | 15664619520 | 4079 | 15664619520 | 0 | 0 | 0 | 0 | 0 | 0 | 4081 | 273685 | 6572688672 | 0 | 0 | 0 | 4 | 20924112 | |
sakila | film_actor | 6625914240 | 5462 | 6625914240 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1858909008 | 0 | 0 | 0 | 5 | 35377056 | |
sakila | film | 5623051104 | 1000 | 5623051104 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 2056198848 | 0 | 0 | 0 | 5 | 40910496 | |
sakila | inventory | 5217892416 | 4581 | 5217892416 | 0 | 0 | 0 | 0 | 0 | 0 | 14 | 278528 | 2934743856 | 0 | 0 | 0 | 5 | 36726096 | |
sakila | staff | 4688314224 | 2 | 4688314224 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 4808512368 | 0 | 0 | 0 | 5 | 52078224 | |
sakila | address | 3462795072 | 603 | 3462795072 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1830654672 | 0 | 0 | 0 | 5 | 60768048 | |
sakila | customer | 3164591232 | 599 | 3164591232 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1817586144 | 0 | 0 | 0 | 5 | 48562800 | |
vedettfak | fa | 3000317760 | 1258 | 3000317760 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 1663696848 | 0 | 0 | 0 | 5 | 379851648 | |
world | CountryLanguage | 2561987472 | 984 | 2561987472 | 0 | 0 | 0 | 0 | 0 | 0 | 986 | 38783 | 2564186592 | 0 | 0 | 0 | 4 | 18379152 | |
sakila | city | 2441423424 | 678 | 2441423424 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1759662960 | 0 | 0 | 0 | 5 | 64024224 | |
sakila | film_text | 2404426464 | 1000 | 2404426464 | 0 | 0 | 0 | 0 | 0 | 0 | 2002 | 119290 | 1998766704 | 0 | 0 | 0 | 1004 | 172766880 | |
sku | Attore | 2026971936 | 1 | 2026971936 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1393089456 | 0 | 0 | 0 | 5 | 713835936 | |
sakila | actor | 1815151008 | 200 | 1815151008 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1537068192 | 0 | 0 | 0 | 5 | 101575584 | |
sakila | category | 1676102736 | 16 | 1676102736 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1731234912 | 0 | 0 | 0 | 5 | 60470256 | |
world | Country | 1648426032 | 239 | 1648426032 | 0 | 0 | 0 | 0 | 0 | 0 | 241 | 62841 | 2834186784 | 0 | 0 | 0 | 4 | 25886784 | |
sakila | country | 1474547184 | 237 | 1474547184 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 953557440 | 0 | 0 | 0 | 5 | 45328800 | |
sakila | film_category | 1470694896 | 1000 | 1470694896 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1330848816 | 0 | 0 | 0 | 5 | 36038640 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 1343185536 | 24 | 1343185536 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
Table_insertion | pilote | 1227339696 | 33 | 1227339696 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1339622064 | 0 | 0 | 0 | 5 | 43530960 | |
Stefano | vulcano | 1225068240 | 4 | 1225068240 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 819827712 | 0 | 0 | 0 | 5 | 386699280 | |
sakila | store | 1161900960 | 2 | 1161900960 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1302338400 | 0 | 0 | 0 | 5 | 32889648 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 845458944 | 3 | 845458944 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
vedettfak | megye | 841193760 | 19 | 841193760 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1023278256 | 0 | 0 | 0 | 5 | 60727392 |
|