SELECT * FROM `io_global_by_wait_by_latency`
|
event_name | total | total_latency | avg_latency | max_latency | read_latency | write_latency | misc_latency | count_read | total_read | avg_read | count_write | total_written | avg_written | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
innodb/innodb_log_file | 249 | 2.16 s | 8.68 ms | 302.08 ms | 1.93 ms | 385.45 ms | 1.77 s | 8 | 69.00 KiB | 8.62 KiB | 148 | 133.00 KiB | 920 bytes | |
sql/io_cache | 256 | 622.52 ms | 2.43 ms | 239.27 ms | 1.12 ms | 9.45 ms | 611.95 ms | 86 | 6.01 MiB | 71.59 KiB | 110 | 6.01 MiB | 55.97 KiB | |
innodb/innodb_data_file | 1544 | 577.00 ms | 373.70 us | 232.23 ms | 206.48 ms | 16.94 ms | 353.58 ms | 1209 | 23.77 MiB | 20.13 KiB | 160 | 14.52 MiB | 92.90 KiB | |
innodb/innodb_temp_file | 190 | 563.64 ms | 2.97 ms | 43.17 ms | 0 ps | 3.55 ms | 560.09 ms | 0 | 0 bytes | 0 bytes | 124 | 2.94 MiB | 24.26 KiB | |
sql/binlog_index | 38 | 54.31 ms | 1.43 ms | 29.43 ms | 2.33 ms | 0 ps | 51.98 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | |
sql/binlog | 41 | 39.69 ms | 968.14 us | 18.66 ms | 1.31 ms | 86.28 us | 38.30 ms | 7 | 624 bytes | 89 bytes | 3 | 156 bytes | 52 bytes | |
mysys/cnf | 5 | 6.61 ms | 1.32 ms | 6.59 ms | 6.59 ms | 0 ps | 21.49 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | |
myisam/kfile | 4 | 1.77 ms | 441.60 us | 1.72 ms | 1.72 ms | 0 ps | 45.43 us | 2 | 392 bytes | 196 bytes | 0 | 0 bytes | 0 bytes | |
sql/ERRMSG | 5 | 1.41 ms | 281.78 us | 501.82 us | 1.16 ms | 0 ps | 250.05 us | 3 | 296.39 KiB | 98.80 KiB | 0 | 0 bytes | 0 bytes | |
sql/casetest | 15 | 958.09 us | 63.87 us | 896.55 us | 0 ps | 0 ps | 958.09 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
mysys/charset | 3 | 292.61 us | 97.54 us | 278.14 us | 278.14 us | 0 ps | 14.47 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | |
sql/pid | 3 | 49.90 us | 16.63 us | 39.18 us | 0 ps | 7.55 us | 42.35 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | |
myisam/dfile | 4 | 46.21 us | 11.55 us | 24.09 us | 0 ps | 0 ps | 46.21 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
sql/misc | 1 | 11.52 us | 11.52 us | 11.52 us | 0 ps | 0 ps | 11.52 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes |
|