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 | 2961 | 4.17 s | 0 ps | 1.41 ms | 205.81 ms | 1420 | 27.06 MiB | 19.52 KiB | 1041 | 40.17 MiB | 39.52 KiB | 67.23 MiB | |
sql/ERRMSG | 55 | 37.56 ms | 3.07 us | 682.94 us | 4.53 ms | 33 | 3.23 MiB | 100.10 KiB | 0 | 0 bytes | 0 bytes | 3.23 MiB | |
innodb/innodb_temp_file | 148 | 751.64 ms | 0 ps | 5.08 ms | 36.32 ms | 0 | 0 bytes | 0 bytes | 68 | 2.94 MiB | 44.24 KiB | 2.94 MiB | |
innodb/innodb_log_file | 837 | 5.07 s | 252.91 ns | 6.06 ms | 91.32 ms | 8 | 69.00 KiB | 8.62 KiB | 485 | 436.50 KiB | 922 bytes | 505.50 KiB | |
mysys/charset | 3 | 228.54 us | 2.00 us | 76.18 us | 213.91 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 685 | 374.06 ms | 0 ps | 546.08 us | 43.58 ms | 159 | 1.20 KiB | 8 bytes | 21 | 5.96 KiB | 291 bytes | 7.16 KiB | |
myisam/kfile | 8 | 1.44 ms | 659.47 ns | 180.48 us | 725.30 us | 4 | 849 bytes | 212 bytes | 0 | 0 bytes | 0 bytes | 849 bytes | |
sql/binlog_index | 38 | 58.77 ms | 0 ps | 1.55 ms | 41.79 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
mysys/cnf | 5 | 476.65 us | 172.66 ns | 95.33 us | 455.26 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
csv/metadata | 4 | 493.16 us | 683.23 ns | 123.29 us | 442.19 us | 1 | 35 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 35 bytes | |
sql/pid | 3 | 11.47 us | 638.35 ns | 3.82 us | 9.13 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 722.08 us | 0 ps | 48.14 us | 659.03 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 6 | 99.68 us | 0 ps | 16.61 us | 33.66 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 2 | 239.10 us | 0 ps | 119.55 us | 230.32 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
myisam/dfile | 6 | 31.82 us | 347.95 ns | 5.30 us | 19.96 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|