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 | rental | 616952978928 | 52 | 616952978928 | 0 | 0 | 0 | 0 | 0 | 0 | 53 | 917504 | 621594544560 | 0 | 0 | 0 | 5 | 38657520 | |
sakila | city | 3160874640 | 105 | 3160874640 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 2494344336 | 0 | 0 | 0 | 5 | 480634704 | |
sakila | customer | 2815079520 | 50 | 2815079520 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 2548953264 | 0 | 0 | 0 | 5 | 51282528 | |
sakila | actor | 2024145024 | 2 | 2024145024 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2936081808 | 0 | 0 | 0 | 5 | 54953712 | |
sakila | film | 1693140240 | 154 | 1693140240 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1574036112 | 0 | 0 | 0 | 5 | 33612480 | |
sakila | language | 1480469760 | 113 | 1480469760 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 810653184 | 0 | 0 | 0 | 5 | 49406544 | |
sakila | staff | 1209719808 | 50 | 1209719808 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1045799568 | 0 | 0 | 0 | 5 | 33987888 | |
sakila | inventory | 1188557040 | 52 | 1188557040 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1842122304 | 0 | 0 | 0 | 5 | 41067840 | |
sakila | country | 1169794560 | 250 | 1169794560 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 831899904 | 0 | 0 | 0 | 5 | 46385328 | |
login. | login. | 1168537392 | 20 | 1119742800 | 1 | 48794592 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | address | 189716208 | 52 | 189716208 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3038168496 | 0 | 0 | 0 | 5 | 35679600 | |
SMS | admin | 146060640 | 10 | 146060640 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 138705072 | 6 | 48982998768 | |
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 | |
mysql | table_partition_values | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|