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 | 19695167184 | 1390 | 19695167184 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 4878254304 | 0 | 0 | 0 | 5 | 35838000 | |
sakila | payment | 13785194016 | 16049 | 13785194016 | 0 | 0 | 0 | 0 | 0 | 0 | 48 | 835584 | 11145789072 | 0 | 0 | 0 | 5 | 43652400 | |
sakila | rental | 9247970160 | 16044 | 9247970160 | 0 | 0 | 0 | 0 | 0 | 0 | 51 | 884736 | 6296466000 | 0 | 0 | 0 | 5 | 50006352 | |
sakila | film_actor | 4604104560 | 5465 | 4604104560 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 4070251680 | 0 | 0 | 0 | 5 | 35577168 | |
sakila | film_text | 2177318880 | 1000 | 2177318880 | 0 | 0 | 0 | 0 | 0 | 0 | 2002 | 119290 | 1501984704 | 0 | 0 | 0 | 1008 | 166332672 | |
sku | Attore | 2112742896 | 2 | 2112742896 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2272143456 | 0 | 0 | 0 | 5 | 35528064 | |
sakila | language | 2038456464 | 279 | 2038456464 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 773329920 | 0 | 0 | 0 | 5 | 43546800 | |
Table_insertion | voiture | 1884346464 | 2 | 1884346464 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 4462592640 | 0 | 0 | 0 | 5 | 37074576 | |
sys | sys_config | 1771922064 | 2 | 1771922064 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1799347968 | 0 | 0 | 0 | 5 | 57375120 | |
sakila | inventory | 1583514240 | 4581 | 1583514240 | 0 | 0 | 0 | 0 | 0 | 0 | 14 | 278528 | 1930363776 | 0 | 0 | 0 | 5 | 52954704 | |
sakila | city | 1567945104 | 626 | 1567945104 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1115070528 | 0 | 0 | 0 | 5 | 53136864 | |
sakila | address | 1321732368 | 605 | 1321732368 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2293536960 | 0 | 0 | 0 | 5 | 45112848 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 1187522688 | 2 | 1187522688 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | country | 968344080 | 136 | 968344080 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 784632816 | 0 | 0 | 0 | 5 | 55902000 | |
world | Country | 874224912 | 2 | 874224912 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 723 | 1416596544 | 0 | 0 | 0 | 5 | 25256352 | |
sakila | customer | 775771920 | 599 | 775771920 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1447678320 | 0 | 0 | 0 | 5 | 38357616 | |
sakila | film_category | 767703024 | 1000 | 767703024 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1213780656 | 0 | 0 | 0 | 5 | 32714352 | |
sakila | staff | 709147296 | 2 | 709147296 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1745042640 | 0 | 0 | 0 | 5 | 30837840 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 695825328 | 26 | 695825328 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
test19 | voiture | 677938272 | 2 | 677938272 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1139869632 | 0 | 0 | 0 | 5 | 33567600 | |
sakila | actor | 561567600 | 426 | 561567600 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1343745216 | 0 | 0 | 0 | 5 | 62715840 | |
TlapaleriaMalfoy | Registro | 417096768 | 2 | 417096768 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1039827360 | 0 | 0 | 0 | 5 | 51362784 | |
world | City | 344446080 | 26 | 344446080 | 0 | 0 | 0 | 0 | 0 | 0 | 27 | 2067 | 590280240 | 0 | 0 | 0 | 5 | 24032448 | |
sakila | category | 24559920 | 16 | 24559920 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 904090176 | 0 | 0 | 0 | 5 | 33751872 | |
test19 | ecurie | 21837552 | 2 | 21837552 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 906535872 | 0 | 0 | 0 | 5 | 44507760 |
|