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 | language | 11471336448 | 4774 | 11471336448 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 728975808 | 0 | 0 | 0 | 5 | 34090320 | |
sakila | film | 7556230176 | 1008 | 7556230176 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1445925888 | 0 | 0 | 0 | 5 | 54096240 | |
sakila | city | 5123826576 | 285 | 5123826576 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 4554923472 | 0 | 0 | 0 | 5 | 79902240 | |
sakila | address | 4414609584 | 53 | 4414609584 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 4630224720 | 0 | 0 | 0 | 5 | 34413984 | |
sakila | customer | 4279558272 | 26 | 4279558272 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 4862363088 | 0 | 0 | 0 | 5 | 35938848 | |
sys | sys_config | 3026742048 | 1 | 3026742048 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2811659664 | 0 | 0 | 0 | 5 | 73660752 | |
sakila | country | 2569260144 | 334 | 2569260144 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 884856720 | 0 | 0 | 0 | 5 | 53196000 | |
world | City | 2057943360 | 56 | 2057943360 | 0 | 0 | 0 | 0 | 0 | 0 | 52 | 3742 | 2315352864 | 0 | 0 | 0 | 10 | 77781792 | |
sakila | store | 1450952448 | 3 | 1450952448 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1582460880 | 0 | 0 | 0 | 5 | 54417792 | |
sakila | staff | 1389779952 | 2 | 1389779952 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1499159904 | 0 | 0 | 0 | 5 | 61209456 | |
sakila | actor | 1164620160 | 78 | 1164620160 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1111193952 | 0 | 0 | 0 | 5 | 40112688 | |
sakila | film_text | 516840192 | 54 | 516840192 | 0 | 0 | 0 | 0 | 0 | 0 | 102 | 6388 | 834457008 | 0 | 0 | 0 | 60 | 66707520 | |
tb | users | 475637712 | 22 | 375004080 | 3 | 100633632 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 211870560 | 7 | 59954250048 | |
sku | Attore | 131690592 | 8 | 131690592 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 860618352 | 0 | 0 | 0 | 5 | 43491888 | |
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 |
|