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 | 2360082912 | 11 | 2360082912 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1481391648 | 0 | 0 | 0 | 5 | 37921488 | |
sakila | film_actor | 1887191328 | 2 | 1887191328 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 3696311520 | 0 | 0 | 0 | 5 | 24886224 | |
sakila | address | 1373973216 | 259 | 1373973216 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1648656768 | 0 | 0 | 0 | 5 | 41382528 | |
sakila | store | 1135382688 | 11 | 1135382688 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1246094256 | 0 | 0 | 0 | 5 | 44066352 | |
vedettfak | megye | 808977840 | 22 | 808977840 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 958257696 | 0 | 0 | 0 | 5 | 43453344 | |
sakila | actor | 803461296 | 4 | 803461296 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 992770416 | 0 | 0 | 0 | 5 | 36754080 | |
sakila | category | 793697520 | 20 | 793697520 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 926676960 | 0 | 0 | 0 | 5 | 43750080 | |
sakila | rental | 724351056 | 2 | 724351056 | 0 | 0 | 0 | 0 | 0 | 0 | 53 | 917504 | 49852742016 | 0 | 0 | 0 | 5 | 32616144 | |
sakila | customer | 701749488 | 26 | 701749488 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2122797072 | 0 | 0 | 0 | 5 | 24169728 | |
sys | sys_config | 697511760 | 4 | 697511760 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 752516688 | 0 | 0 | 0 | 5 | 201007488 | |
sakila | city | 411646224 | 177 | 411646224 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1378545168 | 0 | 0 | 0 | 5 | 30798240 | |
sakila | country | 304128528 | 50 | 304128528 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 786103824 | 0 | 0 | 0 | 5 | 30056928 | |
world | CountryLanguage | 66993168 | 4 | 66993168 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 407 | 669284352 | 0 | 0 | 0 | 7 | 55007040 | |
test19 | ecurie | 59369904 | 7 | 59369904 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 204423648 | 6 | 63861264720 | |
test1234 | order_statuses | 51672192 | 0 | 0 | 3 | 51672192 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 152994336 | 7 | 54164824560 | |
test1234 | orders_deprecated | 45701568 | 12 | 45701568 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 4612039344 | 9 | 52573212912 | |
world | Country | 37053984 | 2 | 37053984 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 1556043456 | 0 | 0 | 0 | 4 | 23369808 | |
test1234 | customers | 35267232 | 0 | 0 | 2 | 35267232 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 154320144 | 7 | 66676828416 | |
test1234 | addresses | 30389040 | 0 | 0 | 3 | 30389040 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 117134688 | 7 | 50391205392 | |
test19 | pilote | 19540224 | 2 | 19540224 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 952722672 | 0 | 0 | 0 | 5 | 32482032 | |
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 |
|