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 | 3248 | 3.19 s | 0 ps | 983.24 us | 219.93 ms | 1355 | 26.05 MiB | 19.68 KiB | 1327 | 49.45 MiB | 38.16 KiB | 75.50 MiB | |
sql/io_cache | 125 | 4.99 ms | 0 ps | 39.89 us | 1.74 ms | 48 | 2.83 MiB | 60.35 KiB | 52 | 2.83 MiB | 55.71 KiB | 5.66 MiB | |
sql/ERRMSG | 45 | 38.42 ms | 2.84 us | 853.88 us | 6.04 ms | 27 | 2.64 MiB | 100.29 KiB | 0 | 0 bytes | 0 bytes | 2.64 MiB | |
innodb/innodb_log_file | 1886 | 8.42 s | 234.96 ns | 4.46 ms | 85.04 ms | 8 | 69.00 KiB | 8.62 KiB | 1284 | 2.21 MiB | 1.76 KiB | 2.28 MiB | |
innodb/innodb_temp_file | 105 | 436.77 ms | 0 ps | 4.16 ms | 28.84 ms | 0 | 0 bytes | 0 bytes | 40 | 1.56 MiB | 40.00 KiB | 1.56 MiB | |
mysys/charset | 3 | 245.75 us | 1.51 us | 81.92 us | 233.04 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 445 | 520.54 ms | 0 ps | 1.17 ms | 37.96 ms | 92 | 964 bytes | 10 bytes | 35 | 6.55 KiB | 192 bytes | 7.49 KiB | |
myisam/kfile | 24 | 5.18 ms | 0 ps | 215.83 us | 1.63 ms | 8 | 1.66 KiB | 213 bytes | 0 | 0 bytes | 0 bytes | 1.66 KiB | |
sql/binlog_index | 38 | 59.48 ms | 0 ps | 1.57 ms | 42.07 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
csv/metadata | 8 | 1.72 ms | 696.96 ns | 215.17 us | 598.32 us | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 70 bytes | |
mysys/cnf | 5 | 1.90 ms | 143.62 ns | 380.20 us | 1.88 ms | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 13.20 us | 661.58 ns | 4.40 us | 10.65 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 905.74 us | 0 ps | 60.38 us | 808.28 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 1 | 3.17 us | 0 ps | 3.17 us | 3.17 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 8 | 80.23 us | 0 ps | 10.03 us | 39.83 us | 2 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
myisam/dfile | 16 | 376.19 us | 0 ps | 23.51 us | 204.65 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|