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 | 79279825152 | 48167 | 79279825152 | 0 | 0 | 0 | 0 | 0 | 0 | 67 | 1146880 | 15677010624 | 0 | 0 | 0 | 5 | 43652400 | |
sakila | rental | 28859100336 | 57301 | 28859100336 | 0 | 0 | 0 | 0 | 0 | 0 | 70 | 1196032 | 11782946736 | 0 | 0 | 0 | 5 | 50006352 | |
sakila | film | 22986733968 | 6073 | 22986733968 | 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 | 4699458720 | 5495 | 4699458720 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 4070251680 | 0 | 0 | 0 | 5 | 35577168 | |
sakila | language | 3969879936 | 1030 | 3969879936 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 773329920 | 0 | 0 | 0 | 5 | 43546800 | |
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 | staff | 2781269040 | 37 | 2781269040 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 3554695584 | 0 | 0 | 0 | 5 | 30837840 | |
sakila | film_category | 2630538768 | 1001 | 2630538768 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 3035030064 | 0 | 0 | 0 | 5 | 32714352 | |
TlapaleriaMalfoy | Registro | 2611088304 | 26 | 2611088304 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1039827360 | 0 | 0 | 0 | 5 | 51362784 | |
sku | Attore | 2178210672 | 6 | 2178210672 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2272143456 | 0 | 0 | 0 | 5 | 35528064 | |
sakila | city | 2011806720 | 708 | 2011806720 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1115070528 | 0 | 0 | 0 | 5 | 53136864 | |
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 | address | 1483464048 | 762 | 1483464048 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2293536960 | 0 | 0 | 0 | 5 | 45112848 | |
sakila | customer | 1466628768 | 626 | 1466628768 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1911452928 | 0 | 0 | 0 | 5 | 38357616 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 1243952160 | 6 | 1243952160 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | country | 1162119024 | 165 | 1162119024 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 784632816 | 0 | 0 | 0 | 5 | 55902000 | |
world | Country | 1160991216 | 4 | 1160991216 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 984 | 1684259280 | 0 | 0 | 0 | 6 | 34674816 | |
sakila | actor | 769957056 | 553 | 769957056 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1343745216 | 0 | 0 | 0 | 5 | 62715840 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 723876912 | 28 | 723876912 | 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 | store | 451050864 | 14 | 451050864 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1134638208 | 0 | 0 | 0 | 5 | 23912592 | |
test19 | ecurie | 55115808 | 5 | 55115808 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 906535872 | 0 | 0 | 0 | 5 | 44507760 |
|