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 | 4661 | 8.18 s | 0 ps | 1.76 ms | 220.94 ms | 1644 | 30.56 MiB | 19.04 KiB | 2103 | 70.95 MiB | 34.55 KiB | 101.52 MiB | |
sql/io_cache | 396 | 15.41 ms | 0 ps | 38.90 us | 4.73 ms | 160 | 8.05 MiB | 51.53 KiB | 156 | 8.01 MiB | 52.58 KiB | 16.06 MiB | |
innodb/innodb_temp_file | 360 | 1.21 s | 0 ps | 3.35 ms | 174.05 ms | 0 | 0 bytes | 0 bytes | 270 | 6.72 MiB | 25.48 KiB | 6.72 MiB | |
sql/ERRMSG | 40 | 35.48 ms | 3.80 us | 887.07 us | 3.98 ms | 24 | 2.35 MiB | 100.38 KiB | 0 | 0 bytes | 0 bytes | 2.35 MiB | |
innodb/innodb_log_file | 1808 | 10.36 s | 225.98 ns | 5.73 ms | 72.72 ms | 8 | 69.00 KiB | 8.62 KiB | 1073 | 964.00 KiB | 920 bytes | 1.01 MiB | |
mysys/charset | 3 | 235.92 us | 3.10 us | 78.64 us | 210.71 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 339 | 180.06 ms | 0 ps | 531.15 us | 25.43 ms | 77 | 904 bytes | 12 bytes | 12 | 2.81 KiB | 240 bytes | 3.70 KiB | |
myisam/dfile | 84 | 7.60 ms | 184.27 ns | 90.43 us | 3.23 ms | 52 | 2.22 KiB | 44 bytes | 0 | 0 bytes | 0 bytes | 2.22 KiB | |
myisam/kfile | 16 | 5.52 ms | 505.30 ns | 345.06 us | 3.27 ms | 8 | 1.66 KiB | 213 bytes | 0 | 0 bytes | 0 bytes | 1.66 KiB | |
sql/binlog_index | 38 | 41.89 ms | 0 ps | 1.10 ms | 24.71 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
csv/metadata | 8 | 3.20 ms | 600.34 ns | 400.25 us | 1.47 ms | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 70 bytes | |
mysys/cnf | 5 | 381.07 us | 193.78 ns | 76.21 us | 360.09 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 14.31 us | 670.56 ns | 4.77 us | 10.68 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 842.19 us | 0 ps | 56.15 us | 770.97 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 2 | 176.39 us | 0 ps | 88.20 us | 170.25 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 83 | 908.47 us | 0 ps | 10.95 us | 464.47 us | 35 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|