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 | 267586910976 | 330026 | 267586910976 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 4516141872 | 0 | 0 | 0 | 5 | 38648016 | |
sakila | film | 144641682240 | 308287 | 144641682240 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1700487360 | 0 | 0 | 0 | 5 | 49595568 | |
sakila | payment | 99324915888 | 32088 | 99324915888 | 0 | 0 | 0 | 0 | 0 | 0 | 65 | 1114112 | 21879761904 | 0 | 0 | 0 | 5 | 50348496 | |
sakila | film_actor | 54977629344 | 330400 | 54977629344 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1754074080 | 0 | 0 | 0 | 5 | 20805312 | |
sakila | rental | 20662426224 | 41250 | 20662426224 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 376832 | 5898819696 | 0 | 0 | 0 | 5 | 53204448 | |
sakila | customer | 19731400656 | 28 | 19731400656 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 5118853344 | 0 | 0 | 0 | 5 | 38857104 | |
sakila | category | 5725214880 | 10295 | 5725214880 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1141176960 | 0 | 0 | 0 | 5 | 71453712 | |
sakila | inventory | 4095435696 | 9166 | 4095435696 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 2819086512 | 0 | 0 | 0 | 5 | 53982720 | |
sakila | city | 3740754864 | 8 | 3740754864 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 3344936496 | 0 | 0 | 0 | 5 | 390809760 | |
sakila | actor | 2838348480 | 402 | 2838348480 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2847280128 | 0 | 0 | 0 | 5 | 41143872 | |
sys | sys_config | 2283705600 | 2 | 2283705600 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2483874096 | 0 | 0 | 0 | 5 | 48572832 | |
sakila | address | 2107580640 | 31 | 2107580640 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 1867614144 | 0 | 0 | 0 | 5 | 58789104 | |
sakila | staff | 1722362928 | 4 | 1722362928 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1126398768 | 0 | 0 | 0 | 5 | 691817280 | |
sakila | language | 1567607712 | 196 | 1567607712 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 841539072 | 0 | 0 | 0 | 5 | 56099472 | |
sakila | country | 732074640 | 32 | 732074640 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 796400880 | 0 | 0 | 0 | 5 | 61082208 | |
sakila | store | 720000864 | 6 | 720000864 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 768338208 | 0 | 0 | 0 | 5 | 63215328 | |
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 |
|