SELECT * FROM `io_by_thread_by_latency`
|
user | total | total_latency | min_latency | avg_latency | max_latency | thread_id | processlist_id | |
---|---|---|---|---|---|---|---|---|
log_flusher_thread | 171 | 2.56 s | 92.59 us | 14.97 ms | 158.90 ms | 18 | NULL | |
io_write_thread | 49 | 531.75 ms | 2.07 ms | 10.85 ms | 27.14 ms | 9 | NULL | |
page_flush_coordinator_thread | 691 | 427.58 ms | 3.61 us | 471.84 us | 49.06 ms | 13 | NULL | |
log_checkpointer_thread | 34 | 251.33 ms | 9.56 us | 7.39 ms | 19.87 ms | 15 | NULL | |
log_writer_thread | 256 | 237.13 ms | 489.98 ns | 926.30 us | 87.26 ms | 20 | NULL | |
io_write_thread | 12 | 129.85 ms | 2.16 ms | 10.82 ms | 15.65 ms | 10 | NULL | |
main | 149 | 102.03 ms | 76.03 ns | 398.81 us | 45.73 ms | 1 | NULL | |
io_write_thread | 4 | 81.31 ms | 92.77 us | 20.33 ms | 79.67 ms | 12 | NULL | |
io_write_thread | 4 | 33.81 ms | 4.50 ms | 8.45 ms | 12.27 ms | 11 | NULL | |
srv_purge_thread | 2 | 5.71 ms | 182.03 us | 2.86 ms | 5.53 ms | 36 | NULL | |
srv_worker_thread | 2 | 1.23 ms | 242.03 us | 615.96 us | 989.89 us | 40 | NULL | |
clone_gtid_thread | 5 | 656.98 us | 5.06 us | 131.39 us | 221.39 us | 35 | NULL | |
srv_worker_thread | 3 | 323.69 us | 9.95 us | 107.90 us | 157.63 us | 38 | NULL | |
srv_worker_thread | 2 | 26.41 us | 7.53 us | 13.21 us | 18.88 us | 42 | NULL |
|