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 | payment | 30972384432 | 16049 | 30972384432 | 0 | 0 | 0 | 0 | 0 | 0 | 48 | 835584 | 5413742400 | 0 | 0 | 0 | 5 | 14437543296 | |
sakila | rental | 18248847936 | 16070 | 18248847936 | 0 | 0 | 0 | 0 | 0 | 0 | 53 | 917504 | 5812674384 | 0 | 0 | 0 | 5 | 32290368 | |
sakila | address | 5674836816 | 631 | 5674836816 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3674467104 | 0 | 0 | 0 | 5 | 96189456 | |
sakila | film_actor | 5532810624 | 5462 | 5532810624 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 4095160608 | 0 | 0 | 0 | 5 | 36240336 | |
sakila | film | 4232653392 | 1026 | 4232653392 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 3097588032 | 0 | 0 | 0 | 5 | 40671840 | |
world | City | 4204781856 | 4079 | 4204781856 | 0 | 0 | 0 | 0 | 0 | 0 | 4081 | 273685 | 2841765168 | 0 | 0 | 0 | 6 | 27165600 | |
sakila | inventory | 4056934464 | 4581 | 4056934464 | 0 | 0 | 0 | 0 | 0 | 0 | 14 | 278528 | 2171398416 | 0 | 0 | 0 | 5 | 30880608 | |
sku | Attore | 2711509152 | 9 | 2711509152 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1502849040 | 0 | 0 | 0 | 5 | 76208880 | |
vedettfak | fa | 2281795296 | 1258 | 2281795296 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 1718721840 | 0 | 0 | 0 | 5 | 31470912 | |
test19 | ecurie | 2163688032 | 4 | 2163688032 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2388789744 | 0 | 0 | 0 | 5 | 33187968 | |
sakila | actor | 2126056416 | 200 | 2126056416 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1804770528 | 0 | 0 | 0 | 5 | 95783424 | |
sakila | customer | 2055246336 | 624 | 2055246336 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1532283456 | 0 | 0 | 0 | 5 | 29800320 | |
sakila | city | 1907617536 | 703 | 1907617536 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 976225536 | 0 | 0 | 0 | 5 | 40309104 | |
sakila | staff | 1636090368 | 29 | 1636090368 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1471387104 | 0 | 0 | 0 | 5 | 45772320 | |
sakila | film_category | 1558008144 | 1000 | 1558008144 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1440435744 | 0 | 0 | 0 | 5 | 30464544 | |
sakila | film_text | 1504652688 | 1000 | 1504652688 | 0 | 0 | 0 | 0 | 0 | 0 | 2002 | 119290 | 1744928064 | 0 | 0 | 0 | 1004 | 120773664 | |
Table_insertion | ecurie | 1289049696 | 4 | 1289049696 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1396562112 | 0 | 0 | 0 | 5 | 75786480 | |
vedettfak | megye | 1152107616 | 19 | 1152107616 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1358918352 | 0 | 0 | 0 | 5 | 54807456 | |
sakila | country | 1149448608 | 211 | 1149448608 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 729352272 | 0 | 0 | 0 | 5 | 39604752 | |
world | CountryLanguage | 1125173808 | 984 | 1125173808 | 0 | 0 | 0 | 0 | 0 | 0 | 986 | 38783 | 1190691216 | 0 | 0 | 0 | 7 | 35047056 | |
world | Country | 1093513872 | 239 | 1093513872 | 0 | 0 | 0 | 0 | 0 | 0 | 241 | 62841 | 1312097424 | 0 | 0 | 0 | 6 | 30478272 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 996695568 | 24 | 996695568 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 941242896 | 3 | 941242896 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | language | 938819376 | 31 | 938819376 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 861831168 | 0 | 0 | 0 | 5 | 56539296 | |
Table_insertion | pilote | 936556368 | 30 | 936556368 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1077465840 | 0 | 0 | 0 | 5 | 64145136 |
|