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 | 3266 | 5.17 s | 0 ps | 1.58 ms | 238.94 ms | 1487 | 28.11 MiB | 19.36 KiB | 1151 | 42.98 MiB | 38.24 KiB | 71.09 MiB | |
innodb/innodb_temp_file | 298 | 2.26 s | 0 ps | 7.58 ms | 372.99 ms | 0 | 0 bytes | 0 bytes | 199 | 6.17 MiB | 31.76 KiB | 6.17 MiB | |
sql/io_cache | 122 | 7.28 ms | 0 ps | 59.68 us | 3.22 ms | 50 | 2.84 MiB | 58.15 KiB | 52 | 2.84 MiB | 55.92 KiB | 5.68 MiB | |
sql/ERRMSG | 75 | 48.73 ms | 2.83 us | 649.77 us | 4.99 ms | 45 | 4.39 MiB | 100.00 KiB | 0 | 0 bytes | 0 bytes | 4.39 MiB | |
innodb/innodb_log_file | 1025 | 6.45 s | 228.10 ns | 6.29 ms | 131.62 ms | 8 | 69.00 KiB | 8.62 KiB | 584 | 461.50 KiB | 809 bytes | 530.50 KiB | |
mysys/charset | 3 | 279.97 us | 2.32 us | 93.32 us | 267.60 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 445 | 105.17 ms | 0 ps | 236.33 us | 23.86 ms | 106 | 1020 bytes | 10 bytes | 7 | 1.19 KiB | 173 bytes | 2.18 KiB | |
myisam/dfile | 36 | 539.08 us | 259.78 ns | 14.97 us | 467.88 us | 25 | 975 bytes | 39 bytes | 0 | 0 bytes | 0 bytes | 975 bytes | |
myisam/kfile | 8 | 399.18 us | 506.88 ns | 49.90 us | 234.41 us | 4 | 869 bytes | 217 bytes | 0 | 0 bytes | 0 bytes | 869 bytes | |
sql/binlog_index | 38 | 54.06 ms | 0 ps | 1.42 ms | 25.64 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
csv/metadata | 8 | 723.01 us | 593.47 ns | 90.38 us | 319.89 us | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 70 bytes | |
mysys/cnf | 5 | 704.85 us | 180.58 ns | 140.97 us | 686.38 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 64.19 us | 2.96 us | 21.40 us | 53.78 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 789.15 us | 0 ps | 52.61 us | 711.58 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 2 | 289.66 us | 0 ps | 144.83 us | 273.44 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 16 | 886.00 us | 0 ps | 55.37 us | 482.43 us | 5 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|