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 | 1691 | 999.99 ms | 0 ps | 591.36 us | 211.14 ms | 1222 | 23.97 MiB | 20.09 KiB | 269 | 17.70 MiB | 67.39 KiB | 41.67 MiB | |
sql/io_cache | 74 | 121.80 ms | 0 ps | 1.65 ms | 118.02 ms | 26 | 1.79 MiB | 70.63 KiB | 33 | 1.79 MiB | 55.65 KiB | 3.59 MiB | |
innodb/innodb_temp_file | 217 | 453.28 ms | 0 ps | 2.09 ms | 35.37 ms | 0 | 0 bytes | 0 bytes | 154 | 3.22 MiB | 21.40 KiB | 3.22 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 | 226 | 2.05 s | 222.29 ns | 9.09 ms | 717.03 ms | 8 | 69.00 KiB | 8.62 KiB | 123 | 112.50 KiB | 937 bytes | 181.50 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 | 61 | 55.55 ms | 0 ps | 910.67 us | 31.94 ms | 12 | 644 bytes | 54 bytes | 3 | 156 bytes | 52 bytes | 800 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 | |
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 |
|