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 | 2682 | 2.11 s | 0 ps | 788.07 us | 193.06 ms | 1568 | 29.52 MiB | 19.28 KiB | 757 | 32.08 MiB | 43.39 KiB | 61.59 MiB | |
sql/io_cache | 808 | 149.24 ms | 0 ps | 184.71 us | 87.97 ms | 396 | 18.52 MiB | 47.89 KiB | 322 | 18.52 MiB | 58.90 KiB | 37.04 MiB | |
innodb/innodb_temp_file | 890 | 933.54 ms | 0 ps | 1.05 ms | 63.62 ms | 0 | 0 bytes | 0 bytes | 797 | 15.14 MiB | 19.45 KiB | 15.14 MiB | |
sql/ERRMSG | 85 | 49.78 ms | 2.30 us | 585.64 us | 3.01 ms | 51 | 4.98 MiB | 99.93 KiB | 0 | 0 bytes | 0 bytes | 4.98 MiB | |
innodb/innodb_log_file | 654 | 3.42 s | 229.15 ns | 5.23 ms | 38.97 ms | 8 | 69.00 KiB | 8.62 KiB | 384 | 309.50 KiB | 825 bytes | 378.50 KiB | |
mysys/charset | 3 | 255.76 us | 2.17 us | 85.25 us | 243.99 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 393 | 178.25 ms | 0 ps | 453.55 us | 43.49 ms | 94 | 7.32 KiB | 80 bytes | 8 | 1.69 KiB | 216 bytes | 9.00 KiB | |
sql/binlog_index | 23 | 1.69 ms | 0 ps | 73.36 us | 426.53 us | 5 | 160 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 160 bytes | |
mysys/cnf | 5 | 167.69 us | 215.42 ns | 33.54 us | 152.75 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 26.64 us | 1.86 us | 8.88 us | 20.53 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 1.15 ms | 0 ps | 76.89 us | 1.09 ms | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 3 | 57.34 us | 0 ps | 19.11 us | 30.62 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|