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 | 1554 | 774.79 ms | 0 ps | 498.58 us | 67.32 ms | 1196 | 20.98 MiB | 17.97 KiB | 264 | 17.55 MiB | 68.06 KiB | 38.53 MiB | |
sql/io_cache | 46 | 959.77 us | 0 ps | 20.86 us | 88.48 us | 16 | 1.10 MiB | 70.23 KiB | 20 | 1.10 MiB | 56.18 KiB | 2.19 MiB | |
sql/ERRMSG | 35 | 18.70 ms | 2.79 us | 534.24 us | 1.95 ms | 21 | 2.05 MiB | 99.80 KiB | 0 | 0 bytes | 0 bytes | 2.05 MiB | |
innodb/innodb_temp_file | 105 | 377.00 ms | 0 ps | 3.59 ms | 31.15 ms | 0 | 0 bytes | 0 bytes | 41 | 1.52 MiB | 37.85 KiB | 1.52 MiB | |
innodb/innodb_log_file | 157 | 811.24 ms | 224.40 ns | 5.17 ms | 36.33 ms | 8 | 69.00 KiB | 8.62 KiB | 84 | 116.00 KiB | 1.38 KiB | 185.00 KiB | |
sql/binlog | 348 | 85.45 ms | 0 ps | 245.55 us | 24.35 ms | 89 | 65.96 KiB | 759 bytes | 6 | 963 bytes | 160 bytes | 66.90 KiB | |
mysys/charset | 3 | 445.46 us | 4.67 us | 148.49 us | 420.73 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog_index | 23 | 2.77 ms | 0 ps | 120.30 us | 1.78 ms | 5 | 224 bytes | 45 bytes | 0 | 0 bytes | 0 bytes | 224 bytes | |
mysys/cnf | 5 | 232.16 us | 430.32 ns | 46.43 us | 204.67 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
csv/metadata | 4 | 217.30 us | 931.39 ns | 54.32 us | 151.94 us | 1 | 35 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 35 bytes | |
sql/pid | 3 | 12.03 us | 568.13 ns | 4.01 us | 10.02 us | 0 | 0 bytes | 0 bytes | 1 | 5 bytes | 5 bytes | 5 bytes | |
sql/casetest | 15 | 764.66 us | 0 ps | 50.98 us | 673.68 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 3 | 49.45 us | 0 ps | 16.48 us | 27.13 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 6 | 476.09 us | 0 ps | 79.35 us | 457.99 us | 2 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|