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 | 3202 | 3.46 s | 0 ps | 1.08 ms | 241.96 ms | 1548 | 29.06 MiB | 19.22 KiB | 1125 | 43.17 MiB | 39.30 KiB | 72.23 MiB | |
sql/io_cache | 166 | 11.79 ms | 0 ps | 71.05 us | 7.08 ms | 66 | 3.89 MiB | 60.29 KiB | 70 | 3.89 MiB | 56.84 KiB | 7.77 MiB | |
innodb/innodb_temp_file | 225 | 1.25 s | 0 ps | 5.58 ms | 224.28 ms | 0 | 0 bytes | 0 bytes | 132 | 4.75 MiB | 36.85 KiB | 4.75 MiB | |
sql/ERRMSG | 55 | 33.38 ms | 2.70 us | 606.97 us | 4.53 ms | 33 | 3.22 MiB | 100.02 KiB | 0 | 0 bytes | 0 bytes | 3.22 MiB | |
innodb/innodb_log_file | 919 | 5.30 s | 230.74 ns | 5.77 ms | 106.23 ms | 8 | 69.00 KiB | 8.62 KiB | 542 | 508.00 KiB | 960 bytes | 577.00 KiB | |
myisam/dfile | 8310 | 4.64 ms | 84.48 ns | 558.10 ns | 379.88 us | 7302 | 481.34 KiB | 68 bytes | 0 | 0 bytes | 0 bytes | 481.34 KiB | |
mysys/charset | 3 | 313.78 us | 2.57 us | 104.59 us | 299.23 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 1715 | 507.79 ms | 0 ps | 296.09 us | 23.08 ms | 411 | 2.19 KiB | 5 bytes | 32 | 7.24 KiB | 232 bytes | 9.43 KiB | |
myisam/kfile | 16 | 1.38 ms | 520.08 ns | 86.16 us | 384.27 us | 8 | 1.66 KiB | 213 bytes | 0 | 0 bytes | 0 bytes | 1.66 KiB | |
sql/binlog_index | 38 | 44.97 ms | 0 ps | 1.18 ms | 25.74 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
mysys/cnf | 5 | 799.26 us | 205.39 ns | 159.85 us | 779.89 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
csv/metadata | 4 | 197.42 us | 732.34 ns | 49.36 us | 145.05 us | 1 | 35 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 35 bytes | |
sql/pid | 3 | 57.33 us | 3.20 us | 19.11 us | 37.48 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 805.40 us | 0 ps | 53.69 us | 740.60 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 4 | 162.94 us | 0 ps | 40.73 us | 91.43 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 2 | 890.78 us | 0 ps | 445.39 us | 884.60 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|