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 | 287853743232 | 330062 | 287853743232 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1624870896 | 0 | 0 | 0 | 5 | 31797216 | |
sakila | film | 162390502032 | 308228 | 162390502032 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1785681744 | 0 | 0 | 0 | 5 | 41565216 | |
sakila | film_actor | 59310849312 | 330400 | 59310849312 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1576949616 | 0 | 0 | 0 | 5 | 50259792 | |
sys | sys_config | 16611303984 | 5 | 16611303984 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2281697088 | 0 | 0 | 0 | 5 | 323067360 | |
sakila | category | 7317535632 | 10337 | 7317535632 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1734552336 | 0 | 0 | 0 | 5 | 92260608 | |
sakila | address | 2168817552 | 118 | 2168817552 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3127016112 | 0 | 0 | 0 | 5 | 38788464 | |
sakila | payment | 1081675584 | 1 | 1081675584 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 868352 | 7752177840 | 0 | 0 | 0 | 5 | 30846816 | |
sakila | customer | 920374224 | 62 | 920374224 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1656041904 | 0 | 0 | 0 | 5 | 31705872 | |
sakila | city | 654687792 | 132 | 654687792 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1463260656 | 0 | 0 | 0 | 5 | 31627200 | |
world | CountryLanguage | 583403568 | 62 | 583403568 | 0 | 0 | 0 | 0 | 0 | 0 | 52 | 2357 | 1072560192 | 0 | 0 | 0 | 11 | 98370096 | |
sakila | actor | 544026912 | 426 | 544026912 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1298226336 | 0 | 0 | 0 | 5 | 39992304 | |
sakila | country | 493977264 | 80 | 493977264 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 812694432 | 0 | 0 | 0 | 5 | 26552592 | |
sakila | store | 366226080 | 3 | 366226080 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1227249936 | 0 | 0 | 0 | 5 | 27817152 | |
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 |
|