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 | 4655 | 7.20 s | 0 ps | 1.55 ms | 173.57 ms | 1454 | 27.88 MiB | 19.63 KiB | 2302 | 80.55 MiB | 35.83 KiB | 108.42 MiB | |
sql/io_cache | 426 | 21.20 ms | 0 ps | 49.77 us | 5.90 ms | 192 | 9.73 MiB | 51.90 KiB | 174 | 9.73 MiB | 57.27 KiB | 19.46 MiB | |
innodb/innodb_temp_file | 530 | 808.96 ms | 0 ps | 1.53 ms | 27.81 ms | 0 | 0 bytes | 0 bytes | 439 | 9.42 MiB | 21.98 KiB | 9.42 MiB | |
sql/ERRMSG | 70 | 40.24 ms | 2.09 us | 574.85 us | 4.63 ms | 42 | 4.10 MiB | 100.06 KiB | 0 | 0 bytes | 0 bytes | 4.10 MiB | |
innodb/innodb_log_file | 2839 | 14.31 s | 234.96 ns | 5.04 ms | 54.72 ms | 8 | 69.00 KiB | 8.62 KiB | 1790 | 2.32 MiB | 1.32 KiB | 2.38 MiB | |
sql/binlog | 927 | 3.70 s | 0 ps | 4.00 ms | 36.95 ms | 96 | 21.61 KiB | 230 bytes | 271 | 87.13 KiB | 329 bytes | 108.74 KiB | |
mysys/charset | 3 | 193.44 us | 2.42 us | 64.48 us | 176.90 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog_index | 23 | 833.39 us | 0 ps | 36.23 us | 314.75 us | 5 | 160 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 160 bytes | |
mysys/cnf | 5 | 1.38 ms | 362.21 ns | 275.17 us | 1.34 ms | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
csv/metadata | 4 | 349.42 us | 1.05 us | 87.36 us | 234.41 us | 1 | 35 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 35 bytes | |
sql/pid | 3 | 35.58 us | 1.23 us | 11.86 us | 30.47 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 828.85 us | 0 ps | 55.26 us | 752.77 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 12 | 149.14 us | 0 ps | 12.43 us | 30.28 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 15 | 1.60 ms | 0 ps | 106.81 us | 1.54 ms | 6 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|