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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sql/io_cache | 1813 | 212.16 ms | 0 ps | 117.02 us | 47.00 ms | 768 | 42.26 MiB | 56.35 KiB | 765 | 42.24 MiB | 56.54 KiB | 84.50 MiB | |
innodb/innodb_data_file | 3205 | 2.92 s | 0 ps | 911.69 us | 193.45 ms | 1481 | 29.84 MiB | 20.63 KiB | 1124 | 43.14 MiB | 39.30 KiB | 72.98 MiB | |
innodb/innodb_temp_file | 1432 | 1.27 s | 0 ps | 884.18 us | 26.84 ms | 0 | 0 bytes | 0 bytes | 1320 | 24.50 MiB | 19.01 KiB | 24.50 MiB | |
sql/ERRMSG | 70 | 54.78 ms | 2.54 us | 782.62 us | 7.20 ms | 42 | 4.10 MiB | 100.06 KiB | 0 | 0 bytes | 0 bytes | 4.10 MiB | |
innodb/innodb_log_file | 928 | 4.87 s | 234.43 ns | 5.25 ms | 46.66 ms | 8 | 69.00 KiB | 8.62 KiB | 548 | 519.50 KiB | 971 bytes | 588.50 KiB | |
sql/binlog | 619 | 183.97 ms | 0 ps | 297.21 us | 19.03 ms | 156 | 100.21 KiB | 658 bytes | 12 | 2.80 KiB | 239 bytes | 103.02 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 | |
csv/metadata | 8 | 11.13 ms | 1.01 us | 1.39 ms | 10.66 ms | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 70 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 | |
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 | 4 | 61.65 us | 0 ps | 15.41 us | 32.36 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 15 | 866.61 us | 0 ps | 57.77 us | 400.17 us | 5 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|