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 | 388370232624 | 330000 | 388370232624 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 666656496 | 0 | 0 | 0 | 5 | 18625200 | |
sakila | film | 211697321616 | 308212 | 211697321616 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 988894896 | 0 | 0 | 0 | 5 | 451847088 | |
sakila | film_actor | 80648486688 | 330400 | 80648486688 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1148999280 | 0 | 0 | 0 | 5 | 375974016 | |
sakila | language | 26848670112 | 169 | 26848670112 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 26166471408 | 0 | 0 | 0 | 5 | 138178128 | |
sakila | category | 9923710368 | 10272 | 9923710368 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1692230496 | 0 | 0 | 0 | 5 | 559188960 | |
INFS1200_RELEASE | Vehicle | 8833634304 | 28 | 8833634304 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1405071360 | 0 | 0 | 0 | 5 | 980875104 | |
INFS1200_RELEASE | VehicleCodeMapping | 3236117280 | 25 | 3236117280 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2729897280 | 0 | 0 | 0 | 5 | 107200368 | |
vedettfak | megye | 1370407104 | 20 | 1370407104 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 469549872 | 0 | 0 | 0 | 5 | 829118928 | |
sakila | inventory | 1337870688 | 26 | 1337870688 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1980121440 | 0 | 0 | 0 | 5 | 44716320 | |
sys | sys_config | 934909008 | 7 | 934909008 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 571994016 | 0 | 0 | 0 | 5 | 47132448 | |
indexing_lab | products | 921477216 | 5 | 921477216 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 433108896 | 0 | 0 | 0 | 5 | 253147488 | |
sakila | address | 902176704 | 2 | 902176704 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 822694752 | 0 | 0 | 0 | 5 | 31754448 | |
sakila | actor | 820061088 | 400 | 820061088 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 369246240 | 0 | 0 | 0 | 5 | 270749424 | |
sakila | city | 784566288 | 26 | 784566288 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 685403136 | 0 | 0 | 0 | 5 | 32286144 | |
sakila | staff | 761072928 | 2 | 761072928 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 682506000 | 0 | 0 | 0 | 5 | 33737616 | |
sakila | country | 751493952 | 51 | 751493952 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 435569904 | 0 | 0 | 0 | 5 | 42116976 | |
sakila | store | 660575520 | 3 | 660575520 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 533166480 | 0 | 0 | 0 | 5 | 42906864 | |
sakila | film_text | 557034720 | 26 | 557034720 | 0 | 0 | 0 | 0 | 0 | 0 | 52 | 3415 | 427667856 | 0 | 0 | 0 | 28 | 31077552 | |
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 | |
mysql | check_constraints | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | column_type_elements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | columns | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|