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 | 9220802976 | 3902 | 9220802976 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 728975808 | 0 | 0 | 0 | 5 | 34090320 | |
sakila | film | 6179979696 | 756 | 6179979696 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1445925888 | 0 | 0 | 0 | 5 | 54096240 | |
sakila | city | 5047133520 | 233 | 5047133520 | 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 | 2290733808 | 284 | 2290733808 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 884856720 | 0 | 0 | 0 | 5 | 53196000 | |
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 | 466881360 | 27 | 466881360 | 0 | 0 | 0 | 0 | 0 | 0 | 52 | 3415 | 820909056 | 0 | 0 | 0 | 33 | 45314544 | |
tb | users | 205081008 | 10 | 167652144 | 1 | 37428864 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 211870560 | 7 | 59954250048 | |
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 |
|