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 | 1318 | 295.97 ms | 0 ps | 224.56 us | 67.32 ms | 1113 | 19.69 MiB | 18.11 KiB | 164 | 14.64 MiB | 91.41 KiB | 34.33 MiB | |
sql/ERRMSG | 25 | 13.26 ms | 2.79 us | 530.41 us | 1.92 ms | 15 | 1.45 MiB | 99.17 KiB | 0 | 0 bytes | 0 bytes | 1.45 MiB | |
innodb/innodb_temp_file | 90 | 300.48 ms | 0 ps | 3.34 ms | 31.15 ms | 0 | 0 bytes | 0 bytes | 30 | 1.09 MiB | 37.33 KiB | 1.09 MiB | |
sql/io_cache | 23 | 416.00 us | 0 ps | 18.09 us | 66.82 us | 8 | 557.79 KiB | 69.72 KiB | 10 | 557.79 KiB | 55.78 KiB | 1.09 MiB | |
innodb/innodb_log_file | 47 | 131.28 ms | 224.40 ns | 2.79 ms | 24.18 ms | 8 | 69.00 KiB | 8.62 KiB | 21 | 52.00 KiB | 2.48 KiB | 121.00 KiB | |
sql/binlog | 73 | 40.87 ms | 0 ps | 559.83 us | 24.35 ms | 21 | 65.55 KiB | 3.12 KiB | 3 | 156 bytes | 52 bytes | 65.70 KiB | |
mysys/charset | 3 | 445.46 us | 4.67 us | 148.49 us | 420.73 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog_index | 23 | 2.77 ms | 0 ps | 120.30 us | 1.78 ms | 5 | 224 bytes | 45 bytes | 0 | 0 bytes | 0 bytes | 224 bytes | |
mysys/cnf | 5 | 232.16 us | 430.32 ns | 46.43 us | 204.67 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 12.03 us | 568.13 ns | 4.01 us | 10.02 us | 0 | 0 bytes | 0 bytes | 1 | 5 bytes | 5 bytes | 5 bytes | |
sql/casetest | 15 | 764.66 us | 0 ps | 50.98 us | 673.68 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 1 | 10.26 us | 0 ps | 10.26 us | 10.26 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|