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 | 3674 | 5.85 s | 0 ps | 1.59 ms | 254.26 ms | 1564 | 29.31 MiB | 19.19 KiB | 1380 | 49.39 MiB | 36.65 KiB | 78.70 MiB | |
innodb/innodb_temp_file | 453 | 2.54 s | 0 ps | 5.61 ms | 599.96 ms | 0 | 0 bytes | 0 bytes | 340 | 9.25 MiB | 27.86 KiB | 9.25 MiB | |
sql/io_cache | 184 | 6.59 ms | 0 ps | 35.82 us | 2.40 ms | 92 | 4.14 MiB | 46.10 KiB | 72 | 4.14 MiB | 58.90 KiB | 8.28 MiB | |
sql/ERRMSG | 65 | 39.45 ms | 2.73 us | 606.98 us | 4.78 ms | 39 | 3.81 MiB | 100.16 KiB | 0 | 0 bytes | 0 bytes | 3.81 MiB | |
innodb/innodb_log_file | 1154 | 6.96 s | 228.62 ns | 6.03 ms | 259.78 ms | 8 | 69.00 KiB | 8.62 KiB | 670 | 560.50 KiB | 857 bytes | 629.50 KiB | |
mysys/charset | 3 | 262.98 us | 2.07 us | 87.66 us | 251.04 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 287 | 274.06 ms | 0 ps | 954.90 us | 27.56 ms | 62 | 844 bytes | 14 bytes | 16 | 3.79 KiB | 243 bytes | 4.62 KiB | |
myisam/kfile | 4 | 509.58 us | 742.37 ns | 127.40 us | 487.88 us | 2 | 442 bytes | 221 bytes | 0 | 0 bytes | 0 bytes | 442 bytes | |
sql/binlog_index | 38 | 69.11 ms | 0 ps | 1.82 ms | 36.38 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
mysys/cnf | 5 | 517.72 us | 149.95 ns | 103.54 us | 501.35 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 52.64 us | 3.07 us | 17.55 us | 40.86 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 725.12 us | 0 ps | 48.34 us | 664.43 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 3 | 258.13 us | 0 ps | 86.04 us | 232.53 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
myisam/dfile | 4 | 38.54 us | 9.02 us | 9.64 us | 10.06 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|