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 | 79247325696 | 48165 | 79247325696 | 0 | 0 | 0 | 0 | 0 | 0 | 67 | 1146880 | 15677010624 | 0 | 0 | 0 | 5 | 43652400 | |
sakila | rental | 28791819408 | 57298 | 28791819408 | 0 | 0 | 0 | 0 | 0 | 0 | 70 | 1196032 | 11782946736 | 0 | 0 | 0 | 5 | 50006352 | |
sakila | film | 21400736016 | 3678 | 21400736016 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 4878254304 | 0 | 0 | 0 | 5 | 35838000 | |
sakila | inventory | 5350956864 | 13747 | 5350956864 | 0 | 0 | 0 | 0 | 0 | 0 | 21 | 393216 | 4388785104 | 0 | 0 | 0 | 5 | 52954704 | |
sakila | film_actor | 4625280528 | 5467 | 4625280528 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 4070251680 | 0 | 0 | 0 | 5 | 35577168 | |
sakila | film_text | 2849006688 | 1001 | 2849006688 | 0 | 0 | 0 | 0 | 0 | 0 | 2002 | 119290 | 1501984704 | 0 | 0 | 0 | 1008 | 166332672 | |
world | City | 2810114208 | 108 | 2810114208 | 0 | 0 | 0 | 0 | 0 | 0 | 102 | 7092 | 2572121904 | 0 | 0 | 0 | 9 | 80269200 | |
sakila | language | 2671762896 | 498 | 2671762896 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 773329920 | 0 | 0 | 0 | 5 | 43546800 | |
TlapaleriaMalfoy | Registro | 2375087088 | 4 | 2375087088 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1039827360 | 0 | 0 | 0 | 5 | 51362784 | |
sku | Attore | 2132303712 | 3 | 2132303712 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2272143456 | 0 | 0 | 0 | 5 | 35528064 | |
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 | city | 1750739232 | 655 | 1750739232 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1115070528 | 0 | 0 | 0 | 5 | 53136864 | |
sakila | customer | 1466628768 | 626 | 1466628768 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1911452928 | 0 | 0 | 0 | 5 | 38357616 | |
sakila | address | 1384275552 | 635 | 1384275552 | 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 | |
world | Country | 1160991216 | 4 | 1160991216 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 984 | 1684259280 | 0 | 0 | 0 | 6 | 34674816 | |
sakila | country | 975656352 | 140 | 975656352 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 784632816 | 0 | 0 | 0 | 5 | 55902000 | |
sakila | staff | 876602496 | 31 | 876602496 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1745042640 | 0 | 0 | 0 | 5 | 30837840 | |
sakila | film_category | 767703024 | 1000 | 767703024 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1213780656 | 0 | 0 | 0 | 5 | 32714352 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 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 | 583438944 | 526 | 583438944 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1343745216 | 0 | 0 | 0 | 5 | 62715840 | |
sakila | store | 41347152 | 8 | 41347152 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 795442032 | 0 | 0 | 0 | 5 | 23912592 | |
sakila | category | 24559920 | 16 | 24559920 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 904090176 | 0 | 0 | 0 | 5 | 33751872 |
|