SELECT * FROM `x$io_global_by_wait_by_latency`
|
event_name | total | total_latency | avg_latency | max_latency | read_latency | write_latency | misc_latency | count_read | total_read | avg_read | count_write | total_written | avg_written | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
innodb/innodb_log_file | 216 | 1258298081040 | 5825453832 | 106230393456 | 1575414720 | 67039478352 | 1189683187968 | 8 | 70656 | 8832.0000 | 123 | 124928 | 1015.6748 | |
innodb/innodb_data_file | 1770 | 1137078640896 | 642417072 | 241956308352 | 195587735376 | 14699510496 | 926791395024 | 1229 | 25247744 | 20543.3230 | 310 | 19808256 | 63897.6000 | |
innodb/innodb_temp_file | 96 | 449908218144 | 4686543840 | 33778240320 | 0 | 3079629696 | 446828588448 | 0 | 0 | 0.0000 | 34 | 1343488 | 39514.3529 | |
sql/binlog | 547 | 57388821600 | 104915448 | 22720399152 | 1427610096 | 274112784 | 55687098720 | 133 | 1128 | 8.4812 | 4 | 367 | 91.7500 | |
sql/binlog_index | 38 | 44971505568 | 1183460520 | 25744174368 | 352093104 | 0 | 44619412464 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 40 | 24942052080 | 623551104 | 4531554720 | 12299255760 | 0 | 12642796320 | 24 | 2443754 | 101823.0833 | 0 | 0 | 0.0000 | |
sql/io_cache | 46 | 1527868848 | 33214368 | 424095936 | 127528368 | 729490608 | 670849872 | 16 | 1134100 | 70881.2500 | 20 | 1134100 | 56705.0000 | |
sql/casetest | 15 | 805404336 | 53693376 | 740598144 | 0 | 0 | 805404336 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 799258416 | 159851472 | 779889264 | 781586256 | 0 | 17672160 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 313783008 | 104594160 | 299232384 | 299232384 | 0 | 14550624 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 57333408 | 19110960 | 37477440 | 0 | 16651536 | 40681872 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 14697408 | 14697408 | 14697408 | 0 | 0 | 14697408 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|