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 | 6185 | 11.25 s | 0 ps | 1.82 ms | 233.30 ms | 1579 | 29.55 MiB | 19.16 KiB | 3312 | 109.33 MiB | 33.80 KiB | 138.88 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 | 690 | 1.54 s | 0 ps | 2.23 ms | 232.76 ms | 0 | 0 bytes | 0 bytes | 579 | 12.86 MiB | 22.74 KiB | 12.86 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 | 3635 | 18.99 s | 250.27 ns | 5.22 ms | 105.95 ms | 8 | 69.00 KiB | 8.62 KiB | 2245 | 2.84 MiB | 1.30 KiB | 2.91 MiB | |
myisam/dfile | 5119 | 13.01 ms | 0 ps | 2.54 us | 3.56 ms | 1153 | 87.59 KiB | 78 bytes | 3340 | 479.28 KiB | 147 bytes | 566.87 KiB | |
sql/binlog | 813 | 1.28 s | 0 ps | 1.58 ms | 41.57 ms | 143 | 1.28 KiB | 9 bytes | 149 | 505.58 KiB | 3.39 KiB | 506.87 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 | 27 | 660.82 us | 0 ps | 24.47 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 |
|