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 | 6470233440 | 1105 | 6470233440 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 4236219504 | 0 | 0 | 0 | 5 | 89315424 | |
datamining2 | data_mahasiswa | 2836372176 | 66 | 799568880 | 10 | 2036803296 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 376832 | 443697408 | 16 | 168939091200 | |
sakila | actor | 2148233472 | 1188 | 2148233472 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1462476048 | 0 | 0 | 0 | 5 | 38910432 | |
TlapaleriaMalfoy | Registro | 1088178960 | 2 | 1088178960 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 996502848 | 0 | 0 | 0 | 5 | 47795088 | |
sys | sys_config | 991507440 | 23 | 991507440 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 780226128 | 0 | 0 | 0 | 5 | 57183456 | |
sakila | rental | 907831584 | 26 | 907831584 | 0 | 0 | 0 | 0 | 0 | 0 | 53 | 917504 | 8102781984 | 0 | 0 | 0 | 5 | 53011200 | |
Table_insertion | pilote | 865631712 | 2 | 865631712 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1125843312 | 0 | 0 | 0 | 5 | 43836144 | |
sakila | language | 625519488 | 107 | 625519488 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1699274544 | 0 | 0 | 0 | 5 | 109331904 | |
sakila | city | 564510144 | 26 | 564510144 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 4193332176 | 0 | 0 | 0 | 5 | 105169680 | |
sakila | customer | 525040560 | 75 | 525040560 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 4164955872 | 0 | 0 | 0 | 5 | 95447088 | |
world | City | 490960272 | 2 | 490960272 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 392 | 220070928 | 0 | 0 | 0 | 4 | 21831216 | |
sakila | staff | 483995424 | 77 | 483995424 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1125311616 | 0 | 0 | 0 | 5 | 49217520 | |
sakila | store | 459264432 | 3 | 459264432 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1204084464 | 0 | 0 | 0 | 5 | 38177568 | |
pragyat neupane1 | STD 1 | 226580112 | 14 | 178308768 | 2 | 48271344 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
Nishant | STD 1 | 212648832 | 7 | 156976512 | 2 | 55672320 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
PRUEBA | STD 1 | 198446688 | 10 | 159472896 | 2 | 38973792 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | payment | 190875696 | 54 | 190875696 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 868352 | 10686553680 | 0 | 0 | 0 | 5 | 104139552 | |
sakila | country | 185458416 | 51 | 185458416 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1857286992 | 0 | 0 | 0 | 5 | 93027264 | |
sakila | category | 45667248 | 17 | 45667248 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1177294800 | 0 | 0 | 0 | 5 | 98488896 | |
sakila | address | 27796032 | 2 | 27796032 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1761761760 | 0 | 0 | 0 | 5 | 42987648 | |
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 |
|