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 | 2185138210992 | 2475012 | 2185138210992 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 866973360 | 0 | 0 | 0 | 5 | 14384304 | |
sakila | film | 1161249655632 | 2311723 | 1161249655632 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1734827952 | 0 | 0 | 0 | 5 | 34186416 | |
sakila | film_actor | 394713104544 | 2478017 | 394713104544 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 1503136800 | 0 | 0 | 0 | 5 | 20352288 | |
sakila | category | 40706956224 | 77031 | 40706956224 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1150891104 | 0 | 0 | 0 | 5 | 51023280 | |
sakila | customer | 7612900416 | 15 | 7612900416 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 7541420832 | 0 | 0 | 0 | 5 | 51456240 | |
sakila | staff | 6210031344 | 17 | 6210031344 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 3447343152 | 0 | 0 | 0 | 5 | 2455870560 | |
sakila | rental | 5004444192 | 5 | 5004444192 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 5049803616 | 0 | 0 | 0 | 5 | 46774992 | |
vedettfak | fa | 4281864048 | 2 | 4281864048 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2812495488 | 0 | 0 | 0 | 5 | 1735170096 | |
sakila | actor | 2430960576 | 3452 | 2430960576 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 934311312 | 0 | 0 | 0 | 5 | 47652000 | |
sakila | inventory | 2408885952 | 31 | 2408885952 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 3304088304 | 0 | 0 | 0 | 5 | 33934032 | |
sakila | address | 2114897664 | 59 | 2114897664 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 4007401728 | 0 | 0 | 0 | 5 | 51977376 | |
sakila | country | 2045522688 | 288 | 2045522688 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 756571200 | 0 | 0 | 0 | 5 | 75691440 | |
sakila | language | 1685760912 | 163 | 1685760912 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 749458512 | 0 | 0 | 0 | 5 | 66562848 | |
sakila | city | 1607008656 | 181 | 1607008656 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1155851664 | 0 | 0 | 0 | 5 | 50069184 | |
sakila | payment | 1389263040 | 9 | 1389263040 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1348366272 | 0 | 0 | 0 | 5 | 33909216 | |
vedettfak | megye | 1191836976 | 6 | 1191836976 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1119512592 | 0 | 0 | 0 | 5 | 334630032 | |
Table_insertion | pilote | 1105936656 | 68 | 1105936656 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 971311968 | 0 | 0 | 0 | 5 | 41049888 | |
Stefano | vulcano | 1064585808 | 3 | 1064585808 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 895513344 | 0 | 0 | 0 | 5 | 411995760 | |
Table_insertion | ecurie | 986516256 | 26 | 986516256 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 975428784 | 0 | 0 | 0 | 5 | 40226208 | |
sys | sys_config | 869473440 | 7 | 869473440 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 915468048 | 0 | 0 | 0 | 5 | 67175328 | |
test19 | ecurie | 795039168 | 7 | 795039168 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1190438832 | 0 | 0 | 0 | 5 | 36557664 | |
test19 | voiture | 787908528 | 9 | 787908528 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 889964592 | 0 | 0 | 0 | 5 | 35996928 | |
sakila | store | 754977696 | 2 | 754977696 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 858802560 | 0 | 0 | 0 | 5 | 43135488 | |
test19 | pilote | 737174064 | 7 | 737174064 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 863307984 | 0 | 0 | 0 | 5 | 53529168 | |
world | Country | 395294592 | 5 | 395294592 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 2397307440 | 0 | 0 | 0 | 7 | 42533040 |
|