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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys | sys_config | 16611303984 | 5 | 16611303984 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2281697088 | 0 | 0 | 0 | 5 | 323067360 | |
sakila | address | 2088497136 | 64 | 2088497136 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3127016112 | 0 | 0 | 0 | 5 | 38788464 | |
sakila | category | 1644790224 | 42 | 1644790224 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1734552336 | 0 | 0 | 0 | 5 | 92260608 | |
sakila | customer | 823365840 | 35 | 823365840 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1656041904 | 0 | 0 | 0 | 5 | 31705872 | |
world | CountryLanguage | 583403568 | 62 | 583403568 | 0 | 0 | 0 | 0 | 0 | 0 | 52 | 2357 | 1072560192 | 0 | 0 | 0 | 11 | 98370096 | |
sakila | city | 557379504 | 70 | 557379504 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1463260656 | 0 | 0 | 0 | 5 | 31627200 | |
sakila | film | 537240528 | 51 | 537240528 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1785681744 | 0 | 0 | 0 | 5 | 41565216 | |
sakila | film_category | 492374784 | 28 | 492374784 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1624870896 | 0 | 0 | 0 | 5 | 31797216 | |
sakila | store | 366226080 | 3 | 366226080 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1227249936 | 0 | 0 | 0 | 5 | 27817152 | |
sakila | actor | 334198656 | 26 | 334198656 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1298226336 | 0 | 0 | 0 | 5 | 39992304 | |
sakila | country | 274454400 | 44 | 274454400 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 812694432 | 0 | 0 | 0 | 5 | 26552592 | |
sakila | language | 179977248 | 25 | 179977248 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 750381456 | 0 | 0 | 0 | 5 | 71783184 | |
sakila | staff | 24253680 | 2 | 24253680 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 910096176 | 0 | 0 | 0 | 5 | 28703136 | |
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 |
|