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 | 2228 | 1.51 s | 0 ps | 679.08 us | 193.45 ms | 1381 | 28.28 MiB | 20.97 KiB | 421 | 22.02 MiB | 53.55 KiB | 50.30 MiB | |
sql/io_cache | 819 | 125.13 ms | 0 ps | 152.79 us | 24.16 ms | 340 | 19.24 MiB | 57.93 KiB | 349 | 19.24 MiB | 56.44 KiB | 38.47 MiB | |
innodb/innodb_temp_file | 867 | 774.19 ms | 0 ps | 892.96 us | 25.78 ms | 0 | 0 bytes | 0 bytes | 784 | 14.31 MiB | 18.69 KiB | 14.31 MiB | |
sql/ERRMSG | 60 | 44.61 ms | 2.54 us | 743.52 us | 7.20 ms | 36 | 3.52 MiB | 99.99 KiB | 0 | 0 bytes | 0 bytes | 3.52 MiB | |
innodb/innodb_log_file | 405 | 2.10 s | 234.43 ns | 5.19 ms | 46.66 ms | 8 | 69.00 KiB | 8.62 KiB | 232 | 223.00 KiB | 984 bytes | 292.00 KiB | |
sql/binlog | 285 | 132.73 ms | 0 ps | 465.73 us | 16.07 ms | 74 | 99.89 KiB | 1.35 KiB | 9 | 1.93 KiB | 220 bytes | 101.82 KiB | |
mysys/charset | 3 | 560.75 us | 8.12 us | 186.92 us | 515.86 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog_index | 23 | 1.30 ms | 0 ps | 56.37 us | 410.58 us | 5 | 160 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 160 bytes | |
mysys/cnf | 5 | 196.94 us | 380.69 ns | 39.39 us | 177.57 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
csv/metadata | 4 | 10.89 ms | 1.16 us | 2.72 ms | 10.66 ms | 1 | 35 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 35 bytes | |
sql/pid | 3 | 16.45 us | 826.85 ns | 5.48 us | 13.44 us | 0 | 0 bytes | 0 bytes | 1 | 5 bytes | 5 bytes | 5 bytes | |
sql/casetest | 15 | 967.70 us | 0 ps | 64.51 us | 864.35 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 4 | 61.65 us | 0 ps | 15.41 us | 32.36 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 6 | 430.51 us | 0 ps | 71.75 us | 400.17 us | 2 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|