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 | 312 | 2124872871792 | 6810489840 | 254654888928 | 1440343872 | 237894733296 | 1885537794624 | 8 | 70656 | 8832.0000 | 180 | 165888 | 921.6000 | |
innodb/innodb_data_file | 2146 | 1789018759968 | 833652600 | 227733765600 | 457799815968 | 19745009328 | 1311473934672 | 1369 | 27541504 | 20117.9722 | 502 | 25837568 | 51469.2590 | |
innodb/innodb_temp_file | 162 | 895270299264 | 5526359784 | 45888460992 | 0 | 2411031744 | 892859267520 | 0 | 0 | 0.0000 | 73 | 3751936 | 51396.3836 | |
sql/binlog_index | 38 | 42267139728 | 1112292984 | 26718297936 | 387568896 | 0 | 41879570832 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 1557 | 37607029680 | 24153360 | 15200808480 | 1736640576 | 19463664 | 35850925440 | 386 | 2140 | 5.5440 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 70 | 34146720432 | 487810224 | 2108033664 | 19473642672 | 0 | 14673077760 | 42 | 4294010 | 102238.3333 | 0 | 0 | 0.0000 | |
myisam/kfile | 16 | 2385115392 | 149069712 | 722980368 | 2322004608 | 0 | 63110784 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1361280624 | 272256072 | 1344282720 | 1345450656 | 0 | 15829968 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 830796912 | 55386408 | 756593376 | 0 | 0 | 830796912 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 276514656 | 92171376 | 253398816 | 253398816 | 0 | 23115840 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 8 | 46044240 | 5755464 | 23616912 | 0 | 0 | 46044240 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 12914352 | 4304784 | 10192512 | 0 | 2041776 | 10872576 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 3224496 | 3224496 | 3224496 | 0 | 0 | 3224496 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|