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 | 1461 | 387.99 ms | 0 ps | 265.57 us | 233.30 ms | 1240 | 24.25 MiB | 20.03 KiB | 77 | 13.02 MiB | 173.09 KiB | 37.27 MiB | |
sql/io_cache | 47 | 2.76 ms | 0 ps | 58.69 us | 1.77 ms | 17 | 1.08 MiB | 64.79 KiB | 20 | 1.08 MiB | 55.07 KiB | 2.15 MiB | |
innodb/innodb_temp_file | 92 | 342.55 ms | 0 ps | 3.72 ms | 24.85 ms | 0 | 0 bytes | 0 bytes | 31 | 1.17 MiB | 38.71 KiB | 1.17 MiB | |
sql/ERRMSG | 15 | 7.68 ms | 2.92 us | 512.25 us | 3.77 ms | 9 | 891.31 KiB | 99.03 KiB | 0 | 0 bytes | 0 bytes | 891.31 KiB | |
innodb/innodb_log_file | 160 | 740.09 ms | 250.27 ns | 4.63 ms | 51.30 ms | 8 | 69.00 KiB | 8.62 KiB | 90 | 95.50 KiB | 1.06 KiB | 164.50 KiB | |
mysys/charset | 3 | 273.18 us | 3.85 us | 91.06 us | 252.59 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 41 | 29.11 ms | 0 ps | 709.91 us | 15.34 ms | 7 | 624 bytes | 89 bytes | 3 | 156 bytes | 52 bytes | 780 bytes | |
sql/binlog_index | 38 | 42.03 ms | 0 ps | 1.11 ms | 22.64 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
mysys/cnf | 5 | 419.50 us | 208.03 ns | 83.90 us | 397.46 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
csv/metadata | 4 | 345.65 us | 669.50 ns | 86.41 us | 287.83 us | 1 | 35 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 35 bytes | |
sql/pid | 3 | 13.54 us | 631.49 ns | 4.51 us | 10.78 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 869.73 us | 0 ps | 57.98 us | 788.29 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 1 | 6.49 us | 0 ps | 6.49 us | 6.49 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 2 | 350.19 us | 0 ps | 175.10 us | 344.53 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|