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 | 279401872992 | 330000 | 279401872992 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1278319680 | 0 | 0 | 0 | 5 | 29751216 | |
sakila | film | 147252861360 | 308203 | 147252861360 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2057103840 | 0 | 0 | 0 | 5 | 23365584 | |
sakila | film_actor | 54066006720 | 330400 | 54066006720 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1899241872 | 0 | 0 | 0 | 5 | 18222864 | |
sakila | category | 4830950784 | 10270 | 4830950784 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1022334720 | 0 | 0 | 0 | 5 | 30495168 | |
sys | sys_config | 1936498608 | 1 | 1936498608 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1162435296 | 0 | 0 | 0 | 5 | 996781632 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 1715174736 | 25 | 1715174736 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | city | 1670708160 | 51 | 1670708160 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1461679296 | 0 | 0 | 0 | 5 | 51318960 | |
sakila | country | 1246425840 | 25 | 1246425840 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1106337408 | 0 | 0 | 0 | 5 | 54796368 | |
sakila | address | 979451088 | 26 | 979451088 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2058714240 | 0 | 0 | 0 | 5 | 41827632 | |
sakila | inventory | 661278288 | 26 | 661278288 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2675191728 | 0 | 0 | 0 | 5 | 31058544 | |
sakila | language | 218076144 | 25 | 218076144 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 806009952 | 0 | 0 | 0 | 5 | 33615648 | |
sakila | actor | 142974480 | 400 | 142974480 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1939657632 | 0 | 0 | 0 | 5 | 33309408 | |
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 | |
mysql | table_partition_values | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|