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 | 7014 | 12.72 s | 0 ps | 1.81 ms | 233.30 ms | 1588 | 29.69 MiB | 19.14 KiB | 3997 | 129.83 MiB | 33.26 KiB | 159.52 MiB | |
sql/io_cache | 1894 | 194.86 ms | 0 ps | 102.88 us | 86.84 ms | 900 | 41.26 MiB | 46.94 KiB | 744 | 41.25 MiB | 56.77 KiB | 82.50 MiB | |
innodb/innodb_temp_file | 993 | 1.78 s | 0 ps | 1.79 ms | 232.76 ms | 0 | 0 bytes | 0 bytes | 870 | 18.16 MiB | 21.37 KiB | 18.16 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 | 4224 | 21.95 s | 250.27 ns | 5.20 ms | 105.95 ms | 8 | 69.00 KiB | 8.62 KiB | 2602 | 3.13 MiB | 1.23 KiB | 3.20 MiB | |
myisam/dfile | 5303 | 13.17 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 | 943 | 1.37 s | 0 ps | 1.45 ms | 41.57 ms | 173 | 1.40 KiB | 8 bytes | 154 | 506.92 KiB | 3.29 KiB | 508.33 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 | 29 | 689.63 us | 0 ps | 23.78 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 |
|