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 | 2214 | 1.67 s | 0 ps | 755.07 us | 253.62 ms | 1309 | 25.33 MiB | 19.81 KiB | 667 | 29.73 MiB | 45.65 KiB | 55.06 MiB | |
sql/io_cache | 280 | 488.56 ms | 0 ps | 1.74 ms | 433.16 ms | 128 | 6.10 MiB | 48.83 KiB | 112 | 6.10 MiB | 55.81 KiB | 12.21 MiB | |
innodb/innodb_temp_file | 477 | 660.41 ms | 0 ps | 1.38 ms | 32.87 ms | 0 | 0 bytes | 0 bytes | 404 | 7.75 MiB | 19.64 KiB | 7.75 MiB | |
sql/ERRMSG | 25 | 20.97 ms | 2.85 us | 838.78 us | 3.74 ms | 15 | 1.45 MiB | 99.31 KiB | 0 | 0 bytes | 0 bytes | 1.45 MiB | |
innodb/innodb_log_file | 557 | 2.83 s | 249.74 ns | 5.07 ms | 33.49 ms | 8 | 69.00 KiB | 8.62 KiB | 330 | 266.50 KiB | 827 bytes | 335.50 KiB | |
mysys/charset | 3 | 258.41 us | 2.19 us | 86.14 us | 245.26 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 97 | 41.12 ms | 0 ps | 423.94 us | 17.21 ms | 21 | 680 bytes | 32 bytes | 3 | 156 bytes | 52 bytes | 836 bytes | |
sql/binlog_index | 38 | 62.91 ms | 0 ps | 1.66 ms | 42.64 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
mysys/cnf | 5 | 740.35 us | 208.56 ns | 148.07 us | 719.32 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
csv/metadata | 4 | 3.41 ms | 488.93 ns | 853.51 us | 1.98 ms | 1 | 35 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 35 bytes | |
sql/pid | 3 | 13.47 us | 643.63 ns | 4.49 us | 10.80 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 1.20 ms | 0 ps | 79.79 us | 1.13 ms | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 1 | 14.96 us | 0 ps | 14.96 us | 14.96 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 2 | 38.05 us | 0 ps | 19.02 us | 23.91 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|