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 | 1123825119120 | 1321000 | 1123825119120 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1741441680 | 0 | 0 | 0 | 5 | 41060448 | |
sakila | film | 604920804576 | 1233738 | 604920804576 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 3196834080 | 0 | 0 | 0 | 5 | 51656352 | |
sakila | film_actor | 228045211680 | 1327062 | 228045211680 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 3252323712 | 0 | 0 | 0 | 5 | 47031072 | |
sakila | category | 20772476736 | 41130 | 20772476736 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1367540592 | 0 | 0 | 0 | 5 | 84733968 | |
sakila | payment | 12782194656 | 16049 | 12782194656 | 0 | 0 | 0 | 0 | 0 | 0 | 48 | 835584 | 6774018240 | 0 | 0 | 0 | 5 | 42650784 | |
sakila | rental | 9696352512 | 16047 | 9696352512 | 0 | 0 | 0 | 0 | 0 | 0 | 53 | 917504 | 7320851472 | 0 | 0 | 0 | 5 | 52438320 | |
sakila | staff | 4325475792 | 10 | 4325475792 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 6307463184 | 0 | 0 | 0 | 5 | 19473604656 | |
world | City | 4045150032 | 4079 | 4045150032 | 0 | 0 | 0 | 0 | 0 | 0 | 4081 | 273685 | 2946877824 | 0 | 0 | 0 | 5 | 41551488 | |
sakila | address | 3689275392 | 3131 | 3689275392 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3034671552 | 0 | 0 | 0 | 5 | 46819344 | |
sakila | film_text | 2753619264 | 1000 | 2753619264 | 0 | 0 | 0 | 0 | 0 | 0 | 2002 | 119290 | 2462868144 | 0 | 0 | 0 | 1005 | 211057440 | |
vedettfak | fa | 2436195168 | 1258 | 2436195168 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 2064845376 | 0 | 0 | 0 | 5 | 54007536 | |
sakila | inventory | 2315600496 | 4781 | 2315600496 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 4089712176 | 0 | 0 | 0 | 5 | 43854624 | |
sakila | customer | 1621250400 | 799 | 1621250400 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 4734876432 | 0 | 0 | 0 | 5 | 43873104 | |
sku | Attore | 1565462976 | 1 | 1565462976 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2622723312 | 0 | 0 | 0 | 5 | 54814320 | |
sakila | city | 1349396400 | 804 | 1349396400 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 2330917776 | 0 | 0 | 0 | 5 | 42353520 | |
world | CountryLanguage | 1143286848 | 984 | 1143286848 | 0 | 0 | 0 | 0 | 0 | 0 | 986 | 38783 | 1610983440 | 0 | 0 | 0 | 5 | 31338384 | |
test19 | pilote | 892171104 | 30 | 892171104 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1919024448 | 0 | 0 | 0 | 5 | 54116304 | |
sakila | language | 816660240 | 131 | 816660240 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1147802304 | 0 | 0 | 0 | 5 | 75783312 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 807171024 | 24 | 807171024 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | country | 786404784 | 264 | 786404784 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1160839680 | 0 | 0 | 0 | 5 | 38314848 | |
world | Country | 779132640 | 239 | 779132640 | 0 | 0 | 0 | 0 | 0 | 0 | 241 | 62841 | 2122324512 | 0 | 0 | 0 | 5 | 27428016 | |
sakila | actor | 758827344 | 1800 | 758827344 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1075927248 | 0 | 0 | 0 | 5 | 56516592 | |
TlapaleriaMalfoy | Registro | 732736224 | 2 | 732736224 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1367276592 | 0 | 0 | 0 | 5 | 54925200 | |
test19 | ecurie | 718108512 | 4 | 718108512 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1363745856 | 0 | 0 | 0 | 5 | 52947840 | |
vedettfak | megye | 704089584 | 19 | 704089584 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1374944736 | 0 | 0 | 0 | 5 | 55488576 |
|