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 | 1828 | 1.58 s | 0 ps | 864.81 us | 627.39 ms | 1320 | 25.50 MiB | 19.78 KiB | 271 | 17.83 MiB | 67.37 KiB | 43.33 MiB | |
innodb/innodb_temp_file | 201 | 527.41 ms | 0 ps | 2.62 ms | 47.23 ms | 0 | 0 bytes | 0 bytes | 135 | 3.11 MiB | 23.59 KiB | 3.11 MiB | |
sql/io_cache | 70 | 8.19 ms | 0 ps | 117.06 us | 5.61 ms | 32 | 1.51 MiB | 48.20 KiB | 28 | 1.51 MiB | 55.09 KiB | 3.01 MiB | |
sql/ERRMSG | 15 | 8.93 ms | 2.30 us | 595.18 us | 3.30 ms | 9 | 892.17 KiB | 99.13 KiB | 0 | 0 bytes | 0 bytes | 892.17 KiB | |
innodb/innodb_log_file | 249 | 2.34 s | 225.46 ns | 9.39 ms | 544.30 ms | 8 | 69.00 KiB | 8.62 KiB | 138 | 126.50 KiB | 939 bytes | 195.50 KiB | |
mysys/charset | 3 | 315.99 us | 2.08 us | 105.33 us | 305.09 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 41 | 44.26 ms | 0 ps | 1.08 ms | 22.28 ms | 7 | 624 bytes | 89 bytes | 3 | 156 bytes | 52 bytes | 780 bytes | |
sql/binlog_index | 38 | 51.80 ms | 0 ps | 1.36 ms | 25.97 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
mysys/cnf | 5 | 1.66 ms | 200.64 ns | 331.25 us | 1.64 ms | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 62.12 us | 2.74 us | 20.71 us | 38.57 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 1.03 ms | 0 ps | 68.84 us | 973.04 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 1 | 10.13 us | 0 ps | 10.13 us | 10.13 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|