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 | address | 4307653680 | 52 | 4307653680 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 4729811856 | 0 | 0 | 0 | 5 | 37343328 | |
sakila | actor | 2635159296 | 29 | 2635159296 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2699036208 | 0 | 0 | 0 | 5 | 49842144 | |
sakila | city | 2007264336 | 76 | 2007264336 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1703841744 | 0 | 0 | 0 | 5 | 41996064 | |
sys | sys_config | 1657150176 | 1 | 1657150176 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1911431280 | 0 | 0 | 0 | 5 | 44464464 | |
sakila | country | 835054176 | 51 | 835054176 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 572658768 | 0 | 0 | 0 | 5 | 298109856 | |
sakila | category | 762619968 | 17 | 762619968 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1083982416 | 0 | 0 | 0 | 5 | 53737728 | |
sakila | film | 705349392 | 78 | 705349392 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2097206496 | 0 | 0 | 0 | 5 | 33542784 | |
sakila | language | 518710368 | 75 | 518710368 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 705785520 | 0 | 0 | 0 | 5 | 31260240 | |
test1234 | customers | 233506416 | 6 | 61932816 | 2 | 171573600 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 245760 | 223138080 | 8 | 64727825712 | |
test1234 | orders_old | 133737648 | 15 | 133737648 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 245760 | 210100176 | 10 | 66498135264 | |
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 |
|