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 | 3883 | 5.58 s | 0 ps | 1.44 ms | 280.83 ms | 1529 | 28.77 MiB | 19.26 KiB | 1681 | 59.77 MiB | 36.41 KiB | 88.53 MiB | |
sql/io_cache | 316 | 31.62 ms | 0 ps | 100.06 us | 12.37 ms | 140 | 6.82 MiB | 49.90 KiB | 126 | 6.81 MiB | 55.31 KiB | 13.63 MiB | |
innodb/innodb_temp_file | 188 | 1.05 s | 0 ps | 5.60 ms | 41.03 ms | 0 | 0 bytes | 0 bytes | 95 | 4.17 MiB | 44.97 KiB | 4.17 MiB | |
sql/ERRMSG | 50 | 38.03 ms | 2.17 us | 760.54 us | 3.16 ms | 30 | 2.93 MiB | 99.86 KiB | 0 | 0 bytes | 0 bytes | 2.93 MiB | |
innodb/innodb_log_file | 1463 | 9.26 s | 236.02 ns | 6.33 ms | 236.70 ms | 8 | 69.00 KiB | 8.62 KiB | 881 | 883.50 KiB | 1.00 KiB | 952.50 KiB | |
mysys/charset | 3 | 220.45 us | 2.68 us | 73.48 us | 207.39 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 344 | 396.37 ms | 0 ps | 1.15 ms | 23.80 ms | 72 | 1.01 KiB | 14 bytes | 26 | 7.01 KiB | 276 bytes | 8.02 KiB | |
myisam/kfile | 16 | 2.07 ms | 595.58 ns | 129.24 us | 666.07 us | 8 | 1.66 KiB | 213 bytes | 0 | 0 bytes | 0 bytes | 1.66 KiB | |
myisam/dfile | 41 | 587.14 us | 188.50 ns | 14.32 us | 498.05 us | 25 | 975 bytes | 39 bytes | 0 | 0 bytes | 0 bytes | 975 bytes | |
sql/binlog_index | 38 | 55.13 ms | 0 ps | 1.45 ms | 31.11 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
csv/metadata | 8 | 5.25 ms | 651.02 ns | 655.65 us | 2.33 ms | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 70 bytes | |
mysys/cnf | 5 | 641.00 us | 159.98 ns | 128.20 us | 623.30 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 47.00 us | 2.81 us | 15.67 us | 37.42 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 1.17 ms | 0 ps | 77.84 us | 1.11 ms | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 5 | 47.54 us | 0 ps | 9.51 us | 15.60 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 56 | 1.04 ms | 0 ps | 18.59 us | 489.78 us | 22 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|