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 | 208095211104 | 96290 | 208095211104 | 0 | 0 | 0 | 0 | 0 | 0 | 67 | 1146880 | 11784769392 | 0 | 0 | 0 | 5 | 38893008 | |
sakila | film_category | 152758006368 | 170133 | 152758006368 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1952307984 | 0 | 0 | 0 | 5 | 25915296 | |
sakila | film | 92018182608 | 159413 | 92018182608 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 3502471104 | 0 | 0 | 0 | 5 | 48080208 | |
sakila | rental | 48495663744 | 123750 | 48495663744 | 0 | 0 | 0 | 0 | 0 | 0 | 68 | 1163264 | 53100722400 | 0 | 0 | 0 | 5 | 48323088 | |
sakila | film_actor | 34001844624 | 165201 | 34001844624 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 16280808720 | 0 | 0 | 0 | 5 | 37066656 | |
sakila | inventory | 19909265376 | 32593 | 19909265376 | 0 | 0 | 0 | 0 | 0 | 0 | 26 | 475136 | 11086806720 | 0 | 0 | 0 | 5 | 32626704 | |
sakila | category | 3255476400 | 5270 | 3255476400 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 827549712 | 0 | 0 | 0 | 5 | 33434544 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 3236401872 | 40 | 3236401872 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | film_text | 2163176928 | 1 | 2163176928 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 442 | 592678944 | 0 | 0 | 0 | 5 | 36119952 | |
sakila | address | 2092635600 | 59 | 2092635600 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 7148044464 | 0 | 0 | 0 | 5 | 26122272 | |
sys | sys_config | 1922600592 | 2 | 1922600592 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 811865472 | 0 | 0 | 0 | 5 | 50909760 | |
sakila | staff | 1823035104 | 28 | 1823035104 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2242040064 | 0 | 0 | 0 | 5 | 72960624 | |
sakila | city | 1523100480 | 361 | 1523100480 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 940646256 | 0 | 0 | 0 | 5 | 37441536 | |
vedettfak | fa | 1457880864 | 4 | 1457880864 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 245760 | 2121189312 | 0 | 0 | 0 | 5 | 34137840 | |
sakila | country | 1324521264 | 208 | 1324521264 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 698048736 | 0 | 0 | 0 | 5 | 39329664 | |
sakila | language | 1237973088 | 175 | 1237973088 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 746873952 | 0 | 0 | 0 | 5 | 29316672 | |
Stefano | vulcano | 1090135200 | 2 | 1090135200 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 925274064 | 0 | 0 | 0 | 5 | 37969536 | |
sakila | customer | 639157728 | 26 | 639157728 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3196136592 | 0 | 0 | 0 | 5 | 53782080 | |
sakila | actor | 552125376 | 202 | 552125376 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 5906122464 | 0 | 0 | 0 | 5 | 44580624 | |
world | Country | 376016256 | 3 | 376016256 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 723 | 1025442528 | 0 | 0 | 0 | 5 | 23879856 | |
Table_insertion | pilote | 53815872 | 4 | 53815872 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 886376832 | 0 | 0 | 0 | 5 | 56446896 | |
world | CountryLanguage | 34136784 | 1 | 34136784 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 407 | 526250208 | 0 | 0 | 0 | 4 | 24544608 | |
test19 | pilote | 22982256 | 2 | 22982256 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2599125408 | 0 | 0 | 0 | 5 | 48697440 | |
Table_insertion | ecurie | 20841216 | 1 | 20841216 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1081085280 | 0 | 0 | 0 | 5 | 39208224 | |
TlapaleriaMalfoy | Registro | 20813232 | 1 | 20813232 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1000014576 | 0 | 0 | 0 | 5 | 60340896 |
|