SELECT * FROM `io_by_thread_by_latency`
|
user | total | total_latency | min_latency | avg_latency | max_latency | thread_id | processlist_id | |
---|---|---|---|---|---|---|---|---|
log_flusher_thread | 130 | 1.57 s | 106.71 us | 12.11 ms | 31.70 ms | 18 | NULL | |
page_flush_coordinator_thread | 745 | 1.03 s | 3.82 us | 1.99 ms | 283.30 ms | 13 | NULL | |
io_write_thread | 44 | 384.20 ms | 1.56 ms | 8.73 ms | 22.25 ms | 9 | NULL | |
log_checkpointer_thread | 36 | 223.75 ms | 8.55 us | 6.22 ms | 17.71 ms | 15 | NULL | |
main | 148 | 101.67 ms | 89.76 ns | 397.97 us | 28.89 ms | 1 | NULL | |
io_write_thread | 12 | 101.52 ms | 1.55 ms | 8.46 ms | 18.36 ms | 11 | NULL | |
io_write_thread | 8 | 86.76 ms | 1.60 ms | 10.85 ms | 27.35 ms | 12 | NULL | |
io_write_thread | 4 | 38.51 ms | 3.93 ms | 9.63 ms | 14.61 ms | 10 | NULL | |
log_writer_thread | 203 | 33.41 ms | 592.42 ns | 164.56 us | 7.68 ms | 20 | NULL | |
srv_purge_thread | 2 | 3.89 ms | 163.97 us | 1.95 ms | 3.73 ms | 36 | NULL | |
clone_gtid_thread | 5 | 822.03 us | 5.79 us | 164.41 us | 317.33 us | 35 | NULL | |
srv_worker_thread | 1 | 559.00 us | 559.00 us | 559.00 us | 559.00 us | 40 | NULL | |
root@192.168.30.20 | 1 | 355.60 us | 355.60 us | 355.60 us | 355.60 us | 1706 | 1646 | |
io_read_thread | 7 | 193.86 us | 21.31 us | 27.69 us | 47.96 us | 5 | NULL | |
srv_worker_thread | 2 | 128.16 us | 9.36 us | 64.08 us | 118.80 us | 38 | NULL | |
srv_worker_thread | 2 | 37.30 us | 13.91 us | 18.65 us | 23.39 us | 42 | NULL |
|