SELECT * FROM `io_global_by_wait_by_bytes`
|
event_name | total | total_latency | min_latency | avg_latency | max_latency | count_read | total_read | avg_read | count_write | total_written | avg_written | total_requested | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
innodb/innodb_data_file | 2693 | 4.08 s | 0 ps | 1.51 ms | 455.78 ms | 1453 | 27.58 MiB | 19.44 KiB | 808 | 33.52 MiB | 42.48 KiB | 61.09 MiB | |
sql/io_cache | 72 | 5.55 ms | 0 ps | 77.06 us | 4.34 ms | 32 | 1.72 MiB | 55.12 KiB | 30 | 1.72 MiB | 58.80 KiB | 3.45 MiB | |
sql/ERRMSG | 55 | 70.25 ms | 2.60 us | 1.28 ms | 18.36 ms | 33 | 3.22 MiB | 100.03 KiB | 0 | 0 bytes | 0 bytes | 3.22 MiB | |
innodb/innodb_temp_file | 142 | 525.02 ms | 0 ps | 3.70 ms | 31.79 ms | 0 | 0 bytes | 0 bytes | 71 | 2.42 MiB | 34.93 KiB | 2.42 MiB | |
innodb/innodb_log_file | 562 | 3.16 s | 226.51 ns | 5.62 ms | 87.94 ms | 8 | 69.00 KiB | 8.62 KiB | 339 | 487.00 KiB | 1.44 KiB | 556.00 KiB | |
mysys/charset | 3 | 248.20 us | 3.21 us | 82.73 us | 228.24 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 235 | 153.82 ms | 0 ps | 654.55 us | 24.99 ms | 52 | 804 bytes | 15 bytes | 10 | 2.25 KiB | 231 bytes | 3.04 KiB | |
myisam/kfile | 4 | 4.00 ms | 1.92 us | 999.03 us | 3.94 ms | 2 | 442 bytes | 221 bytes | 0 | 0 bytes | 0 bytes | 442 bytes | |
sql/binlog_index | 38 | 40.99 ms | 0 ps | 1.08 ms | 25.52 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
mysys/cnf | 5 | 1.58 ms | 164.21 ns | 316.63 us | 1.56 ms | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 22.73 us | 742.37 ns | 7.58 us | 19.85 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 901.01 us | 0 ps | 60.07 us | 814.44 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 2 | 200.51 us | 0 ps | 100.26 us | 195.35 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
myisam/dfile | 2 | 29.73 us | 1.75 us | 14.86 us | 27.98 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|