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 | 3348 | 5.71 s | 0 ps | 1.71 ms | 386.06 ms | 1534 | 28.84 MiB | 19.25 KiB | 1189 | 44.14 MiB | 38.02 KiB | 72.98 MiB | |
sql/io_cache | 138 | 3.60 ms | 0 ps | 26.10 us | 635.53 us | 64 | 3.09 MiB | 49.42 KiB | 54 | 3.09 MiB | 58.57 KiB | 6.18 MiB | |
sql/ERRMSG | 70 | 49.78 ms | 2.92 us | 711.21 us | 3.46 ms | 42 | 4.10 MiB | 100.02 KiB | 0 | 0 bytes | 0 bytes | 4.10 MiB | |
innodb/innodb_temp_file | 202 | 642.93 ms | 0 ps | 3.18 ms | 35.15 ms | 0 | 0 bytes | 0 bytes | 134 | 3.22 MiB | 24.60 KiB | 3.22 MiB | |
innodb/innodb_log_file | 991 | 6.05 s | 230.74 ns | 6.10 ms | 107.04 ms | 8 | 69.00 KiB | 8.62 KiB | 572 | 493.00 KiB | 883 bytes | 562.00 KiB | |
mysys/charset | 3 | 258.32 us | 1.47 us | 86.11 us | 244.88 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
myisam/dfile | 111 | 2.06 ms | 177.94 ns | 18.56 us | 1.73 ms | 100 | 6.54 KiB | 67 bytes | 0 | 0 bytes | 0 bytes | 6.54 KiB | |
sql/binlog | 561 | 256.19 ms | 0 ps | 456.66 us | 29.12 ms | 130 | 1.09 KiB | 9 bytes | 17 | 4.16 KiB | 251 bytes | 5.25 KiB | |
myisam/kfile | 8 | 855.29 us | 586.61 ns | 106.91 us | 545.40 us | 4 | 799 bytes | 200 bytes | 0 | 0 bytes | 0 bytes | 799 bytes | |
sql/binlog_index | 38 | 67.46 ms | 0 ps | 1.78 ms | 33.16 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
mysys/cnf | 5 | 816.22 us | 208.56 ns | 163.24 us | 800.89 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 58.25 us | 3.14 us | 19.42 us | 34.27 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 1.17 ms | 0 ps | 77.75 us | 1.10 ms | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 3 | 281.74 us | 0 ps | 93.91 us | 254.61 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|