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 | 5245 | 8.87 s | 0 ps | 1.69 ms | 233.30 ms | 1547 | 29.05 MiB | 19.23 KiB | 2647 | 89.86 MiB | 34.76 KiB | 118.91 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 | 60 | 31.79 ms | 2.92 us | 529.86 us | 3.77 ms | 36 | 3.51 MiB | 99.97 KiB | 0 | 0 bytes | 0 bytes | 3.51 MiB | |
innodb/innodb_log_file | 3028 | 15.51 s | 250.27 ns | 5.12 ms | 105.95 ms | 8 | 69.00 KiB | 8.62 KiB | 1881 | 2.48 MiB | 1.35 KiB | 2.55 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 | 651 | 1.15 s | 0 ps | 1.76 ms | 41.57 ms | 108 | 1.15 KiB | 11 bytes | 138 | 502.85 KiB | 3.64 KiB | 503.99 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 | 21 | 578.97 us | 0 ps | 27.57 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 |
|