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 | 2001 | 1.61 s | 0 ps | 803.50 us | 219.47 ms | 1225 | 24.02 MiB | 20.08 KiB | 524 | 25.27 MiB | 49.37 KiB | 49.28 MiB | |
sql/io_cache | 382 | 34.87 ms | 0 ps | 91.27 us | 11.41 ms | 123 | 8.59 MiB | 71.52 KiB | 164 | 8.59 MiB | 53.64 KiB | 17.18 MiB | |
innodb/innodb_temp_file | 325 | 1.57 s | 0 ps | 4.83 ms | 521.34 ms | 0 | 0 bytes | 0 bytes | 254 | 5.28 MiB | 21.29 KiB | 5.28 MiB | |
sql/ERRMSG | 30 | 16.46 ms | 2.84 us | 548.57 us | 2.05 ms | 18 | 1.75 MiB | 99.62 KiB | 0 | 0 bytes | 0 bytes | 1.75 MiB | |
innodb/innodb_log_file | 357 | 1.99 s | 252.38 ns | 5.59 ms | 88.29 ms | 8 | 69.00 KiB | 8.62 KiB | 207 | 180.50 KiB | 893 bytes | 249.50 KiB | |
mysys/charset | 3 | 249.02 us | 1.66 us | 83.01 us | 224.36 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 83 | 72.68 ms | 0 ps | 875.67 us | 24.28 ms | 17 | 664 bytes | 39 bytes | 4 | 394 bytes | 98 bytes | 1.03 KiB | |
myisam/kfile | 4 | 224.87 us | 838.99 ns | 56.22 us | 210.12 us | 2 | 392 bytes | 196 bytes | 0 | 0 bytes | 0 bytes | 392 bytes | |
sql/binlog_index | 38 | 47.29 ms | 0 ps | 1.24 ms | 28.80 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
mysys/cnf | 5 | 1.93 ms | 212.78 ns | 386.78 us | 1.91 ms | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 55.86 us | 3.15 us | 18.62 us | 35.92 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 1.03 ms | 0 ps | 68.85 us | 974.44 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 2 | 40.51 us | 0 ps | 20.25 us | 30.48 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
myisam/dfile | 2 | 6.68 us | 317.33 ns | 3.34 us | 6.36 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|