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 | 2705 | 4.79 s | 0 ps | 1.77 ms | 922.96 ms | 1354 | 26.03 MiB | 19.69 KiB | 969 | 38.73 MiB | 40.93 KiB | 64.77 MiB | |
sql/io_cache | 108 | 5.54 ms | 0 ps | 51.34 us | 2.09 ms | 39 | 2.75 MiB | 72.08 KiB | 49 | 2.75 MiB | 57.37 KiB | 5.49 MiB | |
innodb/innodb_temp_file | 227 | 476.00 ms | 0 ps | 2.10 ms | 36.31 ms | 0 | 0 bytes | 0 bytes | 159 | 3.61 MiB | 23.25 KiB | 3.61 MiB | |
sql/ERRMSG | 45 | 108.47 ms | 3.06 us | 2.41 ms | 72.66 ms | 27 | 2.65 MiB | 100.53 KiB | 0 | 0 bytes | 0 bytes | 2.65 MiB | |
innodb/innodb_log_file | 794 | 5.23 s | 291.98 ns | 6.59 ms | 1.06 s | 8 | 69.00 KiB | 8.62 KiB | 476 | 542.50 KiB | 1.14 KiB | 611.50 KiB | |
myisam/dfile | 3945 | 6.06 ms | 187.44 ns | 1.54 us | 2.20 ms | 3937 | 576.63 KiB | 150 bytes | 0 | 0 bytes | 0 bytes | 576.63 KiB | |
mysys/charset | 3 | 246.79 us | 2.63 us | 82.26 us | 231.69 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 145 | 220.85 ms | 0 ps | 1.52 ms | 21.01 ms | 26 | 700 bytes | 27 bytes | 17 | 3.61 KiB | 217 bytes | 4.29 KiB | |
myisam/kfile | 12 | 2.07 ms | 441.41 ns | 172.83 us | 1.44 ms | 6 | 1.23 KiB | 210 bytes | 0 | 0 bytes | 0 bytes | 1.23 KiB | |
sql/binlog_index | 38 | 44.96 ms | 0 ps | 1.18 ms | 29.26 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
csv/metadata | 8 | 11.12 ms | 531.17 ns | 1.39 ms | 10.10 ms | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 70 bytes | |
mysys/cnf | 5 | 1.03 ms | 255.55 ns | 206.83 us | 999.54 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 16.17 us | 680.59 ns | 5.39 us | 10.99 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 730.67 us | 0 ps | 48.71 us | 661.42 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 8 | 148.96 us | 0 ps | 18.62 us | 48.03 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 4 | 1.67 ms | 0 ps | 416.66 us | 1.64 ms | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|