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 | 1410415507248 | 1651027 | 1410415507248 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 2596997040 | 0 | 0 | 0 | 5 | 20491152 | |
sakila | film | 765304401840 | 1541915 | 765304401840 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2583265344 | 0 | 0 | 0 | 5 | 21003312 | |
sakila | film_actor | 304665445392 | 1657462 | 304665445392 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 376832 | 6046829712 | 0 | 0 | 0 | 5 | 20537616 | |
sakila | category | 25692784656 | 51375 | 25692784656 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 721416960 | 0 | 0 | 0 | 5 | 18806304 | |
sakila | rental | 5615169648 | 52 | 5615169648 | 0 | 0 | 0 | 0 | 0 | 0 | 53 | 917504 | 16286129376 | 0 | 0 | 0 | 5 | 51148416 | |
sakila | city | 4777334496 | 106 | 4777334496 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 4499729520 | 0 | 0 | 0 | 5 | 41839248 | |
sakila | customer | 4760204064 | 76 | 4760204064 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 4868916096 | 0 | 0 | 0 | 5 | 57585264 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 3974937120 | 2 | 3974937120 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
Stefano | vulcano | 3792753360 | 10 | 3792753360 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4003609104 | 0 | 0 | 0 | 5 | 35430384 | |
www | students | 3446073312 | 241 | 2708220768 | 5 | 737852544 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 245760 | 467958480 | 8 | 70436198448 | |
sakila | actor | 3241842912 | 2696 | 3241842912 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1415623968 | 0 | 0 | 0 | 5 | 34074480 | |
www | courses | 2343881760 | 161 | 2276176320 | 4 | 67705440 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 216600384 | 7 | 75780817200 | |
sakila | address | 2214314256 | 1339 | 2214314256 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1705112640 | 0 | 0 | 0 | 5 | 37013328 | |
www | enrollments | 1920896208 | 194 | 1872705648 | 6 | 48190560 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 241055232 | 7 | 54605704032 | |
sakila | language | 1682153616 | 125 | 1682153616 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 992989008 | 0 | 0 | 0 | 5 | 56667072 | |
sakila | country | 1482687888 | 327 | 1482687888 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1164363552 | 0 | 0 | 0 | 5 | 42767472 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 1302960912 | 40 | 1302960912 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | staff | 1151680464 | 50 | 1151680464 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1055117184 | 0 | 0 | 0 | 5 | 29618688 | |
sakila | film_text | 959073984 | 82 | 959073984 | 0 | 0 | 0 | 0 | 0 | 0 | 152 | 9361 | 1180303872 | 0 | 0 | 0 | 85 | 108254784 | |
sys | sys_config | 56413632 | 8 | 56413632 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2261991072 | 0 | 0 | 0 | 5 | 52386048 | |
Table_insertion | pilote | 40654416 | 26 | 40654416 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1094480112 | 0 | 0 | 0 | 5 | 31770288 | |
Table_insertion | ecurie | 25275360 | 2 | 25275360 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1278203520 | 0 | 0 | 0 | 5 | 47171520 | |
mysql | dd_properties | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | schemata | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | tablespace_files | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|