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 | 61544591328 | 361 | 61544591328 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 8161191456 | 0 | 0 | 0 | 5 | 51057072 | |
sys | sys_config | 25702158768 | 62 | 25702158768 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 24787196016 | 0 | 0 | 0 | 5 | 70000128 | |
sakila | film_actor | 1751070816 | 2 | 1751070816 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 717479204112 | 0 | 0 | 0 | 5 | 38825424 | |
sakila | store | 1612272288 | 11 | 1612272288 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2089626000 | 0 | 0 | 0 | 5 | 32114544 | |
sakila | country | 1447879488 | 178 | 1447879488 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 863892480 | 0 | 0 | 0 | 5 | 47551152 | |
sakila | city | 1381068480 | 129 | 1381068480 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1178208240 | 0 | 0 | 0 | 5 | 97336272 | |
sakila | inventory | 1301304048 | 29 | 1301304048 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 3348685296 | 0 | 0 | 0 | 5 | 52166400 | |
animales | animal | 1196251584 | 8 | 50065488 | 7 | 1128945840 | 1 | 17240256 | 0 | 0 | 0 | 0 | 0 | 15 | 344064 | 622476624 | 14 | 103061887632 | |
sakila | actor | 1017271728 | 227 | 1017271728 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1146578400 | 0 | 0 | 0 | 5 | 39870864 | |
cantantes | cantantes | 891683760 | 4 | 91068912 | 5 | 800614848 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 120508608 | 7 | 87302033808 | |
sakila | language | 835533600 | 125 | 835533600 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1086158304 | 0 | 0 | 0 | 5 | 50074464 | |
CELULARES | CELULARES | 626438736 | 3 | 73190832 | 5 | 553247904 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 245760 | 833271648 | 8 | 87351108240 | |
Pelicula | Pelicula | 532553472 | 13 | 164243904 | 5 | 368309568 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 418102608 | 7 | 58473540048 | |
Dragonballr | personaje | 470833440 | 9 | 91491840 | 5 | 379341600 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 340009296 | 7 | 75138874800 | |
rs3m | modelos | 457330896 | 8 | 61784976 | 5 | 395545920 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 245760 | 519939024 | 9 | 106184562528 | |
JUEGOS | FRANQUICIAS | 452994432 | 13 | 207958080 | 4 | 217372320 | 1 | 27664032 | 0 | 0 | 0 | 0 | 0 | 10 | 262144 | 239935344 | 9 | 68335916880 | |
sakila | address | 409893264 | 28 | 409893264 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1958374704 | 0 | 0 | 0 | 5 | 40562016 | |
PELICULAS | TERROR | 353997600 | 3 | 38841792 | 5 | 315155808 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 610335264 | 7 | 68958825936 | |
Musica | Canciones | 150500064 | 5 | 117336912 | 1 | 33163152 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 461870640 | 8 | 103743944304 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 105101040 | 50 | 105101040 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 59740032 | 6 | 59740032 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | staff | 35980560 | 2 | 35980560 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2470768080 | 0 | 0 | 0 | 5 | 32538000 | |
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 |
|