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 | 271877847648 | 330000 | 271877847648 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 947720928 | 0 | 0 | 0 | 5 | 17485776 | |
sakila | film | 154514177664 | 308294 | 154514177664 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 6350487264 | 0 | 0 | 0 | 5 | 37806384 | |
sakila | film_actor | 55786079712 | 330400 | 55786079712 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1984183344 | 0 | 0 | 0 | 5 | 20558736 | |
sakila | category | 5377813056 | 10270 | 5377813056 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 931571520 | 0 | 0 | 0 | 5 | 20645856 | |
sakila | address | 4129966368 | 229 | 4129966368 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 4345814880 | 0 | 0 | 0 | 5 | 42557328 | |
sakila | language | 2787184752 | 324 | 2787184752 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1010823264 | 0 | 0 | 0 | 5 | 54350208 | |
sakila | customer | 2226449808 | 3 | 2226449808 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 2275442400 | 0 | 0 | 0 | 5 | 68101968 | |
sakila | city | 1435349520 | 56 | 1435349520 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1311349248 | 0 | 0 | 0 | 5 | 36518064 | |
sakila | actor | 917967600 | 426 | 917967600 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 933323424 | 0 | 0 | 0 | 5 | 34118832 | |
sakila | staff | 910466832 | 4 | 910466832 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1009309488 | 0 | 0 | 0 | 5 | 37827504 | |
vedettfak | megye | 851464944 | 3 | 851464944 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 901917456 | 0 | 0 | 0 | 5 | 289444848 | |
sakila | country | 840188448 | 128 | 840188448 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 828586176 | 0 | 0 | 0 | 5 | 40718304 | |
sakila | store | 630770448 | 8 | 630770448 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 715531344 | 0 | 0 | 0 | 5 | 50479440 | |
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 |
|