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 | 3685 | 5.72 s | 0 ps | 1.55 ms | 239.90 ms | 1610 | 30.03 MiB | 19.10 KiB | 1385 | 49.61 MiB | 36.68 KiB | 79.64 MiB | |
sql/io_cache | 99 | 4.12 ms | 0 ps | 41.64 us | 1.19 ms | 32 | 2.13 MiB | 68.20 KiB | 42 | 2.12 MiB | 51.66 KiB | 4.25 MiB | |
sql/ERRMSG | 65 | 56.42 ms | 2.84 us | 868.04 us | 7.39 ms | 39 | 3.81 MiB | 99.96 KiB | 0 | 0 bytes | 0 bytes | 3.81 MiB | |
innodb/innodb_temp_file | 220 | 654.01 ms | 0 ps | 2.97 ms | 44.22 ms | 0 | 0 bytes | 0 bytes | 146 | 3.78 MiB | 26.52 KiB | 3.78 MiB | |
innodb/innodb_log_file | 1307 | 7.71 s | 232.85 ns | 5.90 ms | 120.66 ms | 8 | 69.00 KiB | 8.62 KiB | 746 | 525.00 KiB | 721 bytes | 594.00 KiB | |
mysys/charset | 3 | 223.40 us | 2.37 us | 74.47 us | 209.23 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 343 | 57.24 ms | 0 ps | 166.89 us | 18.67 ms | 82 | 924 bytes | 11 bytes | 4 | 377 bytes | 94 bytes | 1.27 KiB | |
myisam/kfile | 12 | 1.55 ms | 447.74 ns | 128.88 us | 750.61 us | 6 | 1.27 KiB | 216 bytes | 0 | 0 bytes | 0 bytes | 1.27 KiB | |
myisam/dfile | 27 | 2.33 ms | 1.09 us | 86.37 us | 1.87 ms | 3 | 384 bytes | 128 bytes | 0 | 0 bytes | 0 bytes | 384 bytes | |
sql/binlog_index | 38 | 67.24 ms | 0 ps | 1.77 ms | 46.23 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
csv/metadata | 8 | 2.44 ms | 946.70 ns | 304.49 us | 1.16 ms | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 70 bytes | |
mysys/cnf | 5 | 1.68 ms | 190.08 ns | 336.03 us | 1.66 ms | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 28.88 us | 1.65 us | 9.63 us | 22.86 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 726.87 us | 0 ps | 48.46 us | 665.94 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 1 | 14.04 us | 0 ps | 14.04 us | 14.04 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 41 | 295.38 us | 0 ps | 7.20 us | 39.07 us | 16 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|