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 | 2398 | 1.22 s | 0 ps | 510.82 us | 62.77 ms | 1376 | 26.84 MiB | 19.98 KiB | 721 | 31.55 MiB | 44.80 KiB | 58.39 MiB | |
innodb/innodb_temp_file | 352 | 672.37 ms | 0 ps | 1.91 ms | 80.44 ms | 0 | 0 bytes | 0 bytes | 273 | 6.08 MiB | 22.80 KiB | 6.08 MiB | |
sql/ERRMSG | 40 | 17.90 ms | 2.76 us | 447.48 us | 2.68 ms | 24 | 2.35 MiB | 100.32 KiB | 0 | 0 bytes | 0 bytes | 2.35 MiB | |
innodb/innodb_log_file | 550 | 2.81 s | 305.18 ns | 5.10 ms | 39.78 ms | 8 | 69.00 KiB | 8.62 KiB | 326 | 343.00 KiB | 1.05 KiB | 412.00 KiB | |
sql/binlog | 293 | 258.75 ms | 0 ps | 883.12 us | 29.93 ms | 63 | 9.05 KiB | 147 bytes | 25 | 96.38 KiB | 3.86 KiB | 105.43 KiB | |
myisam/dfile | 4018 | 6.55 ms | 689.04 ns | 1.63 us | 1.34 ms | 0 | 0 bytes | 0 bytes | 4003 | 101.17 KiB | 26 bytes | 101.17 KiB | |
sql/io_cache | 8 | 467.56 us | 0 ps | 58.44 us | 409.43 us | 2 | 33.56 KiB | 16.78 KiB | 2 | 33.56 KiB | 16.78 KiB | 67.12 KiB | |
sql/SDI | 15 | 8.70 ms | 2.57 us | 580.25 us | 4.77 ms | 0 | 0 bytes | 0 bytes | 5 | 19.72 KiB | 3.94 KiB | 19.72 KiB | |
mysys/charset | 3 | 329.16 us | 2.17 us | 109.72 us | 316.50 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
myisam/kfile | 87 | 18.06 ms | 331.06 ns | 207.62 us | 17.57 ms | 10 | 1.86 KiB | 190 bytes | 52 | 2.44 KiB | 48 bytes | 4.30 KiB | |
sql/binlog_index | 23 | 914.98 us | 0 ps | 39.78 us | 216.95 us | 5 | 224 bytes | 45 bytes | 0 | 0 bytes | 0 bytes | 224 bytes | |
mysys/cnf | 5 | 375.03 us | 135.70 ns | 75.01 us | 205.21 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 235.62 us | 1.41 us | 78.54 us | 229.90 us | 0 | 0 bytes | 0 bytes | 1 | 5 bytes | 5 bytes | 5 bytes | |
sql/casetest | 15 | 771.65 us | 0 ps | 51.44 us | 692.59 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 1 | 2.61 us | 0 ps | 2.61 us | 2.61 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|