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 | 3935 | 4.38 s | 0 ps | 1.11 ms | 217.62 ms | 1624 | 30.25 MiB | 19.07 KiB | 1524 | 55.17 MiB | 37.07 KiB | 85.42 MiB | |
sql/io_cache | 308 | 80.95 ms | 0 ps | 262.81 us | 53.18 ms | 142 | 7.12 MiB | 51.36 KiB | 126 | 7.12 MiB | 57.89 KiB | 14.25 MiB | |
innodb/innodb_temp_file | 443 | 1.20 s | 0 ps | 2.72 ms | 136.13 ms | 0 | 0 bytes | 0 bytes | 352 | 8.06 MiB | 23.45 KiB | 8.06 MiB | |
sql/ERRMSG | 60 | 45.32 ms | 3.06 us | 755.39 us | 7.06 ms | 36 | 3.52 MiB | 100.00 KiB | 0 | 0 bytes | 0 bytes | 3.52 MiB | |
innodb/innodb_log_file | 2101 | 9.79 s | 230.74 ns | 4.66 ms | 174.70 ms | 8 | 69.00 KiB | 8.62 KiB | 1425 | 2.30 MiB | 1.65 KiB | 2.37 MiB | |
myisam/dfile | 8318 | 6.50 ms | 0 ps | 781.18 ns | 1.08 ms | 7302 | 481.34 KiB | 68 bytes | 0 | 0 bytes | 0 bytes | 481.34 KiB | |
mysys/charset | 3 | 297.99 us | 2.68 us | 99.33 us | 283.51 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 1757 | 613.25 ms | 0 ps | 349.03 us | 22.91 ms | 416 | 2.21 KiB | 5 bytes | 43 | 8.63 KiB | 206 bytes | 10.84 KiB | |
myisam/kfile | 24 | 4.87 ms | 0 ps | 202.98 us | 2.66 ms | 8 | 1.66 KiB | 213 bytes | 0 | 0 bytes | 0 bytes | 1.66 KiB | |
sql/binlog_index | 38 | 51.84 ms | 0 ps | 1.36 ms | 26.88 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
csv/metadata | 8 | 10.52 ms | 1.85 us | 1.31 ms | 7.97 ms | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 70 bytes | |
mysys/cnf | 5 | 1.69 ms | 219.12 ns | 337.64 us | 1.67 ms | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 52.69 us | 2.97 us | 17.56 us | 41.35 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 916.43 us | 0 ps | 61.10 us | 856.62 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 4 | 71.92 us | 0 ps | 17.98 us | 34.81 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 4 | 613.70 us | 0 ps | 153.42 us | 481.81 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|