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 | 3374 | 2.51 s | 0 ps | 743.16 us | 62.77 ms | 1464 | 28.22 MiB | 19.74 KiB | 1489 | 54.70 MiB | 37.62 KiB | 82.92 MiB | |
innodb/innodb_temp_file | 457 | 761.76 ms | 0 ps | 1.67 ms | 80.44 ms | 0 | 0 bytes | 0 bytes | 372 | 8.00 MiB | 22.02 KiB | 8.00 MiB | |
sql/ERRMSG | 55 | 36.52 ms | 2.76 us | 664.00 us | 9.59 ms | 33 | 3.23 MiB | 100.24 KiB | 0 | 0 bytes | 0 bytes | 3.23 MiB | |
innodb/innodb_log_file | 1290 | 6.43 s | 305.18 ns | 4.98 ms | 47.63 ms | 8 | 69.00 KiB | 8.62 KiB | 782 | 710.50 KiB | 930 bytes | 779.50 KiB | |
sql/binlog | 527 | 310.03 ms | 0 ps | 588.29 us | 29.93 ms | 120 | 9.27 KiB | 79 bytes | 28 | 97.53 KiB | 3.48 KiB | 106.80 KiB | |
myisam/dfile | 4033 | 6.62 ms | 243.41 ns | 1.64 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 |
|