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 | 1973 | 857.79 ms | 0 ps | 434.77 us | 193.45 ms | 1370 | 28.11 MiB | 21.01 KiB | 248 | 16.95 MiB | 70.00 KiB | 45.06 MiB | |
sql/io_cache | 343 | 20.85 ms | 0 ps | 60.80 us | 11.77 ms | 130 | 8.51 MiB | 67.01 KiB | 153 | 8.51 MiB | 56.94 KiB | 17.01 MiB | |
innodb/innodb_temp_file | 569 | 590.73 ms | 0 ps | 1.04 ms | 25.78 ms | 0 | 0 bytes | 0 bytes | 497 | 9.14 MiB | 18.83 KiB | 9.14 MiB | |
sql/ERRMSG | 55 | 43.10 ms | 2.54 us | 783.68 us | 7.20 ms | 33 | 3.22 MiB | 99.87 KiB | 0 | 0 bytes | 0 bytes | 3.22 MiB | |
innodb/innodb_log_file | 182 | 910.84 ms | 234.43 ns | 5.00 ms | 39.40 ms | 8 | 69.00 KiB | 8.62 KiB | 98 | 101.00 KiB | 1.03 KiB | 170.00 KiB | |
sql/binlog | 211 | 63.01 ms | 0 ps | 298.62 us | 16.07 ms | 58 | 99.83 KiB | 1.72 KiB | 4 | 490 bytes | 122 bytes | 100.31 KiB | |
mysys/charset | 3 | 560.75 us | 8.12 us | 186.92 us | 515.86 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog_index | 23 | 1.30 ms | 0 ps | 56.37 us | 410.58 us | 5 | 160 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 160 bytes | |
mysys/cnf | 5 | 196.94 us | 380.69 ns | 39.39 us | 177.57 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
csv/metadata | 4 | 10.89 ms | 1.16 us | 2.72 ms | 10.66 ms | 1 | 35 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 35 bytes | |
sql/pid | 3 | 16.45 us | 826.85 ns | 5.48 us | 13.44 us | 0 | 0 bytes | 0 bytes | 1 | 5 bytes | 5 bytes | 5 bytes | |
sql/casetest | 15 | 967.70 us | 0 ps | 64.51 us | 864.35 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 1 | 4.84 us | 0 ps | 4.84 us | 4.84 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 6 | 430.51 us | 0 ps | 71.75 us | 400.17 us | 2 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|