SELECT * FROM `io_by_thread_by_latency`
|
user | total | total_latency | min_latency | avg_latency | max_latency | thread_id | processlist_id | |
---|---|---|---|---|---|---|---|---|
log_flusher_thread | 1605 | 22.63 s | 49.84 us | 14.10 ms | 192.61 ms | 18 | NULL | |
page_flush_coordinator_thread | 3927 | 4.61 s | 3.44 us | 613.32 us | 157.58 ms | 13 | NULL | |
io_write_thread | 259 | 2.49 s | 148.33 us | 9.62 ms | 33.37 ms | 9 | NULL | |
log_checkpointer_thread | 276 | 1.91 s | 6.17 us | 6.90 ms | 33.00 ms | 15 | NULL | |
io_write_thread | 135 | 1.38 s | 435.71 us | 10.21 ms | 33.47 ms | 10 | NULL | |
io_write_thread | 113 | 1.17 s | 1.55 ms | 10.37 ms | 32.97 ms | 11 | NULL | |
log_writer_thread | 2907 | 945.32 ms | 471.50 ns | 325.19 us | 100.63 ms | 20 | NULL | |
io_write_thread | 38 | 450.09 ms | 1.53 ms | 11.84 ms | 26.38 ms | 12 | NULL | |
main | 149 | 111.98 ms | 152.59 ns | 453.74 us | 27.45 ms | 1 | NULL | |
srv_purge_thread | 3 | 3.84 ms | 276.41 us | 1.28 ms | 3.28 ms | 36 | NULL | |
srv_worker_thread | 1 | 1.98 ms | 1.98 ms | 1.98 ms | 1.98 ms | 40 | NULL | |
srv_worker_thread | 2 | 1.94 ms | 12.82 us | 969.98 us | 1.93 ms | 42 | NULL | |
clone_gtid_thread | 5 | 1.02 ms | 12.71 us | 204.77 us | 361.34 us | 35 | NULL | |
io_read_thread | 24 | 715.75 us | 12.24 us | 29.82 us | 47.80 us | 5 | NULL | |
srv_worker_thread | 3 | 59.54 us | 13.22 us | 19.85 us | 30.33 us | 38 | NULL |
|