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 | country | 4362913104 | 101 | 4362913104 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3875582832 | 0 | 0 | 0 | 5 | 53704464 | |
sakila | address | 3933291120 | 51 | 3933291120 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3987910080 | 0 | 0 | 0 | 5 | 50055456 | |
sakila | actor | 3125852928 | 208 | 3125852928 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2524496832 | 0 | 0 | 0 | 5 | 48313056 | |
sakila | film | 2718167760 | 277 | 2718167760 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 3381392256 | 0 | 0 | 0 | 5 | 35342736 | |
sakila | store | 1448746464 | 8 | 1448746464 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1550093952 | 0 | 0 | 0 | 5 | 74243664 | |
sakila | city | 1427640720 | 103 | 1427640720 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1125722400 | 0 | 0 | 0 | 5 | 50646816 | |
sakila | inventory | 1258545024 | 3 | 1258545024 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1192295808 | 0 | 0 | 0 | 5 | 40270032 | |
sakila | customer | 1047727824 | 26 | 1047727824 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2733920112 | 0 | 0 | 0 | 5 | 41364576 | |
sakila | film_category | 979879824 | 26 | 979879824 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1128341808 | 0 | 0 | 0 | 5 | 42519312 | |
sakila | category | 941964672 | 25 | 941964672 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1008769872 | 0 | 0 | 0 | 5 | 40472256 | |
sakila | language | 834411600 | 50 | 834411600 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 676506864 | 0 | 0 | 0 | 5 | 39565680 | |
sakila | film_text | 719697792 | 54 | 719697792 | 0 | 0 | 0 | 0 | 0 | 0 | 102 | 6388 | 706896432 | 0 | 0 | 0 | 59 | 75841920 | |
sys | sys_config | 521367792 | 1 | 521367792 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 768074736 | 0 | 0 | 0 | 5 | 39734640 | |
vismi | employee | 118317936 | 5 | 84148944 | 1 | 34168992 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 132653136 | 7 | 58294262400 | |
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 |
|