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 | 2522 | 1.85 s | 0 ps | 734.72 us | 212.11 ms | 1550 | 29.09 MiB | 19.22 KiB | 686 | 30.27 MiB | 45.18 KiB | 59.36 MiB | |
innodb/innodb_temp_file | 438 | 1.22 s | 0 ps | 2.78 ms | 523.08 ms | 0 | 0 bytes | 0 bytes | 361 | 7.33 MiB | 20.79 KiB | 7.33 MiB | |
sql/ERRMSG | 55 | 35.14 ms | 2.97 us | 638.86 us | 5.76 ms | 33 | 3.23 MiB | 100.09 KiB | 0 | 0 bytes | 0 bytes | 3.23 MiB | |
innodb/innodb_log_file | 621 | 4.46 s | 233.90 ns | 7.18 ms | 606.31 ms | 8 | 69.00 KiB | 8.62 KiB | 364 | 290.50 KiB | 817 bytes | 359.50 KiB | |
mysys/charset | 3 | 194.31 us | 1.45 us | 64.77 us | 180.99 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 184 | 60.33 ms | 0 ps | 327.90 us | 15.82 ms | 43 | 915 bytes | 21 bytes | 4 | 426 bytes | 106 bytes | 1.31 KiB | |
myisam/kfile | 8 | 1.18 ms | 679.01 ns | 147.84 us | 646.83 us | 4 | 834 bytes | 208 bytes | 0 | 0 bytes | 0 bytes | 834 bytes | |
sql/binlog_index | 38 | 51.09 ms | 0 ps | 1.34 ms | 33.56 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
mysys/cnf | 5 | 1.33 ms | 163.68 ns | 265.84 us | 1.31 ms | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
csv/metadata | 4 | 501.49 us | 720.19 ns | 125.37 us | 435.77 us | 1 | 35 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 35 bytes | |
sql/pid | 3 | 14.64 us | 619.87 ns | 4.88 us | 12.22 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 853.15 us | 0 ps | 56.88 us | 783.24 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 2 | 14.16 us | 0 ps | 7.08 us | 9.90 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 2 | 19.06 us | 0 ps | 9.53 us | 13.04 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
myisam/dfile | 4 | 17.39 us | 368.54 ns | 4.35 us | 9.47 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|