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 | 604 | 3.41 s | 5.65 ms | 113.22 ms | 1.60 ms | 179.78 ms | 3.23 s | 8 | 69.00 KiB | 8.62 KiB | 359 | 338.00 KiB | 964 bytes | |
innodb/innodb_data_file | 2453 | 1.69 s | 690.84 us | 241.35 ms | 210.19 ms | 39.51 ms | 1.44 s | 1414 | 26.97 MiB | 19.53 KiB | 760 | 32.52 MiB | 43.81 KiB | |
innodb/innodb_temp_file | 108 | 501.10 ms | 4.64 ms | 27.98 ms | 0 ps | 3.42 ms | 497.67 ms | 0 | 0 bytes | 0 bytes | 42 | 1.66 MiB | 40.38 KiB | |
sql/binlog | 239 | 103.14 ms | 431.57 us | 17.27 ms | 1.59 ms | 868.92 us | 100.69 ms | 54 | 812 bytes | 15 bytes | 8 | 1.33 KiB | 171 bytes | |
sql/binlog_index | 38 | 59.07 ms | 1.55 ms | 41.43 ms | 686.17 us | 0 ps | 58.38 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | |
sql/ERRMSG | 80 | 47.30 ms | 591.21 us | 5.97 ms | 26.14 ms | 0 ps | 21.16 ms | 48 | 4.68 MiB | 99.80 KiB | 0 | 0 bytes | 0 bytes | |
csv/data | 6 | 2.00 ms | 332.78 us | 1.94 ms | 33.25 us | 0 ps | 1.96 ms | 1 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
sql/misc | 3 | 1.77 ms | 589.00 us | 1.74 ms | 0 ps | 0 ps | 1.77 ms | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
sql/casetest | 15 | 1.11 ms | 74.11 us | 1.05 ms | 0 ps | 0 ps | 1.11 ms | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
mysys/cnf | 5 | 1.06 ms | 211.75 us | 1.04 ms | 1.04 ms | 0 ps | 16.85 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | |
csv/metadata | 8 | 792.77 us | 99.10 us | 385.66 us | 614.71 us | 0 ps | 178.07 us | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | |
mysys/charset | 3 | 319.57 us | 106.52 us | 305.06 us | 305.06 us | 0 ps | 14.51 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | |
sql/pid | 3 | 20.33 us | 6.78 us | 16.43 us | 0 ps | 2.84 us | 17.48 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes |
|