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 | 3056 | 5.13 s | 0 ps | 1.68 ms | 507.94 ms | 1502 | 28.34 MiB | 19.32 KiB | 1012 | 39.05 MiB | 39.51 KiB | 67.39 MiB | |
sql/io_cache | 622 | 431.61 ms | 0 ps | 693.91 us | 402.96 ms | 270 | 13.79 MiB | 52.32 KiB | 252 | 13.79 MiB | 56.05 KiB | 27.59 MiB | |
innodb/innodb_temp_file | 299 | 2.34 s | 0 ps | 7.84 ms | 1.15 s | 0 | 0 bytes | 0 bytes | 209 | 5.77 MiB | 28.25 KiB | 5.77 MiB | |
sql/ERRMSG | 55 | 39.71 ms | 2.67 us | 721.96 us | 6.87 ms | 33 | 3.22 MiB | 99.93 KiB | 0 | 0 bytes | 0 bytes | 3.22 MiB | |
innodb/innodb_log_file | 969 | 5.67 s | 227.04 ns | 5.85 ms | 40.38 ms | 8 | 69.00 KiB | 8.62 KiB | 565 | 502.00 KiB | 910 bytes | 571.00 KiB | |
mysys/charset | 3 | 353.02 us | 2.13 us | 117.67 us | 340.02 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 239 | 209.60 ms | 0 ps | 877.00 us | 28.00 ms | 52 | 804 bytes | 15 bytes | 12 | 3.15 KiB | 269 bytes | 3.94 KiB | |
myisam/kfile | 8 | 860.31 us | 683.76 ns | 107.54 us | 506.92 us | 4 | 834 bytes | 208 bytes | 0 | 0 bytes | 0 bytes | 834 bytes | |
sql/binlog_index | 38 | 63.91 ms | 0 ps | 1.68 ms | 37.17 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
myisam/dfile | 8 | 1.31 ms | 231.79 ns | 163.68 us | 1.24 ms | 1 | 67 bytes | 67 bytes | 0 | 0 bytes | 0 bytes | 67 bytes | |
mysys/cnf | 5 | 652.76 us | 137.81 ns | 130.55 us | 636.74 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
csv/metadata | 4 | 395.64 us | 697.49 ns | 98.91 us | 288.49 us | 1 | 35 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 35 bytes | |
sql/pid | 3 | 66.51 us | 3.58 us | 22.17 us | 38.93 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 799.45 us | 0 ps | 53.30 us | 740.28 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 3 | 53.48 us | 0 ps | 17.83 us | 29.40 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 2 | 698.31 us | 0 ps | 349.15 us | 686.91 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|