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 | 4020 | 3.34 s | 0 ps | 829.99 us | 80.88 ms | 1479 | 28.45 MiB | 19.70 KiB | 2040 | 71.39 MiB | 35.84 KiB | 99.84 MiB | |
innodb/innodb_temp_file | 614 | 1.02 s | 0 ps | 1.66 ms | 80.44 ms | 0 | 0 bytes | 0 bytes | 514 | 11.16 MiB | 22.23 KiB | 11.16 MiB | |
sql/io_cache | 102 | 58.57 ms | 0 ps | 574.21 us | 44.97 ms | 50 | 2.05 MiB | 41.99 KiB | 38 | 2.05 MiB | 55.25 KiB | 4.10 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 | 1730 | 8.47 s | 305.18 ns | 4.90 ms | 47.63 ms | 8 | 69.00 KiB | 8.62 KiB | 1053 | 930.50 KiB | 905 bytes | 999.50 KiB | |
sql/binlog | 761 | 352.73 ms | 0 ps | 463.51 us | 29.93 ms | 177 | 9.49 KiB | 55 bytes | 31 | 98.55 KiB | 3.18 KiB | 108.04 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/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 | 3 | 29.35 us | 0 ps | 9.78 us | 13.47 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|