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 | 167379476880 | 165000 | 167379476880 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 912693408 | 0 | 0 | 0 | 5 | 23896224 | |
sakila | film | 90010822176 | 154153 | 90010822176 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1605058224 | 0 | 0 | 0 | 5 | 45052128 | |
sakila | film_actor | 38955375888 | 165200 | 38955375888 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 4918855920 | 0 | 0 | 0 | 5 | 44617056 | |
sakila | category | 3550985328 | 5135 | 3550985328 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 641869008 | 0 | 0 | 0 | 5 | 22348656 | |
sakila | actor | 3519756768 | 200 | 3519756768 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3600706560 | 0 | 0 | 0 | 5 | 55087824 | |
sakila | address | 2961903120 | 25 | 2961903120 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2867614992 | 0 | 0 | 0 | 5 | 38633760 | |
sakila | customer | 2850307152 | 26 | 2850307152 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3205784208 | 0 | 0 | 0 | 5 | 44052096 | |
sakila | language | 1422567696 | 50 | 1422567696 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 940879104 | 0 | 0 | 0 | 5 | 80280816 | |
sys | sys_config | 1313987136 | 3 | 1313987136 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 802476048 | 0 | 0 | 0 | 5 | 721403760 | |
sakila | inventory | 1111976448 | 26 | 1111976448 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2850387408 | 0 | 0 | 0 | 5 | 60572688 | |
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 | |
mysql | table_partitions | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | tables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|