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 | 173736242592 | 165000 | 173736242592 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 2801695248 | 0 | 0 | 0 | 5 | 45366288 | |
sakila | film | 92502551856 | 154114 | 92502551856 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1961146704 | 0 | 0 | 0 | 5 | 43261680 | |
sakila | film_actor | 38971325712 | 165204 | 38971325712 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 3361970832 | 0 | 0 | 0 | 5 | 1984144800 | |
sakila | customer | 14029436784 | 82 | 14029436784 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 15824977344 | 0 | 0 | 0 | 5 | 57312816 | |
sakila | city | 5571498240 | 334 | 5571498240 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 5383731408 | 0 | 0 | 0 | 5 | 53681760 | |
sakila | category | 4012588800 | 5141 | 4012588800 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 966797040 | 0 | 0 | 0 | 5 | 42950160 | |
sakila | address | 3525539424 | 81 | 3525539424 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 2991013344 | 0 | 0 | 0 | 5 | 40436880 | |
sakila | country | 2630734656 | 134 | 2630734656 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2411618352 | 0 | 0 | 0 | 5 | 57857712 | |
sakila | actor | 2572118736 | 204 | 2572118736 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2583090048 | 0 | 0 | 0 | 5 | 33732864 | |
vedettfak | megye | 2406524208 | 2 | 2406524208 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2360570784 | 0 | 0 | 0 | 5 | 287641728 | |
sakila | staff | 1525555680 | 3 | 1525555680 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1505973216 | 0 | 0 | 0 | 5 | 46852080 | |
sakila | store | 1127524464 | 4 | 1127524464 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 854107056 | 0 | 0 | 0 | 5 | 415976880 | |
sakila | language | 1122973632 | 136 | 1122973632 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 843958368 | 0 | 0 | 0 | 5 | 62500944 | |
sku | Attore | 1062578880 | 10 | 1062578880 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 852224736 | 0 | 0 | 0 | 5 | 47949264 | |
test19 | voiture | 686809200 | 1 | 686809200 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 849039312 | 0 | 0 | 0 | 5 | 36104640 | |
sys | sys_config | 650849232 | 1 | 650849232 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 764508096 | 0 | 0 | 0 | 5 | 59470224 | |
sakila | film_text | 573741168 | 14 | 573741168 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 688 | 940520064 | 0 | 0 | 0 | 13 | 95482464 | |
vedettfak | fa | 96838368 | 2 | 96838368 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 245760 | 1805436864 | 0 | 0 | 0 | 5 | 266437776 | |
test19 | pilote | 41041968 | 3 | 41041968 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4058137776 | 0 | 0 | 0 | 5 | 44432784 | |
Stefano | vulcano | 34999536 | 3 | 34999536 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 804453408 | 0 | 0 | 0 | 5 | 37635312 | |
world | City | 22608432 | 2 | 22608432 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 392 | 257264304 | 0 | 0 | 0 | 5 | 24362448 | |
test19 | ecurie | 18179568 | 1 | 18179568 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2521466640 | 0 | 0 | 0 | 5 | 2087012928 | |
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 |
|