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 | 2463 | 1.61 s | 0 ps | 655.62 us | 215.70 ms | 1372 | 26.31 MiB | 19.64 KiB | 844 | 35.30 MiB | 42.82 KiB | 61.61 MiB | |
innodb/innodb_temp_file | 307 | 784.17 ms | 0 ps | 2.55 ms | 186.25 ms | 0 | 0 bytes | 0 bytes | 235 | 5.05 MiB | 21.99 KiB | 5.05 MiB | |
sql/ERRMSG | 40 | 30.04 ms | 3.51 us | 751.05 us | 6.58 ms | 24 | 2.34 MiB | 100.00 KiB | 0 | 0 bytes | 0 bytes | 2.34 MiB | |
innodb/innodb_log_file | 684 | 3.42 s | 301.49 ns | 5.00 ms | 74.59 ms | 8 | 69.00 KiB | 8.62 KiB | 407 | 345.00 KiB | 868 bytes | 414.00 KiB | |
mysys/charset | 3 | 239.95 us | 2.24 us | 79.98 us | 226.99 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 97 | 120.23 ms | 0 ps | 1.24 ms | 36.02 ms | 19 | 672 bytes | 35 bytes | 7 | 1.24 KiB | 181 bytes | 1.89 KiB | |
myisam/kfile | 4 | 266.07 us | 760.32 ns | 66.52 us | 226.69 us | 2 | 392 bytes | 196 bytes | 0 | 0 bytes | 0 bytes | 392 bytes | |
sql/binlog_index | 38 | 44.30 ms | 0 ps | 1.17 ms | 26.04 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
csv/metadata | 8 | 21.40 ms | 664.22 ns | 2.67 ms | 12.83 ms | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 70 bytes | |
mysys/cnf | 5 | 853.45 us | 304.66 ns | 170.69 us | 831.35 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 17.26 us | 928.75 ns | 5.75 us | 13.64 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 1.08 ms | 0 ps | 71.70 us | 942.87 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 1 | 4.82 us | 0 ps | 4.82 us | 4.82 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 4 | 877.53 us | 0 ps | 219.38 us | 786.74 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
myisam/dfile | 2 | 15.72 us | 441.94 ns | 7.86 us | 15.28 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|