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 | city | 5130933456 | 102 | 5130933456 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 4788040752 | 0 | 0 | 0 | 5 | 96736992 | |
sakila | address | 4817587632 | 79 | 4817587632 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 5095563264 | 0 | 0 | 0 | 5 | 42854064 | |
sakila | customer | 4668417072 | 26 | 4668417072 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 5102190720 | 0 | 0 | 0 | 5 | 52246128 | |
what | orders_deprecated | 4312346544 | 20 | 4312346544 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 297233376 | 9 | 80957615904 | |
what | addresses | 1569811056 | 73 | 677540688 | 3 | 892270368 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 255203520 | 7 | 74694351600 | |
sakila | country | 1548160944 | 50 | 1548160944 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1315830384 | 0 | 0 | 0 | 5 | 62409600 | |
sakila | language | 1545310272 | 125 | 1545310272 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 737151360 | 0 | 0 | 0 | 5 | 56103696 | |
sakila | film | 1458429984 | 130 | 1458429984 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1648724352 | 0 | 0 | 0 | 5 | 62103888 | |
sakila | staff | 1399452912 | 2 | 1399452912 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1493783808 | 0 | 0 | 0 | 5 | 54415152 | |
sakila | store | 869873136 | 3 | 869873136 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1042004304 | 0 | 0 | 0 | 5 | 36165888 | |
what | customers | 733760016 | 49 | 580635264 | 2 | 153124752 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 181912368 | 7 | 58202787984 | |
what | orders | 717273216 | 45 | 438550992 | 3 | 278722224 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 360448 | 343726416 | 12 | 205777896720 | |
sakila | actor | 645961536 | 5 | 645961536 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 733449024 | 0 | 0 | 0 | 5 | 36879216 | |
what | order_statuses | 385575168 | 38 | 325431744 | 3 | 60143424 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 245760 | 282365952 | 8 | 63973772016 | |
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 |
|