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 | 1704 | 576.37 ms | 0 ps | 338.25 us | 166.26 ms | 1251 | 24.80 MiB | 20.30 KiB | 237 | 16.77 MiB | 72.44 KiB | 41.56 MiB | |
innodb/innodb_temp_file | 224 | 375.14 ms | 0 ps | 1.67 ms | 20.50 ms | 0 | 0 bytes | 0 bytes | 160 | 3.38 MiB | 21.60 KiB | 3.38 MiB | |
sql/io_cache | 52 | 6.84 ms | 0 ps | 131.57 us | 4.22 ms | 18 | 1.25 MiB | 71.37 KiB | 24 | 1.25 MiB | 53.53 KiB | 2.51 MiB | |
sql/ERRMSG | 25 | 10.29 ms | 3.57 us | 411.40 us | 3.01 ms | 15 | 1.45 MiB | 99.25 KiB | 0 | 0 bytes | 0 bytes | 1.45 MiB | |
innodb/innodb_log_file | 172 | 871.81 ms | 245.52 ns | 5.07 ms | 37.62 ms | 8 | 69.00 KiB | 8.62 KiB | 94 | 98.00 KiB | 1.04 KiB | 167.00 KiB | |
sql/binlog | 91 | 31.51 ms | 0 ps | 346.21 us | 15.05 ms | 24 | 40.26 KiB | 1.68 KiB | 3 | 156 bytes | 52 bytes | 40.41 KiB | |
mysys/charset | 3 | 256.58 us | 3.51 us | 85.53 us | 221.15 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog_index | 23 | 2.59 ms | 0 ps | 112.64 us | 1.50 ms | 5 | 160 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 160 bytes | |
mysys/cnf | 5 | 293.97 us | 310.46 ns | 58.79 us | 265.77 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 19.89 us | 995.28 ns | 6.63 us | 16.14 us | 0 | 0 bytes | 0 bytes | 1 | 5 bytes | 5 bytes | 5 bytes | |
sql/casetest | 15 | 1.38 ms | 0 ps | 92.20 us | 1.25 ms | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 1 | 6.21 us | 0 ps | 6.21 us | 6.21 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|