SELECT * FROM `io_by_thread_by_latency`
|
user | total | total_latency | min_latency | avg_latency | max_latency | thread_id | processlist_id | |
---|---|---|---|---|---|---|---|---|
log_flusher_thread | 98 | 1.39 s | 85.76 us | 14.22 ms | 40.41 ms | 18 | NULL | |
io_write_thread | 57 | 538.53 ms | 1.67 ms | 9.45 ms | 19.61 ms | 9 | NULL | |
page_flush_coordinator_thread | 384 | 474.11 ms | 4.38 us | 649.21 us | 35.32 ms | 13 | NULL | |
log_checkpointer_thread | 40 | 275.24 ms | 8.20 us | 6.88 ms | 20.09 ms | 15 | NULL | |
main | 149 | 103.25 ms | 74.98 ns | 408.49 us | 31.03 ms | 1 | NULL | |
io_write_thread | 5 | 66.95 ms | 104.08 us | 13.39 ms | 26.35 ms | 11 | NULL | |
io_write_thread | 4 | 40.00 ms | 5.77 ms | 10.00 ms | 14.25 ms | 12 | NULL | |
log_writer_thread | 150 | 30.42 ms | 703.30 ns | 202.77 us | 8.37 ms | 20 | NULL | |
io_write_thread | 3 | 18.76 ms | 1.66 ms | 6.25 ms | 11.15 ms | 10 | NULL | |
root@192.168.30.20 | 1 | 1.93 ms | 1.93 ms | 1.93 ms | 1.93 ms | 944 | 880 | |
clone_gtid_thread | 5 | 721.27 us | 5.85 us | 144.25 us | 326.06 us | 35 | NULL | |
srv_worker_thread | 3 | 296.75 us | 8.63 us | 98.92 us | 276.09 us | 42 | NULL | |
srv_purge_thread | 1 | 158.45 us | 158.45 us | 158.45 us | 158.45 us | 36 | NULL | |
srv_worker_thread | 2 | 37.69 us | 15.43 us | 18.85 us | 22.26 us | 38 | NULL |
|