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 | 2969 | 4.71 s | 0 ps | 1.59 ms | 281.48 ms | 1319 | 25.48 MiB | 19.78 KiB | 1140 | 43.39 MiB | 38.98 KiB | 68.88 MiB | |
innodb/innodb_temp_file | 337 | 1.84 s | 0 ps | 5.47 ms | 70.79 ms | 0 | 0 bytes | 0 bytes | 220 | 7.62 MiB | 35.49 KiB | 7.62 MiB | |
sql/io_cache | 102 | 7.15 ms | 0 ps | 70.06 us | 4.08 ms | 42 | 2.25 MiB | 54.76 KiB | 40 | 2.25 MiB | 57.50 KiB | 4.49 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 | |
innodb/innodb_log_file | 971 | 5.88 s | 227.57 ns | 6.06 ms | 117.17 ms | 8 | 69.00 KiB | 8.62 KiB | 572 | 556.00 KiB | 995 bytes | 625.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 | 669 | 416.01 ms | 0 ps | 621.83 us | 26.44 ms | 152 | 1.18 KiB | 8 bytes | 27 | 7.51 KiB | 285 bytes | 8.68 KiB | |
myisam/dfile | 80 | 224.53 us | 93.98 ns | 2.81 us | 193.03 us | 50 | 2.90 KiB | 59 bytes | 0 | 0 bytes | 0 bytes | 2.90 KiB | |
myisam/kfile | 4 | 711.88 us | 843.22 ns | 177.97 us | 684.32 us | 2 | 442 bytes | 221 bytes | 0 | 0 bytes | 0 bytes | 442 bytes | |
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 | 6 | 2.51 ms | 0 ps | 419.04 us | 1.82 ms | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 16 | 520.60 us | 0 ps | 32.54 us | 266.23 us | 6 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|