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 | 6040 | 13.21 s | 0 ps | 2.19 ms | 222.65 ms | 1489 | 28.14 MiB | 19.35 KiB | 2972 | 103.67 MiB | 35.72 KiB | 131.81 MiB | |
innodb/innodb_log_file | 6481 | 32.23 s | 248.69 ns | 4.97 ms | 873.96 ms | 8 | 69.00 KiB | 8.62 KiB | 4278 | 6.84 MiB | 1.64 KiB | 6.91 MiB | |
sql/ERRMSG | 60 | 47.08 ms | 3.24 us | 784.63 us | 3.44 ms | 36 | 3.52 MiB | 99.99 KiB | 0 | 0 bytes | 0 bytes | 3.52 MiB | |
innodb/innodb_temp_file | 99 | 441.51 ms | 0 ps | 4.46 ms | 36.16 ms | 0 | 0 bytes | 0 bytes | 36 | 1.38 MiB | 39.11 KiB | 1.38 MiB | |
sql/binlog | 639 | 2.74 s | 0 ps | 4.29 ms | 47.84 ms | 66 | 860 bytes | 13 bytes | 184 | 87.58 KiB | 487 bytes | 88.42 KiB | |
sql/SDI | 45 | 10.83 ms | 0 ps | 240.63 us | 8.90 ms | 0 | 0 bytes | 0 bytes | 12 | 53.81 KiB | 4.48 KiB | 53.81 KiB | |
mysys/charset | 3 | 311.94 us | 2.49 us | 103.98 us | 295.60 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
myisam/kfile | 142 | 2.60 ms | 0 ps | 18.28 us | 407.96 us | 20 | 3.89 KiB | 199 bytes | 69 | 2.90 KiB | 43 bytes | 6.80 KiB | |
myisam/dfile | 139 | 6.66 ms | 0 ps | 47.94 us | 4.72 ms | 42 | 709 bytes | 17 bytes | 32 | 1.04 KiB | 33 bytes | 1.73 KiB | |
sql/binlog_index | 38 | 45.24 ms | 0 ps | 1.19 ms | 22.67 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
csv/metadata | 8 | 2.15 ms | 1.75 us | 268.79 us | 1.16 ms | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 70 bytes | |
mysys/cnf | 5 | 1.17 ms | 210.14 ns | 233.41 us | 1.15 ms | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 49.88 us | 2.69 us | 16.63 us | 38.85 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 720.65 us | 0 ps | 48.04 us | 652.29 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 13 | 475.38 us | 0 ps | 36.57 us | 305.44 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 4 | 118.82 us | 0 ps | 29.70 us | 47.02 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|