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 | 1663 | 828.88 ms | 0 ps | 498.42 us | 218.02 ms | 1258 | 24.53 MiB | 19.97 KiB | 218 | 16.23 MiB | 76.26 KiB | 40.77 MiB | |
sql/ERRMSG | 25 | 10.32 ms | 2.51 us | 412.66 us | 2.54 ms | 15 | 1.47 MiB | 100.42 KiB | 0 | 0 bytes | 0 bytes | 1.47 MiB | |
innodb/innodb_temp_file | 103 | 424.14 ms | 0 ps | 4.12 ms | 25.41 ms | 0 | 0 bytes | 0 bytes | 40 | 1.44 MiB | 36.80 KiB | 1.44 MiB | |
innodb/innodb_log_file | 225 | 1.44 s | 237.60 ns | 6.40 ms | 212.82 ms | 8 | 69.00 KiB | 8.62 KiB | 129 | 123.00 KiB | 976 bytes | 192.00 KiB | |
mysys/charset | 3 | 228.56 us | 2.23 us | 76.19 us | 214.94 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 57 | 37.43 ms | 0 ps | 656.60 us | 17.51 ms | 11 | 640 bytes | 58 bytes | 3 | 156 bytes | 52 bytes | 796 bytes | |
sql/binlog_index | 38 | 60.57 ms | 0 ps | 1.59 ms | 40.85 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
csv/metadata | 8 | 13.82 ms | 1.88 us | 1.73 ms | 12.21 ms | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 70 bytes | |
mysys/cnf | 5 | 1.26 ms | 273.50 ns | 252.04 us | 1.24 ms | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 58.53 us | 3.43 us | 19.51 us | 37.68 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 1.06 ms | 0 ps | 70.35 us | 979.29 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 1 | 9.64 us | 0 ps | 9.64 us | 9.64 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 4 | 759.32 us | 0 ps | 189.83 us | 654.17 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|