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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
w3schools | order_details | 24142717632 | 0 | 0 | 518 | 24142717632 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 131072 | 68230800 | 4 | 43531170144 | |
w3schools | customers | 2979874656 | 0 | 0 | 91 | 2979874656 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 200457312 | 7 | 80110395552 | |
sys | sys_config | 2286397872 | 5 | 2286397872 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1087611360 | 0 | 0 | 0 | 5 | 283221840 | |
w3schools | orders | 2083630032 | 0 | 0 | 196 | 2083630032 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 131072 | 85996944 | 4 | 33746490096 | |
w3schools | products | 1965538080 | 0 | 0 | 77 | 1965538080 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 131072 | 4586436096 | 4 | 33160387920 | |
eshops | cart | 491335680 | 66 | 491335680 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 160190976 | 6 | 68540005776 | |
w3schools | categories | 439792848 | 0 | 0 | 8 | 439792848 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 172210368 | 6 | 60891324384 | |
w3schools | employees | 385365024 | 0 | 0 | 10 | 385365024 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 131072 | 3290218272 | 4 | 35136144912 | |
eshops | orders | 271721472 | 30 | 271721472 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 152776800 | 6 | 57596910096 | |
w3schools | shippers | 53372880 | 0 | 0 | 3 | 53372880 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 131072 | 95597568 | 4 | 41177933808 | |
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 | |
mysql | table_partitions | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | tables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|