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 | 3462 | 4.35 s | 0 ps | 1.26 ms | 241.44 ms | 1632 | 30.38 MiB | 19.06 KiB | 1244 | 46.17 MiB | 38.01 KiB | 76.55 MiB | |
sql/io_cache | 270 | 5.76 ms | 0 ps | 21.32 us | 431.92 us | 89 | 5.01 MiB | 57.67 KiB | 106 | 4.95 MiB | 47.85 KiB | 9.97 MiB | |
sql/ERRMSG | 75 | 61.54 ms | 3.30 us | 820.54 us | 4.33 ms | 45 | 4.40 MiB | 100.02 KiB | 0 | 0 bytes | 0 bytes | 4.40 MiB | |
innodb/innodb_temp_file | 122 | 941.40 ms | 0 ps | 7.72 ms | 307.73 ms | 0 | 0 bytes | 0 bytes | 54 | 1.97 MiB | 37.33 KiB | 1.97 MiB | |
innodb/innodb_log_file | 1145 | 6.74 s | 228.62 ns | 5.88 ms | 70.56 ms | 8 | 69.00 KiB | 8.62 KiB | 666 | 511.50 KiB | 786 bytes | 580.50 KiB | |
myisam/dfile | 531 | 5.89 ms | 77.62 ns | 11.09 us | 3.84 ms | 403 | 43.83 KiB | 111 bytes | 0 | 0 bytes | 0 bytes | 43.83 KiB | |
mysys/charset | 3 | 261.46 us | 3.27 us | 87.15 us | 241.23 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 722 | 72.80 ms | 0 ps | 100.84 us | 17.73 ms | 177 | 1.42 KiB | 8 bytes | 5 | 935 bytes | 187 bytes | 2.33 KiB | |
myisam/kfile | 16 | 3.91 ms | 828.43 ns | 244.44 us | 1.67 ms | 8 | 1.66 KiB | 213 bytes | 0 | 0 bytes | 0 bytes | 1.66 KiB | |
sql/binlog_index | 38 | 59.03 ms | 0 ps | 1.55 ms | 37.59 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
csv/metadata | 8 | 1.27 ms | 660.53 ns | 158.35 us | 559.57 us | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 70 bytes | |
mysys/cnf | 5 | 2.03 ms | 202.75 ns | 406.26 us | 2.00 ms | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 25.74 us | 1.26 us | 8.58 us | 17.96 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 1.04 ms | 0 ps | 69.55 us | 959.10 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 2 | 19.86 us | 0 ps | 9.93 us | 10.66 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 13 | 665.22 us | 0 ps | 51.17 us | 307.83 us | 3 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|