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 | payment | 69374427936 | 32114 | 69374427936 | 0 | 0 | 0 | 0 | 0 | 0 | 67 | 1146880 | 9675699264 | 0 | 0 | 0 | 5 | 24192432 | |
sakila | rental | 19665064848 | 41250 | 19665064848 | 0 | 0 | 0 | 0 | 0 | 0 | 68 | 1163264 | 9967258752 | 0 | 0 | 0 | 5 | 36778896 | |
sakila | inventory | 5936882688 | 9218 | 5936882688 | 0 | 0 | 0 | 0 | 0 | 0 | 23 | 425984 | 6316772880 | 0 | 0 | 0 | 5 | 24745248 | |
vedettfak | fa | 5635218864 | 98 | 5635218864 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 245760 | 7537157232 | 0 | 0 | 0 | 5 | 50106144 | |
vedettfak | megye | 5294323584 | 280 | 5294323584 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1015680336 | 0 | 0 | 0 | 5 | 1852932576 | |
sakila | address | 2444502192 | 34 | 2444502192 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3766521264 | 0 | 0 | 0 | 5 | 37313232 | |
sakila | film | 2283809616 | 76 | 2283809616 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 3558412704 | 0 | 0 | 0 | 5 | 37121568 | |
sakila | country | 1333156176 | 132 | 1333156176 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 908456736 | 0 | 0 | 0 | 5 | 226846224 | |
sakila | actor | 1248247440 | 538 | 1248247440 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 809909760 | 0 | 0 | 0 | 5 | 57161808 | |
sakila | city | 1201489344 | 256 | 1201489344 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1255493712 | 0 | 0 | 0 | 5 | 39141168 | |
sakila | customer | 895112064 | 51 | 895112064 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2079464640 | 0 | 0 | 0 | 5 | 34337424 | |
sys | sys_config | 672698400 | 2 | 672698400 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 850673472 | 0 | 0 | 0 | 5 | 64746000 | |
sakila | staff | 216018000 | 29 | 216018000 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 768158688 | 0 | 0 | 0 | 5 | 31990992 | |
sakila | language | 208197264 | 25 | 208197264 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 734832384 | 0 | 0 | 0 | 5 | 34014288 | |
sakila | store | 22533984 | 6 | 22533984 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1018674096 | 0 | 0 | 0 | 5 | 22029216 | |
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 |
|