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 | 6335 | 11.57 s | 0 ps | 1.83 ms | 233.30 ms | 1580 | 29.56 MiB | 19.16 KiB | 3436 | 112.95 MiB | 33.66 KiB | 142.52 MiB | |
sql/io_cache | 1398 | 186.71 ms | 0 ps | 133.55 us | 86.84 ms | 628 | 30.56 MiB | 49.83 KiB | 560 | 30.55 MiB | 55.86 KiB | 61.11 MiB | |
innodb/innodb_temp_file | 699 | 1.61 s | 0 ps | 2.30 ms | 232.76 ms | 0 | 0 bytes | 0 bytes | 585 | 13.14 MiB | 23.00 KiB | 13.14 MiB | |
sql/ERRMSG | 70 | 37.97 ms | 2.92 us | 542.46 us | 3.77 ms | 42 | 4.10 MiB | 99.93 KiB | 0 | 0 bytes | 0 bytes | 4.10 MiB | |
innodb/innodb_log_file | 3682 | 19.28 s | 250.27 ns | 5.24 ms | 105.95 ms | 8 | 69.00 KiB | 8.62 KiB | 2272 | 2.87 MiB | 1.29 KiB | 2.93 MiB | |
myisam/dfile | 5297 | 13.15 ms | 0 ps | 2.48 us | 3.56 ms | 1269 | 92.28 KiB | 74 bytes | 3340 | 479.28 KiB | 147 bytes | 571.56 KiB | |
sql/binlog | 835 | 1.30 s | 0 ps | 1.56 ms | 41.57 ms | 148 | 1.30 KiB | 9 bytes | 150 | 505.82 KiB | 3.37 KiB | 507.12 KiB | |
sql/SDI | 24 | 861.87 us | 0 ps | 35.91 us | 155.74 us | 0 | 0 bytes | 0 bytes | 7 | 31.32 KiB | 4.47 KiB | 31.32 KiB | |
mysys/charset | 3 | 273.18 us | 3.85 us | 91.06 us | 252.59 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
myisam/kfile | 108 | 3.44 ms | 0 ps | 31.85 us | 594.68 us | 20 | 3.65 KiB | 187 bytes | 48 | 2.77 KiB | 59 bytes | 6.42 KiB | |
sql/binlog_index | 38 | 42.03 ms | 0 ps | 1.11 ms | 22.64 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
csv/metadata | 8 | 564.95 us | 669.50 ns | 70.62 us | 287.83 us | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 70 bytes | |
mysys/cnf | 5 | 419.50 us | 208.03 ns | 83.90 us | 397.46 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 13.54 us | 631.49 ns | 4.51 us | 10.78 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
csv/data | 8 | 953.89 us | 0 ps | 119.24 us | 344.53 us | 2 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 28 | 674.42 us | 0 ps | 24.09 us | 269.69 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/casetest | 15 | 869.73 us | 0 ps | 57.98 us | 788.29 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|