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 | 4966 | 10.05 s | 0 ps | 2.02 ms | 233.43 ms | 1343 | 25.86 MiB | 19.72 KiB | 2498 | 82.64 MiB | 33.88 KiB | 108.50 MiB | |
innodb/innodb_log_file | 3288 | 17.02 s | 235.49 ns | 5.18 ms | 77.27 ms | 8 | 69.00 KiB | 8.62 KiB | 2140 | 3.08 MiB | 1.47 KiB | 3.14 MiB | |
sql/ERRMSG | 50 | 32.40 ms | 4.33 us | 647.97 us | 3.41 ms | 30 | 2.94 MiB | 100.39 KiB | 0 | 0 bytes | 0 bytes | 2.94 MiB | |
sql/io_cache | 56 | 3.94 ms | 0 ps | 70.28 us | 1.83 ms | 20 | 1.42 MiB | 72.89 KiB | 26 | 1.42 MiB | 56.07 KiB | 2.85 MiB | |
innodb/innodb_temp_file | 158 | 705.57 ms | 0 ps | 4.47 ms | 90.78 ms | 0 | 0 bytes | 0 bytes | 86 | 2.72 MiB | 32.37 KiB | 2.72 MiB | |
sql/SDI | 66 | 17.09 ms | 0 ps | 259.01 us | 14.30 ms | 0 | 0 bytes | 0 bytes | 18 | 96.61 KiB | 5.37 KiB | 96.61 KiB | |
sql/binlog | 769 | 2.04 s | 0 ps | 2.65 ms | 44.15 ms | 122 | 1.06 KiB | 9 bytes | 137 | 35.34 KiB | 264 bytes | 36.40 KiB | |
mysys/charset | 3 | 364.02 us | 2.44 us | 121.34 us | 345.00 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
myisam/kfile | 224 | 4.72 ms | 0 ps | 21.09 us | 1.34 ms | 28 | 5.19 KiB | 190 bytes | 114 | 4.68 KiB | 42 bytes | 9.87 KiB | |
myisam/dfile | 221 | 2.17 ms | 0 ps | 9.82 us | 617.86 us | 64 | 1.45 KiB | 23 bytes | 54 | 2.60 KiB | 49 bytes | 4.05 KiB | |
sql/binlog_index | 38 | 57.20 ms | 0 ps | 1.51 ms | 31.89 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
csv/metadata | 8 | 825.75 us | 608.78 ns | 103.22 us | 461.23 us | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 70 bytes | |
mysys/cnf | 5 | 2.31 ms | 199.06 ns | 461.74 us | 2.29 ms | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 48.56 us | 2.70 us | 16.19 us | 38.38 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
csv/data | 4 | 37.18 us | 0 ps | 9.29 us | 15.58 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 54 | 887.34 us | 0 ps | 16.43 us | 33.44 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/casetest | 15 | 724.26 us | 0 ps | 48.28 us | 653.38 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|