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 | 2519 | 2.17 s | 0 ps | 863.10 us | 216.50 ms | 1459 | 27.67 MiB | 19.42 KiB | 742 | 32.05 MiB | 44.23 KiB | 59.72 MiB | |
sql/io_cache | 98 | 2.24 ms | 0 ps | 22.82 us | 301.29 us | 52 | 2.12 MiB | 41.82 KiB | 36 | 2.12 MiB | 60.41 KiB | 4.25 MiB | |
innodb/innodb_temp_file | 195 | 412.49 ms | 0 ps | 2.12 ms | 30.68 ms | 0 | 0 bytes | 0 bytes | 131 | 2.92 MiB | 22.84 KiB | 2.92 MiB | |
sql/ERRMSG | 45 | 30.39 ms | 2.86 us | 675.35 us | 4.07 ms | 27 | 2.64 MiB | 100.21 KiB | 0 | 0 bytes | 0 bytes | 2.64 MiB | |
innodb/innodb_log_file | 574 | 3.00 s | 243.41 ns | 5.22 ms | 35.13 ms | 8 | 69.00 KiB | 8.62 KiB | 337 | 348.00 KiB | 1.03 KiB | 417.00 KiB | |
mysys/charset | 3 | 332.94 us | 1.85 us | 110.98 us | 316.18 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 137 | 99.99 ms | 0 ps | 729.83 us | 28.36 ms | 29 | 712 bytes | 25 bytes | 7 | 1.18 KiB | 172 bytes | 1.87 KiB | |
myisam/kfile | 4 | 736.26 us | 546.48 ns | 184.06 us | 690.41 us | 2 | 442 bytes | 221 bytes | 0 | 0 bytes | 0 bytes | 442 bytes | |
sql/binlog_index | 38 | 53.30 ms | 0 ps | 1.40 ms | 26.01 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
csv/metadata | 8 | 678.26 us | 624.62 ns | 84.78 us | 331.37 us | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 70 bytes | |
mysys/cnf | 5 | 491.76 us | 154.18 ns | 98.35 us | 472.42 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 13.81 us | 660.00 ns | 4.60 us | 9.49 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 778.75 us | 0 ps | 51.92 us | 711.01 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 3 | 28.40 us | 0 ps | 9.47 us | 12.73 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 4 | 236.97 us | 0 ps | 59.24 us | 202.75 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
myisam/dfile | 2 | 10.55 us | 341.62 ns | 5.27 us | 10.21 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|