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 | 2090 | 1.71 s | 0 ps | 819.25 us | 211.14 ms | 1316 | 25.44 MiB | 19.79 KiB | 513 | 24.89 MiB | 49.68 KiB | 50.33 MiB | |
innodb/innodb_temp_file | 467 | 939.55 ms | 0 ps | 2.01 ms | 90.46 ms | 0 | 0 bytes | 0 bytes | 390 | 7.78 MiB | 20.43 KiB | 7.78 MiB | |
sql/io_cache | 126 | 138.55 ms | 0 ps | 1.10 ms | 118.02 ms | 44 | 3.09 MiB | 71.85 KiB | 57 | 3.09 MiB | 55.46 KiB | 6.17 MiB | |
sql/ERRMSG | 25 | 9.97 ms | 2.81 us | 398.98 us | 1.32 ms | 15 | 1.46 MiB | 99.98 KiB | 0 | 0 bytes | 0 bytes | 1.46 MiB | |
innodb/innodb_log_file | 397 | 2.95 s | 222.29 ns | 7.42 ms | 717.03 ms | 8 | 69.00 KiB | 8.62 KiB | 226 | 190.00 KiB | 861 bytes | 259.00 KiB | |
mysys/charset | 3 | 283.03 us | 1.41 us | 94.34 us | 273.07 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 89 | 57.73 ms | 0 ps | 648.62 us | 31.94 ms | 19 | 672 bytes | 35 bytes | 3 | 156 bytes | 52 bytes | 828 bytes | |
sql/binlog_index | 38 | 45.11 ms | 0 ps | 1.19 ms | 23.76 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
csv/metadata | 8 | 9.89 ms | 532.22 ns | 1.24 ms | 9.17 ms | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 70 bytes | |
mysys/cnf | 5 | 1.72 ms | 168.43 ns | 344.84 us | 1.71 ms | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 52.97 us | 2.80 us | 17.66 us | 35.30 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 937.51 us | 0 ps | 62.50 us | 864.43 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 1 | 4.96 us | 0 ps | 4.96 us | 4.96 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 4 | 1.70 ms | 0 ps | 425.69 us | 1.63 ms | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|