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 | 40880104848 | 16049 | 40880104848 | 0 | 0 | 0 | 0 | 0 | 0 | 48 | 835584 | 5699307504 | 0 | 0 | 0 | 5 | 30388512 | |
sakila | rental | 25561820592 | 16070 | 25561820592 | 0 | 0 | 0 | 0 | 0 | 0 | 53 | 917504 | 9368715312 | 0 | 0 | 0 | 5 | 44907456 | |
sakila | film | 7823853312 | 1258 | 7823853312 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 3491750592 | 0 | 0 | 0 | 5 | 49129344 | |
sakila | inventory | 6379986096 | 4607 | 6379986096 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 4524571392 | 0 | 0 | 0 | 5 | 43594320 | |
world | City | 4785066000 | 4079 | 4785066000 | 0 | 0 | 0 | 0 | 0 | 0 | 4081 | 273685 | 3022181712 | 0 | 0 | 0 | 5 | 34823712 | |
sakila | film_actor | 2869860576 | 5488 | 2869860576 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 4676928432 | 0 | 0 | 0 | 5 | 39478560 | |
sakila | address | 2634062112 | 784 | 2634062112 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2415723024 | 0 | 0 | 0 | 5 | 42307056 | |
sakila | customer | 2227082352 | 703 | 2227082352 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2012217504 | 0 | 0 | 0 | 5 | 35088240 | |
vedettfak | fa | 2148902448 | 1258 | 2148902448 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 1560199872 | 0 | 0 | 0 | 5 | 37172784 | |
sakila | language | 2035347072 | 213 | 2035347072 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 830778960 | 0 | 0 | 0 | 5 | 40718832 | |
sakila | city | 1833192240 | 726 | 1833192240 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 2102318064 | 0 | 0 | 0 | 5 | 37170144 | |
sakila | film_text | 1826786544 | 1000 | 1826786544 | 0 | 0 | 0 | 0 | 0 | 0 | 2002 | 119290 | 2058453936 | 0 | 0 | 0 | 1008 | 182215440 | |
zjut_uni | studentmarks | 1817618352 | 7 | 1729828848 | 2 | 87789504 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 262144 | 148516368 | 8 | 82635203376 | |
zjut_uni | teacher | 1558074672 | 0 | 0 | 2 | 1558074672 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 13735813872 | 7 | 63407794560 | |
sakila | staff | 1512946512 | 30 | 1512946512 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 2114282544 | 0 | 0 | 0 | 5 | 33818928 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 1414303968 | 24 | 1414303968 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
world | CountryLanguage | 1296080544 | 984 | 1296080544 | 0 | 0 | 0 | 0 | 0 | 0 | 986 | 38783 | 1412451744 | 0 | 0 | 0 | 6 | 55639584 | |
world | Country | 1292057712 | 239 | 1292057712 | 0 | 0 | 0 | 0 | 0 | 0 | 241 | 62841 | 6749671632 | 0 | 0 | 0 | 5 | 37814832 | |
Stefano | vulcano | 1140095616 | 4 | 1140095616 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1310208240 | 0 | 0 | 0 | 5 | 75837696 | |
zjut_uni | student | 1072022160 | 16 | 323385216 | 2 | 748636944 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 262144 | 190282752 | 8 | 72201525792 | |
Table_insertion | pilote | 983589024 | 30 | 983589024 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1093251456 | 0 | 0 | 0 | 5 | 36501168 | |
Table_insertion | ecurie | 789184704 | 4 | 789184704 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 966889440 | 0 | 0 | 0 | 5 | 51463632 | |
Table_insertion | voiture | 716365584 | 14 | 716365584 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 912221904 | 0 | 0 | 0 | 5 | 31970928 | |
vedettfak | megye | 684542496 | 19 | 684542496 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 881119536 | 0 | 0 | 0 | 5 | 31323072 | |
test19 | pilote | 649867680 | 30 | 649867680 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 966457536 | 0 | 0 | 0 | 5 | 33777216 |
|