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 | 2539 | 1.80 s | 0 ps | 710.35 us | 193.45 ms | 1435 | 29.12 MiB | 20.78 KiB | 653 | 29.14 MiB | 45.70 KiB | 58.27 MiB | |
sql/io_cache | 887 | 129.17 ms | 0 ps | 145.63 us | 24.16 ms | 370 | 20.78 MiB | 57.51 KiB | 377 | 20.78 MiB | 56.45 KiB | 41.56 MiB | |
innodb/innodb_temp_file | 878 | 805.03 ms | 0 ps | 916.89 us | 25.78 ms | 0 | 0 bytes | 0 bytes | 793 | 14.58 MiB | 18.82 KiB | 14.58 MiB | |
sql/ERRMSG | 60 | 44.61 ms | 2.54 us | 743.52 us | 7.20 ms | 36 | 3.52 MiB | 99.99 KiB | 0 | 0 bytes | 0 bytes | 3.52 MiB | |
innodb/innodb_log_file | 463 | 2.40 s | 234.43 ns | 5.18 ms | 46.66 ms | 8 | 69.00 KiB | 8.62 KiB | 268 | 276.50 KiB | 1.03 KiB | 345.50 KiB | |
sql/binlog | 287 | 146.71 ms | 0 ps | 511.19 us | 16.07 ms | 74 | 99.89 KiB | 1.35 KiB | 10 | 2.22 KiB | 227 bytes | 102.11 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 | 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 | 6 | 430.51 us | 0 ps | 71.75 us | 400.17 us | 2 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|