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 | 1346 | 420.01 ms | 0 ps | 312.04 us | 67.32 ms | 1115 | 19.72 MiB | 18.11 KiB | 179 | 15.02 MiB | 85.90 KiB | 34.73 MiB | |
sql/io_cache | 46 | 959.77 us | 0 ps | 20.86 us | 88.48 us | 16 | 1.10 MiB | 70.23 KiB | 20 | 1.10 MiB | 56.18 KiB | 2.19 MiB | |
sql/ERRMSG | 30 | 15.55 ms | 2.79 us | 518.41 us | 1.92 ms | 18 | 1.74 MiB | 99.14 KiB | 0 | 0 bytes | 0 bytes | 1.74 MiB | |
innodb/innodb_temp_file | 98 | 343.56 ms | 0 ps | 3.51 ms | 31.15 ms | 0 | 0 bytes | 0 bytes | 36 | 1.31 MiB | 37.33 KiB | 1.31 MiB | |
innodb/innodb_log_file | 69 | 301.76 ms | 224.40 ns | 4.37 ms | 30.84 ms | 8 | 69.00 KiB | 8.62 KiB | 33 | 58.00 KiB | 1.76 KiB | 127.00 KiB | |
sql/binlog | 260 | 54.67 ms | 0 ps | 210.28 us | 24.35 ms | 68 | 65.88 KiB | 992 bytes | 4 | 388 bytes | 97 bytes | 66.26 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 | 2 | 37.40 us | 0 ps | 18.70 us | 27.13 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|