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 | 2714 | 2.25 s | 0 ps | 827.42 us | 193.45 ms | 1447 | 29.31 MiB | 20.74 KiB | 760 | 32.14 MiB | 43.31 KiB | 61.45 MiB | |
sql/io_cache | 1251 | 150.66 ms | 0 ps | 120.43 us | 24.16 ms | 522 | 28.94 MiB | 56.78 KiB | 529 | 28.93 MiB | 56.00 KiB | 57.87 MiB | |
innodb/innodb_temp_file | 1004 | 989.49 ms | 0 ps | 985.55 us | 26.84 ms | 0 | 0 bytes | 0 bytes | 909 | 17.02 MiB | 19.17 KiB | 17.02 MiB | |
sql/ERRMSG | 65 | 50.45 ms | 2.54 us | 776.09 us | 7.20 ms | 39 | 3.81 MiB | 99.91 KiB | 0 | 0 bytes | 0 bytes | 3.81 MiB | |
innodb/innodb_log_file | 619 | 3.20 s | 234.43 ns | 5.17 ms | 46.66 ms | 8 | 69.00 KiB | 8.62 KiB | 359 | 338.00 KiB | 964 bytes | 407.00 KiB | |
sql/binlog | 407 | 147.09 ms | 0 ps | 361.40 us | 16.07 ms | 104 | 100.01 KiB | 985 bytes | 10 | 2.22 KiB | 227 bytes | 102.23 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 | |
csv/metadata | 8 | 11.13 ms | 1.01 us | 1.39 ms | 10.66 ms | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 70 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 | |
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 | 15 | 866.61 us | 0 ps | 57.77 us | 400.17 us | 5 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|