SELECT * FROM `io_by_thread_by_latency`
|
user | total | total_latency | min_latency | avg_latency | max_latency | thread_id | processlist_id | |
---|---|---|---|---|---|---|---|---|
log_flusher_thread | 1978 | 26.25 s | 40.08 us | 13.27 ms | 181.18 ms | 18 | NULL | |
page_flush_coordinator_thread | 5201 | 5.64 s | 3.44 us | 732.80 us | 651.16 ms | 13 | NULL | |
io_write_thread | 309 | 3.16 s | 90.98 us | 10.22 ms | 49.25 ms | 9 | NULL | |
log_checkpointer_thread | 231 | 1.43 s | 6.38 us | 7.52 ms | 25.69 ms | 15 | NULL | |
io_write_thread | 112 | 1.14 s | 147.78 us | 10.14 ms | 27.04 ms | 10 | NULL | |
log_writer_thread | 3830 | 962.18 ms | 476.78 ns | 251.22 us | 23.94 ms | 20 | NULL | |
io_write_thread | 70 | 796.57 ms | 117.31 us | 11.38 ms | 43.59 ms | 11 | NULL | |
io_write_thread | 39 | 500.74 ms | 2.43 ms | 12.84 ms | 25.07 ms | 12 | NULL | |
root@192.168.30.20 | 38 | 187.29 ms | 1.40 us | 5.94 ms | 27.82 ms | 8755 | 8099 | |
main | 151 | 105.62 ms | 81.31 ns | 445.43 us | 25.84 ms | 1 | NULL | |
srv_purge_thread | 2 | 5.09 ms | 270.96 us | 2.55 ms | 4.82 ms | 36 | NULL | |
clone_gtid_thread | 4 | 738.21 us | 11.14 us | 184.55 us | 367.15 us | 35 | NULL | |
srv_worker_thread | 3 | 352.56 us | 9.73 us | 117.52 us | 329.74 us | 38 | NULL | |
io_read_thread | 1 | 40.47 us | 40.47 us | 40.47 us | 40.47 us | 5 | NULL | |
srv_worker_thread | 2 | 39.57 us | 9.00 us | 19.79 us | 30.57 us | 42 | NULL |
|