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 | 512787419760 | 495000 | 512787419760 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 795417744 | 0 | 0 | 0 | 5 | 24459072 | |
sakila | film | 295426963920 | 462842 | 295426963920 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1284657792 | 0 | 0 | 0 | 5 | 39166512 | |
sakila | film_actor | 113188856880 | 495629 | 113188856880 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 3685528176 | 0 | 0 | 0 | 5 | 31207968 | |
sakila | category | 10729594128 | 15405 | 10729594128 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 682319616 | 0 | 0 | 0 | 5 | 25925328 | |
sakila | actor | 5956607712 | 685 | 5956607712 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 5381774112 | 0 | 0 | 0 | 5 | 60791808 | |
sakila | payment | 5659105584 | 4 | 5659105584 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 5658988368 | 0 | 0 | 0 | 5 | 86103072 | |
sakila | staff | 3580875408 | 11 | 3580875408 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 3295668816 | 0 | 0 | 0 | 5 | 330828960 | |
sakila | language | 3242422656 | 682 | 3242422656 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 829520736 | 0 | 0 | 0 | 5 | 47878512 | |
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 | |
sku | Attore | 1019951328 | 7 | 1019951328 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 812044992 | 0 | 0 | 0 | 5 | 43794960 | |
sakila | film_text | 998692992 | 5 | 998692992 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 565 | 1334318304 | 0 | 0 | 0 | 11 | 40922640 | |
sakila | address | 972672096 | 104 | 972672096 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 1190964192 | 0 | 0 | 0 | 5 | 25602720 | |
sakila | store | 798653328 | 16 | 798653328 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 811335888 | 0 | 0 | 0 | 5 | 40015536 | |
sakila | city | 764198688 | 4 | 764198688 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 896745168 | 0 | 0 | 0 | 5 | 25271136 | |
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 | country | 534097344 | 82 | 534097344 | 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 | 39366096 | 4 | 39366096 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 392 | 661322112 | 0 | 0 | 0 | 6 | 33464112 | |
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 |
|