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 | 5749 | 10.13 s | 0 ps | 1.76 ms | 233.30 ms | 1551 | 29.11 MiB | 19.22 KiB | 3037 | 101.42 MiB | 34.20 KiB | 130.53 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 | 684 | 1.51 s | 0 ps | 2.20 ms | 232.76 ms | 0 | 0 bytes | 0 bytes | 575 | 12.67 MiB | 22.57 KiB | 12.67 MiB | |
sql/ERRMSG | 65 | 36.35 ms | 2.92 us | 559.22 us | 3.77 ms | 39 | 3.81 MiB | 99.95 KiB | 0 | 0 bytes | 0 bytes | 3.81 MiB | |
innodb/innodb_log_file | 3319 | 17.19 s | 250.27 ns | 5.18 ms | 105.95 ms | 8 | 69.00 KiB | 8.62 KiB | 2056 | 2.68 MiB | 1.33 KiB | 2.75 MiB | |
myisam/dfile | 4922 | 10.90 ms | 0 ps | 2.21 us | 3.56 ms | 1014 | 76.62 KiB | 77 bytes | 3340 | 479.28 KiB | 147 bytes | 555.89 KiB | |
sql/binlog | 737 | 1.24 s | 0 ps | 1.68 ms | 41.57 ms | 126 | 1.22 KiB | 10 bytes | 145 | 504.67 KiB | 3.48 KiB | 505.89 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 | 26 | 649.07 us | 0 ps | 24.96 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 |
|