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 | 1970 | 220.90 ms | 0 ps | 112.13 us | 47.00 ms | 839 | 46.03 MiB | 56.18 KiB | 831 | 46.00 MiB | 56.69 KiB | 92.03 MiB | |
innodb/innodb_data_file | 3317 | 3.04 s | 0 ps | 917.09 us | 193.45 ms | 1538 | 30.73 MiB | 20.46 KiB | 1137 | 43.45 MiB | 39.13 KiB | 74.19 MiB | |
innodb/innodb_temp_file | 1541 | 1.36 s | 0 ps | 882.23 us | 33.53 ms | 0 | 0 bytes | 0 bytes | 1425 | 26.39 MiB | 18.96 KiB | 26.39 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 | 948 | 4.99 s | 234.43 ns | 5.26 ms | 46.66 ms | 8 | 69.00 KiB | 8.62 KiB | 559 | 525.00 KiB | 962 bytes | 594.00 KiB | |
sql/binlog | 667 | 186.15 ms | 0 ps | 279.09 us | 19.03 ms | 168 | 100.26 KiB | 611 bytes | 12 | 2.80 KiB | 239 bytes | 103.06 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 |
|