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 | 211805976624 | 308240 | 211805976624 | 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 | 27016005984 | 194 | 27016005984 | 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 | 9054781824 | 53 | 9054781824 | 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 | 961668048 | 8 | 961668048 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 571994016 | 0 | 0 | 0 | 5 | 47132448 | |
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 | |
INFS1200_RELEASE | Policy | 412232832 | 26 | 412232832 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 701321280 | 0 | 0 | 0 | 5 | 30584928 | |
INFS1200_RELEASE | Customer | 220612128 | 25 | 220612128 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 543635664 | 0 | 0 | 0 | 5 | 267915120 | |
Rental_Mobil | Tb_pelanggan | 129397488 | 0 | 0 | 2 | 129397488 | 0 | 0 | 0 | 0 | 5 | 131072 | 607557456 | 1 | 16384 | 20208672 | 6 | 6781127232 | |
indexing_lab | products | 16502112 | 1 | 16502112 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 976488480 | 6 | 98304 | 84203328 | 7 | 35572285056 | |
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 |
|