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 | 2995 | 3.20 s | 0 ps | 1.07 ms | 216.02 ms | 1470 | 27.84 MiB | 19.40 KiB | 1119 | 42.95 MiB | 39.31 KiB | 70.80 MiB | |
innodb/innodb_temp_file | 533 | 1.56 s | 0 ps | 2.94 ms | 506.31 ms | 0 | 0 bytes | 0 bytes | 436 | 9.75 MiB | 22.90 KiB | 9.75 MiB | |
sql/io_cache | 185 | 17.38 ms | 0 ps | 93.96 us | 7.36 ms | 93 | 4.21 MiB | 46.31 KiB | 72 | 4.21 MiB | 59.82 KiB | 8.41 MiB | |
sql/ERRMSG | 55 | 34.91 ms | 2.49 us | 634.78 us | 3.72 ms | 33 | 3.23 MiB | 100.10 KiB | 0 | 0 bytes | 0 bytes | 3.23 MiB | |
innodb/innodb_log_file | 890 | 4.82 s | 220.70 ns | 5.42 ms | 88.62 ms | 8 | 69.00 KiB | 8.62 KiB | 525 | 425.50 KiB | 830 bytes | 494.50 KiB | |
mysys/charset | 3 | 258.33 us | 1.75 us | 86.11 us | 231.95 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 299 | 83.75 ms | 0 ps | 280.09 us | 16.37 ms | 70 | 876 bytes | 13 bytes | 6 | 880 bytes | 147 bytes | 1.71 KiB | |
myisam/dfile | 31 | 324.78 us | 175.82 ns | 10.48 us | 297.26 us | 25 | 975 bytes | 39 bytes | 0 | 0 bytes | 0 bytes | 975 bytes | |
myisam/kfile | 8 | 631.33 us | 597.70 ns | 78.92 us | 298.76 us | 4 | 849 bytes | 212 bytes | 0 | 0 bytes | 0 bytes | 849 bytes | |
sql/binlog_index | 38 | 52.28 ms | 0 ps | 1.38 ms | 31.81 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
mysys/cnf | 5 | 707.31 us | 253.97 ns | 141.46 us | 682.97 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
csv/metadata | 4 | 490.24 us | 853.25 ns | 122.56 us | 423.38 us | 1 | 35 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 35 bytes | |
sql/pid | 3 | 48.77 us | 2.49 us | 16.26 us | 37.69 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 782.07 us | 0 ps | 52.14 us | 714.26 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 3 | 463.32 us | 0 ps | 154.44 us | 434.03 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 2 | 25.32 us | 0 ps | 12.66 us | 19.60 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|