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 | 1782 | 1.06 s | 0 ps | 595.73 us | 223.09 ms | 1306 | 25.28 MiB | 19.82 KiB | 257 | 17.30 MiB | 68.92 KiB | 42.58 MiB | |
sql/ERRMSG | 30 | 23.75 ms | 2.85 us | 791.54 us | 6.68 ms | 18 | 1.76 MiB | 100.32 KiB | 0 | 0 bytes | 0 bytes | 1.76 MiB | |
innodb/innodb_temp_file | 99 | 484.71 ms | 0 ps | 4.90 ms | 40.19 ms | 0 | 0 bytes | 0 bytes | 36 | 1.38 MiB | 39.11 KiB | 1.38 MiB | |
innodb/innodb_log_file | 189 | 1.15 s | 247.10 ns | 6.08 ms | 103.54 ms | 8 | 69.00 KiB | 8.62 KiB | 105 | 103.50 KiB | 1009 bytes | 172.50 KiB | |
mysys/charset | 3 | 287.46 us | 2.42 us | 95.82 us | 272.83 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 309 | 48.30 ms | 0 ps | 156.30 us | 22.34 ms | 74 | 892 bytes | 12 bytes | 3 | 156 bytes | 52 bytes | 1.02 KiB | |
sql/binlog_index | 38 | 48.96 ms | 0 ps | 1.29 ms | 27.44 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
mysys/cnf | 5 | 508.53 us | 137.81 ns | 101.71 us | 492.64 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 63.33 us | 2.83 us | 21.11 us | 38.94 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 1.01 ms | 0 ps | 67.01 us | 943.44 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 1 | 13.80 us | 0 ps | 13.80 us | 13.80 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|