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 | 3980 | 6.22 s | 0 ps | 1.56 ms | 204.02 ms | 1549 | 29.08 MiB | 19.22 KiB | 1699 | 59.11 MiB | 35.63 KiB | 88.19 MiB | |
sql/io_cache | 1390 | 69.22 ms | 0 ps | 49.80 us | 29.21 ms | 606 | 32.72 MiB | 55.30 KiB | 574 | 32.71 MiB | 58.35 KiB | 65.43 MiB | |
innodb/innodb_temp_file | 559 | 1.75 s | 0 ps | 3.13 ms | 414.50 ms | 0 | 0 bytes | 0 bytes | 450 | 10.72 MiB | 24.39 KiB | 10.72 MiB | |
sql/ERRMSG | 50 | 31.66 ms | 3.49 us | 633.14 us | 2.68 ms | 30 | 2.94 MiB | 100.46 KiB | 0 | 0 bytes | 0 bytes | 2.94 MiB | |
innodb/innodb_log_file | 1572 | 9.56 s | 239.71 ns | 6.08 ms | 466.20 ms | 8 | 69.00 KiB | 8.62 KiB | 938 | 1.03 MiB | 1.12 KiB | 1.09 MiB | |
sql/SDI | 55 | 2.23 ms | 0 ps | 40.53 us | 472.34 us | 0 | 0 bytes | 0 bytes | 14 | 61.65 KiB | 4.40 KiB | 61.65 KiB | |
mysys/charset | 3 | 233.19 us | 2.71 us | 77.73 us | 216.50 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 483 | 344.52 ms | 0 ps | 713.28 us | 22.91 ms | 108 | 1.00 KiB | 10 bytes | 22 | 5.10 KiB | 237 bytes | 6.10 KiB | |
myisam/kfile | 17 | 103.31 ms | 0 ps | 6.08 ms | 99.48 ms | 6 | 1.27 KiB | 216 bytes | 0 | 0 bytes | 0 bytes | 1.27 KiB | |
csv/metadata | 113 | 69.06 ms | 251.86 ns | 611.19 us | 17.46 ms | 15 | 525 bytes | 35 bytes | 13 | 455 bytes | 35 bytes | 980 bytes | |
sql/binlog_index | 38 | 52.59 ms | 0 ps | 1.38 ms | 35.80 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
mysys/cnf | 5 | 532.52 us | 243.41 ns | 106.50 us | 514.93 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 14.50 us | 719.14 ns | 4.83 us | 10.32 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
csv/data | 314 | 2.44 ms | 0 ps | 7.77 us | 541.11 us | 111 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 4 | 367.76 us | 0 ps | 91.94 us | 325.99 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/casetest | 15 | 888.91 us | 0 ps | 59.26 us | 805.96 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
myisam/dfile | 18 | 2.35 ms | 0 ps | 130.56 us | 2.23 ms | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|