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 | film_category | 301323266112 | 334064 | 301323266112 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 3050345760 | 0 | 0 | 0 | 5 | 26513520 | |
sakila | payment | 203812670160 | 64177 | 203812670160 | 0 | 0 | 0 | 0 | 0 | 0 | 67 | 1146880 | 12322670448 | 0 | 0 | 0 | 5 | 22037664 | |
sakila | film | 154500700992 | 312288 | 154500700992 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2580078864 | 0 | 0 | 0 | 5 | 30611856 | |
sakila | city | 67215500352 | 92 | 67215500352 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 65423581872 | 0 | 0 | 0 | 5 | 1439533920 | |
sakila | film_actor | 59560656144 | 330400 | 59560656144 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1656542448 | 0 | 0 | 0 | 5 | 20637936 | |
sakila | rental | 40610344368 | 82527 | 40610344368 | 0 | 0 | 0 | 0 | 0 | 0 | 70 | 1196032 | 22829128608 | 0 | 0 | 0 | 5 | 39416256 | |
sakila | inventory | 14894865744 | 22324 | 14894865744 | 0 | 0 | 0 | 0 | 0 | 0 | 19 | 360448 | 5759165280 | 0 | 0 | 0 | 5 | 36256704 | |
vedettfak | megye | 6618871776 | 252 | 6618871776 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2428061328 | 0 | 0 | 0 | 5 | 1915877040 | |
sakila | category | 5872731216 | 10338 | 5872731216 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 793296768 | 0 | 0 | 0 | 5 | 17608800 | |
TlapaleriaMalfoy | Registro | 5530109904 | 2 | 5530109904 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4996099680 | 0 | 0 | 0 | 5 | 130325712 | |
sakila | staff | 4370698464 | 44 | 4370698464 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 4249118016 | 0 | 0 | 0 | 5 | 46488816 | |
test19 | ecurie | 3862829520 | 3 | 3862829520 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4049678160 | 0 | 0 | 0 | 5 | 34355904 | |
Stefano | vulcano | 3738638112 | 2 | 3738638112 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3930496416 | 0 | 0 | 0 | 5 | 43260624 | |
vedettfak | fa | 3264661488 | 58 | 3264661488 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 245760 | 4188843648 | 0 | 0 | 0 | 5 | 39337584 | |
sakila | customer | 1714176288 | 25 | 1714176288 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1564373184 | 0 | 0 | 0 | 5 | 51801024 | |
sakila | language | 1700634144 | 125 | 1700634144 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1026864960 | 0 | 0 | 0 | 5 | 63767088 | |
sakila | country | 1545876816 | 118 | 1545876816 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1084593840 | 0 | 0 | 0 | 5 | 71566704 | |
sakila | address | 1266997776 | 42 | 1266997776 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1931739216 | 0 | 0 | 0 | 5 | 39299040 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 1137287184 | 18 | 1137287184 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | actor | 891442992 | 400 | 891442992 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 949818144 | 0 | 0 | 0 | 5 | 35302080 | |
test19 | voiture | 44475024 | 1 | 44475024 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1021619280 | 0 | 0 | 0 | 5 | 55257840 | |
Table_insertion | voiture | 38953728 | 1 | 38953728 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 3977582928 | 0 | 0 | 0 | 5 | 55490160 | |
world | Country | 32022144 | 1 | 32022144 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 507167760 | 0 | 0 | 0 | 4 | 27365712 | |
Table_insertion | ecurie | 20345952 | 1 | 20345952 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1010592000 | 0 | 0 | 0 | 5 | 37522320 | |
Table_insertion | pilote | 17380176 | 1 | 17380176 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4065891456 | 0 | 0 | 0 | 5 | 58546224 |
|