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 | 307761855984 | 330000 | 307761855984 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1104416544 | 0 | 0 | 0 | 5 | 33887040 | |
sakila | film | 164299498704 | 308154 | 164299498704 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2093505744 | 0 | 0 | 0 | 5 | 35462064 | |
sakila | film_actor | 61161368928 | 330400 | 61161368928 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1866459936 | 0 | 0 | 0 | 5 | 51625200 | |
klo | ChangeLogs | 22007960304 | 171 | 1101131856 | 18 | 20906828448 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 262144 | 328617168 | 9 | 67550544864 | |
sakila | category | 5549944752 | 10270 | 5549944752 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 927070320 | 0 | 0 | 0 | 5 | 41552544 | |
klo | RentalPoints | 3621689280 | 115 | 3114273888 | 2 | 90807024 | 2 | 128998320 | 2 | 287610048 | 0 | 0 | 0 | 12 | 294912 | 395608224 | 12 | 96651721056 | |
klo | Vehicles | 3221245104 | 120 | 685468608 | 1 | 69598848 | 1 | 50296752 | 2 | 2415880896 | 0 | 0 | 0 | 12 | 294912 | 856673664 | 12 | 98606012736 | |
sakila | customer | 1727743248 | 30 | 1727743248 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 2114391840 | 0 | 0 | 0 | 5 | 21541344 | |
klo | Parks | 1473303216 | 95 | 898736784 | 2 | 110740608 | 2 | 185300544 | 2 | 278525280 | 0 | 0 | 0 | 9 | 245760 | 5184984816 | 8 | 81585383616 | |
sakila | address | 1347892656 | 27 | 1347892656 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1979887008 | 0 | 0 | 0 | 5 | 18515376 | |
sys | sys_config | 794739792 | 7 | 794739792 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 598992768 | 0 | 0 | 0 | 5 | 263249184 | |
sakila | country | 661459392 | 2 | 661459392 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 822335184 | 0 | 0 | 0 | 5 | 38174400 | |
sakila | city | 630495888 | 2 | 630495888 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1448011488 | 0 | 0 | 0 | 5 | 19745616 | |
klo | Rentals | 599435232 | 56 | 498093552 | 1 | 45029424 | 1 | 19351728 | 1 | 36960528 | 0 | 0 | 0 | 10 | 262144 | 4769925600 | 10 | 70350748512 | |
sakila | actor | 368887200 | 453 | 368887200 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1724980224 | 0 | 0 | 0 | 5 | 50162640 | |
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 |
|