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 | inventory | 5157474432 | 52 | 5157474432 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 4175313120 | 0 | 0 | 0 | 5 | 2073963936 | |
sakila | customer | 4741445808 | 106 | 4741445808 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 5041717824 | 0 | 0 | 0 | 5 | 50071296 | |
sakila | country | 3966129552 | 26 | 3966129552 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4046154288 | 0 | 0 | 0 | 5 | 46886400 | |
sakila | film | 2733004032 | 305 | 2733004032 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 3849381888 | 0 | 0 | 0 | 5 | 57806496 | |
sakila | film_actor | 2383784832 | 3 | 2383784832 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 7884307728 | 0 | 0 | 0 | 5 | 25815504 | |
sakila | city | 2070277440 | 27 | 2070277440 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1864684272 | 0 | 0 | 0 | 5 | 74238912 | |
sakila | address | 1942924368 | 132 | 1942924368 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1452248688 | 0 | 0 | 0 | 5 | 38567760 | |
sakila | language | 1434262896 | 98 | 1434262896 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1106431392 | 0 | 0 | 0 | 5 | 68712864 | |
sakila | staff | 1265079552 | 6 | 1265079552 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1254896544 | 0 | 0 | 0 | 5 | 58052016 | |
sys | sys_config | 1234157760 | 10 | 1234157760 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 630663264 | 0 | 0 | 0 | 5 | 744142608 | |
sakila | store | 1123703328 | 9 | 1123703328 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1061919936 | 0 | 0 | 0 | 5 | 94901664 | |
vedettfak | megye | 855234336 | 3 | 855234336 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 848904672 | 0 | 0 | 0 | 5 | 232847472 | |
sakila | actor | 741466704 | 358 | 741466704 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1367949792 | 0 | 0 | 0 | 5 | 40531920 | |
vedettfak | fa | 66453024 | 3 | 66453024 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 245760 | 1647535824 | 0 | 0 | 0 | 5 | 607896960 | |
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 |
|