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 | film_category | 172785368976 | 165000 | 172785368976 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 795417744 | 0 | 0 | 0 | 5 | 24459072 | |
sakila | film | 99788475600 | 154402 | 99788475600 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1284657792 | 0 | 0 | 0 | 5 | 39166512 | |
sakila | film_actor | 39170603472 | 165200 | 39170603472 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1525037184 | 0 | 0 | 0 | 5 | 31207968 | |
sakila | payment | 5627142576 | 2 | 5627142576 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 5658988368 | 0 | 0 | 0 | 5 | 86103072 | |
sakila | actor | 5023543008 | 200 | 5023543008 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 5053192848 | 0 | 0 | 0 | 5 | 60791808 | |
sakila | category | 3933775824 | 5135 | 3933775824 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 682319616 | 0 | 0 | 0 | 5 | 25925328 | |
test19 | voiture | 2571291888 | 2 | 2571291888 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 807284016 | 0 | 0 | 0 | 5 | 2044763952 | |
sakila | inventory | 1078916256 | 5 | 1078916256 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1161313824 | 0 | 0 | 0 | 5 | 49621440 | |
sakila | rental | 1045283712 | 4 | 1045283712 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1102491984 | 0 | 0 | 0 | 5 | 58342416 | |
sakila | film_text | 998692992 | 5 | 998692992 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 565 | 1334318304 | 0 | 0 | 0 | 11 | 40922640 | |
sku | Attore | 953960832 | 2 | 953960832 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 812044992 | 0 | 0 | 0 | 5 | 43794960 | |
sakila | language | 897768960 | 25 | 897768960 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 829520736 | 0 | 0 | 0 | 5 | 47878512 | |
sakila | staff | 883284864 | 1 | 883284864 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 702263760 | 0 | 0 | 0 | 5 | 330828960 | |
sakila | city | 756722736 | 1 | 756722736 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 896745168 | 0 | 0 | 0 | 5 | 25271136 | |
sakila | store | 755007792 | 14 | 755007792 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 811335888 | 0 | 0 | 0 | 5 | 40015536 | |
test19 | ecurie | 736241616 | 2 | 736241616 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 925450944 | 0 | 0 | 0 | 5 | 77396880 | |
test19 | pilote | 687212592 | 2 | 687212592 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 871028928 | 0 | 0 | 0 | 5 | 50403936 | |
sakila | address | 590629248 | 1 | 590629248 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 867897888 | 0 | 0 | 0 | 5 | 25602720 | |
sakila | country | 420008688 | 1 | 420008688 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 727399200 | 0 | 0 | 0 | 5 | 24267936 | |
world | Country | 53619456 | 6 | 53619456 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 2277548592 | 0 | 0 | 0 | 8 | 48599760 | |
world | City | 21350736 | 2 | 21350736 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 392 | 661322112 | 0 | 0 | 0 | 5 | 24530880 | |
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 |
|