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 | 1344 | 417.74 ms | 0 ps | 310.82 us | 67.32 ms | 1113 | 19.69 MiB | 18.11 KiB | 179 | 15.02 MiB | 85.90 KiB | 34.70 MiB | |
sql/io_cache | 46 | 959.77 us | 0 ps | 20.86 us | 88.48 us | 16 | 1.10 MiB | 70.23 KiB | 20 | 1.10 MiB | 56.18 KiB | 2.19 MiB | |
sql/ERRMSG | 30 | 15.55 ms | 2.79 us | 518.41 us | 1.92 ms | 18 | 1.74 MiB | 99.14 KiB | 0 | 0 bytes | 0 bytes | 1.74 MiB | |
innodb/innodb_temp_file | 93 | 313.18 ms | 0 ps | 3.37 ms | 31.15 ms | 0 | 0 bytes | 0 bytes | 32 | 1.19 MiB | 38.00 KiB | 1.19 MiB | |
innodb/innodb_log_file | 69 | 301.76 ms | 224.40 ns | 4.37 ms | 30.84 ms | 8 | 69.00 KiB | 8.62 KiB | 33 | 58.00 KiB | 1.76 KiB | 127.00 KiB | |
sql/binlog | 236 | 54.62 ms | 0 ps | 231.44 us | 24.35 ms | 62 | 65.85 KiB | 1.06 KiB | 4 | 388 bytes | 97 bytes | 66.23 KiB | |
mysys/charset | 3 | 445.46 us | 4.67 us | 148.49 us | 420.73 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog_index | 23 | 2.77 ms | 0 ps | 120.30 us | 1.78 ms | 5 | 224 bytes | 45 bytes | 0 | 0 bytes | 0 bytes | 224 bytes | |
mysys/cnf | 5 | 232.16 us | 430.32 ns | 46.43 us | 204.67 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 12.03 us | 568.13 ns | 4.01 us | 10.02 us | 0 | 0 bytes | 0 bytes | 1 | 5 bytes | 5 bytes | 5 bytes | |
sql/casetest | 15 | 764.66 us | 0 ps | 50.98 us | 673.68 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 2 | 37.40 us | 0 ps | 18.70 us | 27.13 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|