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 | 2506 | 3.28 s | 0 ps | 1.31 ms | 281.48 ms | 1311 | 25.36 MiB | 19.81 KiB | 801 | 33.33 MiB | 42.61 KiB | 58.69 MiB | |
innodb/innodb_temp_file | 234 | 1.31 s | 0 ps | 5.59 ms | 39.09 ms | 0 | 0 bytes | 0 bytes | 138 | 5.03 MiB | 37.33 KiB | 5.03 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 | 659 | 4.02 s | 227.57 ns | 6.10 ms | 117.17 ms | 8 | 69.00 KiB | 8.62 KiB | 386 | 362.00 KiB | 960 bytes | 431.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 | 379 | 132.08 ms | 0 ps | 348.49 us | 26.44 ms | 89 | 952 bytes | 11 bytes | 8 | 1.65 KiB | 211 bytes | 2.58 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 | 4 | 241.85 us | 0 ps | 60.46 us | 183.76 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 |
|