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 | 3540 | 4.31 s | 0 ps | 1.22 ms | 251.12 ms | 1600 | 29.88 MiB | 19.12 KiB | 1372 | 50.77 MiB | 37.89 KiB | 80.64 MiB | |
sql/ERRMSG | 40 | 33.66 ms | 2.89 us | 841.47 us | 4.83 ms | 24 | 2.34 MiB | 99.98 KiB | 0 | 0 bytes | 0 bytes | 2.34 MiB | |
innodb/innodb_temp_file | 133 | 572.04 ms | 0 ps | 4.30 ms | 33.41 ms | 0 | 0 bytes | 0 bytes | 65 | 2.14 MiB | 33.72 KiB | 2.14 MiB | |
innodb/innodb_log_file | 1335 | 8.40 s | 243.94 ns | 6.29 ms | 196.67 ms | 8 | 69.00 KiB | 8.62 KiB | 794 | 740.50 KiB | 955 bytes | 809.50 KiB | |
mysys/charset | 3 | 266.83 us | 2.23 us | 88.94 us | 251.67 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 669 | 358.22 ms | 0 ps | 535.45 us | 27.25 ms | 158 | 1.77 KiB | 11 bytes | 21 | 7.38 KiB | 360 bytes | 9.15 KiB | |
myisam/dfile | 76 | 2.98 ms | 209.09 ns | 39.27 us | 2.27 ms | 51 | 3.53 KiB | 71 bytes | 0 | 0 bytes | 0 bytes | 3.53 KiB | |
myisam/kfile | 16 | 4.81 ms | 505.82 ns | 300.81 us | 2.51 ms | 8 | 1.66 KiB | 213 bytes | 0 | 0 bytes | 0 bytes | 1.66 KiB | |
sql/binlog_index | 38 | 64.80 ms | 0 ps | 1.71 ms | 36.54 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
csv/metadata | 8 | 1.87 ms | 816.29 ns | 233.50 us | 683.33 us | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 70 bytes | |
mysys/cnf | 5 | 570.94 us | 164.21 ns | 114.19 us | 555.78 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 126.24 us | 5.81 us | 42.08 us | 90.48 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 883.43 us | 0 ps | 58.89 us | 822.76 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 4 | 213.47 us | 0 ps | 53.37 us | 185.02 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 11 | 258.88 us | 0 ps | 23.53 us | 67.90 us | 2 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|