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.45 s | 0 ps | 794.52 us | 234.94 ms | 1244 | 24.31 MiB | 20.01 KiB | 344 | 19.77 MiB | 58.84 KiB | 44.08 MiB | |
sql/ERRMSG | 45 | 27.65 ms | 3.04 us | 614.42 us | 5.48 ms | 27 | 2.64 MiB | 100.05 KiB | 0 | 0 bytes | 0 bytes | 2.64 MiB | |
sql/io_cache | 50 | 2.97 ms | 0 ps | 59.46 us | 1.65 ms | 18 | 1.23 MiB | 70.25 KiB | 22 | 1.23 MiB | 57.48 KiB | 2.47 MiB | |
innodb/innodb_temp_file | 102 | 470.96 ms | 0 ps | 4.62 ms | 38.56 ms | 0 | 0 bytes | 0 bytes | 38 | 1.47 MiB | 39.58 KiB | 1.47 MiB | |
innodb/innodb_log_file | 325 | 1.87 s | 231.79 ns | 5.77 ms | 46.82 ms | 8 | 69.00 KiB | 8.62 KiB | 183 | 158.50 KiB | 887 bytes | 227.50 KiB | |
mysys/charset | 3 | 290.39 us | 1.93 us | 96.80 us | 276.24 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 69 | 78.24 ms | 0 ps | 1.13 ms | 22.66 ms | 13 | 648 bytes | 50 bytes | 5 | 661 bytes | 132 bytes | 1.28 KiB | |
sql/binlog_index | 38 | 48.67 ms | 0 ps | 1.28 ms | 26.15 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
mysys/cnf | 5 | 384.90 us | 229.15 ns | 76.98 us | 364.78 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 99.52 us | 3.96 us | 33.17 us | 73.11 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 747.53 us | 0 ps | 49.84 us | 687.09 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 3 | 254.16 us | 0 ps | 84.72 us | 226.16 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|