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 | 42586101888 | 16049 | 42586101888 | 0 | 0 | 0 | 0 | 0 | 0 | 48 | 835584 | 7563722496 | 0 | 0 | 0 | 5 | 43313952 | |
sakila | rental | 29998475760 | 16044 | 29998475760 | 0 | 0 | 0 | 0 | 0 | 0 | 51 | 884736 | 8841607632 | 0 | 0 | 0 | 5 | 52158480 | |
sakila | inventory | 16912253952 | 4581 | 16912253952 | 0 | 0 | 0 | 0 | 0 | 0 | 14 | 278528 | 3393084288 | 0 | 0 | 0 | 5 | 12336447552 | |
sakila | film_actor | 8224972272 | 5462 | 8224972272 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 4897673616 | 0 | 0 | 0 | 5 | 55117920 | |
sakila | film | 5157944880 | 1130 | 5157944880 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1664999952 | 0 | 0 | 0 | 5 | 38329632 | |
sakila | film_category | 3587267904 | 1000 | 3587267904 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 3169784112 | 0 | 0 | 0 | 5 | 44051568 | |
world | City | 3114057936 | 4079 | 3114057936 | 0 | 0 | 0 | 0 | 0 | 0 | 4081 | 273685 | 2198746176 | 0 | 0 | 0 | 4 | 30585456 | |
sakila | address | 2562704496 | 679 | 2562704496 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1624983888 | 0 | 0 | 0 | 5 | 44387376 | |
sakila | customer | 2383851888 | 651 | 2383851888 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1380413760 | 0 | 0 | 0 | 5 | 54174384 | |
vedettfak | fa | 2197222368 | 1258 | 2197222368 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 1528700448 | 0 | 0 | 0 | 5 | 221782176 | |
sakila | film_text | 1763002032 | 1000 | 1763002032 | 0 | 0 | 0 | 0 | 0 | 0 | 2002 | 119290 | 1522427808 | 0 | 0 | 0 | 1004 | 173646528 | |
sakila | city | 1716589776 | 755 | 1716589776 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1052467152 | 0 | 0 | 0 | 5 | 41644944 | |
test19 | voiture | 1695547392 | 14 | 1695547392 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1829664144 | 0 | 0 | 0 | 5 | 46577520 | |
sakila | language | 1616477808 | 131 | 1616477808 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 790086528 | 0 | 0 | 0 | 5 | 44181984 | |
sakila | country | 1442094192 | 261 | 1442094192 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1720691280 | 0 | 0 | 0 | 5 | 38708736 | |
world | CountryLanguage | 1410049344 | 984 | 1410049344 | 0 | 0 | 0 | 0 | 0 | 0 | 986 | 38783 | 1201557984 | 0 | 0 | 0 | 4 | 20758320 | |
sku | Attore | 1383004128 | 1 | 1383004128 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1308604176 | 0 | 0 | 0 | 5 | 270052464 | |
sakila | staff | 1309238832 | 2 | 1309238832 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1347715248 | 0 | 0 | 0 | 5 | 43735296 | |
world | Country | 941540160 | 239 | 941540160 | 0 | 0 | 0 | 0 | 0 | 0 | 241 | 62841 | 2096317872 | 0 | 0 | 0 | 4 | 19360704 | |
sakila | actor | 757026864 | 200 | 757026864 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 768748464 | 0 | 0 | 0 | 5 | 43318704 | |
test19 | ecurie | 742629360 | 4 | 742629360 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 879630576 | 0 | 0 | 0 | 5 | 63704784 | |
sakila | store | 728759856 | 2 | 728759856 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 808240752 | 0 | 0 | 0 | 5 | 46119216 | |
test19 | pilote | 721891104 | 30 | 721891104 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 830599440 | 0 | 0 | 0 | 5 | 46705296 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 705512544 | 24 | 705512544 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 701724672 | 3 | 701724672 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|