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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
vedettfak | fa | 4657854432 | 7 | 4657854432 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2750422752 | 0 | 0 | 0 | 5 | 1975339872 | |
sakila | film | 4480115904 | 26 | 4480115904 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 5069273616 | 0 | 0 | 0 | 5 | 44183040 | |
sakila | language | 3197904336 | 25 | 3197904336 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3081305040 | 0 | 0 | 0 | 5 | 74483376 | |
sakila | staff | 2331354960 | 9 | 2331354960 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1481391648 | 0 | 0 | 0 | 5 | 37921488 | |
sakila | address | 1332513072 | 255 | 1332513072 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1648656768 | 0 | 0 | 0 | 5 | 41382528 | |
sakila | store | 1071030576 | 6 | 1071030576 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1246094256 | 0 | 0 | 0 | 5 | 44066352 | |
sakila | actor | 803461296 | 4 | 803461296 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 992770416 | 0 | 0 | 0 | 5 | 36754080 | |
vedettfak | megye | 769316064 | 2 | 769316064 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 958257696 | 0 | 0 | 0 | 5 | 43453344 | |
sakila | category | 760117776 | 18 | 760117776 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 926676960 | 0 | 0 | 0 | 5 | 43750080 | |
sakila | customer | 701749488 | 26 | 701749488 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2122797072 | 0 | 0 | 0 | 5 | 24169728 | |
sys | sys_config | 676834752 | 3 | 676834752 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 752516688 | 0 | 0 | 0 | 5 | 201007488 | |
sakila | city | 341265936 | 51 | 341265936 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1378545168 | 0 | 0 | 0 | 5 | 30798240 | |
test1234 | customers | 231804672 | 0 | 0 | 2 | 231804672 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 196906512 | 7 | 55125138816 | |
sakila | country | 188302224 | 25 | 188302224 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 786103824 | 0 | 0 | 0 | 5 | 30056928 | |
test1234 | addresses | 139783248 | 0 | 0 | 2 | 139783248 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 259210512 | 7 | 62755288464 | |
test19 | ecurie | 59369904 | 7 | 59369904 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 204423648 | 6 | 63861264720 | |
world | CountryLanguage | 49881216 | 2 | 49881216 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 407 | 669284352 | 0 | 0 | 0 | 4 | 41335008 | |
world | Country | 37053984 | 2 | 37053984 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 1556043456 | 0 | 0 | 0 | 4 | 23369808 | |
test1234 | orders_deprecated | 24614832 | 6 | 24614832 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 262144 | 166005840 | 11 | 97096381008 | |
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 |
|