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 | 2537 | 3.43 s | 0 ps | 1.35 ms | 281.48 ms | 1311 | 25.36 MiB | 19.81 KiB | 818 | 33.73 MiB | 42.23 KiB | 59.09 MiB | |
innodb/innodb_temp_file | 258 | 1.46 s | 0 ps | 5.64 ms | 39.09 ms | 0 | 0 bytes | 0 bytes | 156 | 5.69 MiB | 37.33 KiB | 5.69 MiB | |
sql/ERRMSG | 65 | 45.42 ms | 2.76 us | 698.77 us | 9.28 ms | 39 | 3.81 MiB | 99.93 KiB | 0 | 0 bytes | 0 bytes | 3.81 MiB | |
sql/io_cache | 34 | 1.50 ms | 0 ps | 44.10 us | 719.92 us | 10 | 765.60 KiB | 76.56 KiB | 14 | 765.60 KiB | 54.69 KiB | 1.50 MiB | |
innodb/innodb_log_file | 685 | 4.18 s | 227.57 ns | 6.11 ms | 117.17 ms | 8 | 69.00 KiB | 8.62 KiB | 400 | 369.00 KiB | 945 bytes | 438.00 KiB | |
mysys/charset | 3 | 341.59 us | 2.27 us | 113.86 us | 319.85 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 453 | 148.70 ms | 0 ps | 328.27 us | 26.44 ms | 107 | 1.00 KiB | 10 bytes | 9 | 1.91 KiB | 217 bytes | 2.91 KiB | |
sql/binlog_index | 38 | 82.21 ms | 0 ps | 2.16 ms | 53.06 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
mysys/cnf | 5 | 14.34 ms | 244.46 ns | 2.87 ms | 14.32 ms | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
csv/metadata | 4 | 661.64 us | 663.70 ns | 165.41 us | 601.39 us | 1 | 35 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 35 bytes | |
sql/pid | 3 | 24.52 us | 780.91 ns | 8.17 us | 17.73 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 967.20 us | 0 ps | 64.48 us | 881.86 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 5 | 695.15 us | 0 ps | 139.03 us | 453.30 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 2 | 190.16 us | 0 ps | 95.08 us | 179.88 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|