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 | 16262038320 | 92 | 16262038320 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 23388916848 | 0 | 0 | 0 | 5 | 34599840 | |
sakila | staff | 15498338592 | 46 | 15498338592 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 15130738128 | 0 | 0 | 0 | 5 | 32870112 | |
sakila | category | 5238145440 | 17 | 5238145440 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 5422326096 | 0 | 0 | 0 | 5 | 43716816 | |
sakila | payment | 5205937440 | 2 | 5205937440 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 5257540464 | 0 | 0 | 0 | 5 | 56969088 | |
sakila | customer | 5162809872 | 27 | 5162809872 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 4066433712 | 0 | 0 | 0 | 5 | 853706832 | |
sys | sys_config | 4076059152 | 7 | 4076059152 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 785287008 | 0 | 0 | 0 | 5 | 694044384 | |
sakila | city | 4060266672 | 55 | 4060266672 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 4043417136 | 0 | 0 | 0 | 5 | 45959232 | |
sakila | film_actor | 4022725872 | 2 | 4022725872 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2996473920 | 0 | 0 | 0 | 5 | 49612464 | |
sakila | store | 1842519360 | 22 | 1842519360 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1782937200 | 0 | 0 | 0 | 5 | 31884864 | |
sakila | language | 1544303904 | 50 | 1544303904 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 784237872 | 0 | 0 | 0 | 5 | 654506688 | |
sakila | inventory | 1479512496 | 26 | 1479512496 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1938069408 | 0 | 0 | 0 | 5 | 316460496 | |
db | Acquisti | 1239793632 | 107 | 1027895088 | 8 | 211898544 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 159539952 | 6 | 49935263136 | |
sakila | country | 1002806640 | 76 | 1002806640 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 818664000 | 0 | 0 | 0 | 5 | 35645808 | |
TlapaleriaMalfoy | Registro | 911647440 | 2 | 911647440 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 762700752 | 0 | 0 | 0 | 5 | 34355904 | |
sakila | address | 672560064 | 500 | 672560064 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 723314064 | 0 | 0 | 0 | 5 | 34254000 | |
sakila | rental | 443232240 | 27 | 443232240 | 0 | 0 | 0 | 0 | 0 | 0 | 53 | 917504 | 5499023376 | 0 | 0 | 0 | 5 | 58751088 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 170918352 | 12 | 170918352 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | film_category | 47460864 | 1 | 47460864 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1022077056 | 0 | 0 | 0 | 5 | 47149872 | |
world | CountryLanguage | 41739984 | 1 | 41739984 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 407 | 337568352 | 0 | 0 | 0 | 4 | 23479632 | |
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 | |
mysql | tablespaces | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | check_constraints | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | column_type_elements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|