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 | 2339 | 2.28 s | 0 ps | 972.77 us | 210.15 ms | 1329 | 25.64 MiB | 19.76 KiB | 686 | 30.11 MiB | 44.94 KiB | 55.75 MiB | |
sql/io_cache | 110 | 4.25 ms | 0 ps | 38.60 us | 652.26 us | 44 | 2.46 MiB | 57.22 KiB | 46 | 2.46 MiB | 54.74 KiB | 4.92 MiB | |
innodb/innodb_temp_file | 223 | 436.29 ms | 0 ps | 1.96 ms | 35.02 ms | 0 | 0 bytes | 0 bytes | 159 | 3.36 MiB | 21.64 KiB | 3.36 MiB | |
sql/ERRMSG | 20 | 13.89 ms | 3.62 us | 694.59 us | 3.80 ms | 12 | 1.18 MiB | 100.29 KiB | 0 | 0 bytes | 0 bytes | 1.18 MiB | |
innodb/innodb_log_file | 500 | 2.80 s | 239.18 ns | 5.59 ms | 47.42 ms | 8 | 69.00 KiB | 8.62 KiB | 291 | 280.00 KiB | 985 bytes | 349.00 KiB | |
mysys/charset | 3 | 284.30 us | 3.46 us | 94.77 us | 261.80 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 120 | 106.68 ms | 0 ps | 888.99 us | 18.19 ms | 25 | 843 bytes | 34 bytes | 8 | 1.52 KiB | 195 bytes | 2.34 KiB | |
sql/binlog_index | 38 | 60.03 ms | 0 ps | 1.58 ms | 44.07 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
csv/metadata | 8 | 1.45 ms | 409.20 ns | 181.39 us | 931.85 us | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 70 bytes | |
mysys/cnf | 5 | 1.28 ms | 148.37 ns | 255.88 us | 1.26 ms | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 17.88 us | 785.66 ns | 5.96 us | 15.18 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 814.21 us | 0 ps | 54.28 us | 711.28 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 4 | 701.04 us | 0 ps | 175.26 us | 475.19 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 9 | 352.20 us | 0 ps | 39.13 us | 301.10 us | 2 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|