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 | 4908 | 5.52 s | 0 ps | 1.12 ms | 233.19 ms | 1466 | 27.78 MiB | 19.41 KiB | 2766 | 92.58 MiB | 34.27 KiB | 120.36 MiB | |
innodb/innodb_temp_file | 217 | 1.10 s | 0 ps | 5.08 ms | 34.82 ms | 0 | 0 bytes | 0 bytes | 115 | 5.05 MiB | 44.94 KiB | 5.05 MiB | |
sql/ERRMSG | 70 | 38.97 ms | 1.88 us | 556.72 us | 3.17 ms | 42 | 4.10 MiB | 100.08 KiB | 0 | 0 bytes | 0 bytes | 4.10 MiB | |
sql/io_cache | 78 | 4.09 ms | 0 ps | 52.49 us | 2.37 ms | 34 | 1.94 MiB | 58.40 KiB | 34 | 1.94 MiB | 58.40 KiB | 3.88 MiB | |
innodb/innodb_log_file | 2177 | 11.24 s | 239.71 ns | 5.16 ms | 65.66 ms | 8 | 69.00 KiB | 8.62 KiB | 1301 | 968.00 KiB | 762 bytes | 1.01 MiB | |
mysys/charset | 3 | 298.86 us | 2.31 us | 99.62 us | 286.05 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 391 | 68.79 ms | 0 ps | 175.94 us | 23.58 ms | 94 | 972 bytes | 10 bytes | 4 | 352 bytes | 88 bytes | 1.29 KiB | |
myisam/kfile | 12 | 4.17 ms | 514.80 ns | 347.40 us | 3.10 ms | 6 | 1.23 KiB | 210 bytes | 0 | 0 bytes | 0 bytes | 1.23 KiB | |
sql/binlog_index | 38 | 63.44 ms | 0 ps | 1.67 ms | 34.60 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
myisam/dfile | 19 | 639.94 us | 321.02 ns | 33.68 us | 516.53 us | 2 | 78 bytes | 39 bytes | 0 | 0 bytes | 0 bytes | 78 bytes | |
csv/metadata | 8 | 866.08 us | 665.28 ns | 108.26 us | 374.68 us | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 70 bytes | |
mysys/cnf | 5 | 651.53 us | 184.80 ns | 130.31 us | 629.78 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 63.02 us | 3.40 us | 21.01 us | 40.01 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 820.20 us | 0 ps | 54.68 us | 750.22 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 2 | 27.16 us | 0 ps | 13.58 us | 21.36 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 8 | 45.84 us | 0 ps | 5.73 us | 11.41 us | 2 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|