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_category | 275749632576 | 330000 | 275749632576 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1255615152 | 0 | 0 | 0 | 5 | 36277296 | |
sakila | film | 141226320048 | 308307 | 141226320048 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1512982944 | 0 | 0 | 0 | 5 | 34376496 | |
sakila | film_actor | 52358610480 | 330426 | 52358610480 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 1571244576 | 0 | 0 | 0 | 5 | 35323728 | |
sakila | country | 6298787088 | 76 | 6298787088 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 5940571296 | 0 | 0 | 0 | 5 | 55041888 | |
sakila | customer | 5868479232 | 53 | 5868479232 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 4564116480 | 0 | 0 | 0 | 5 | 40026096 | |
sakila | city | 5408891136 | 328 | 5408891136 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 4702968864 | 0 | 0 | 0 | 5 | 48738624 | |
sakila | category | 5210262816 | 10270 | 5210262816 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 725631984 | 0 | 0 | 0 | 5 | 26045712 | |
sakila | actor | 3028724688 | 451 | 3028724688 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2839973664 | 0 | 0 | 0 | 5 | 38311680 | |
sakila | address | 1852364976 | 131 | 1852364976 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1685711280 | 0 | 0 | 0 | 5 | 43431168 | |
sakila | language | 1463280192 | 132 | 1463280192 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 800642832 | 0 | 0 | 0 | 5 | 41370384 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 933812352 | 42 | 933812352 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sys | sys_config | 616463232 | 1 | 616463232 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 737633952 | 0 | 0 | 0 | 5 | 43704672 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 16750272 | 1 | 16750272 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
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 | |
mysql | columns | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | foreign_key_column_usage | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | foreign_keys | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | index_column_usage | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | index_partitions | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | indexes | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|