SELECT * FROM `io_by_thread_by_latency`
|
user | total | total_latency | min_latency | avg_latency | max_latency | thread_id | processlist_id | |
---|---|---|---|---|---|---|---|---|
log_flusher_thread | 3937 | 46.96 s | 45.64 us | 11.93 ms | 229.81 ms | 18 | NULL | |
page_flush_coordinator_thread | 7083 | 5.77 s | 3.46 us | 441.28 us | 239.72 ms | 13 | NULL | |
io_write_thread | 318 | 2.68 s | 99.84 us | 8.42 ms | 61.84 ms | 9 | NULL | |
io_write_thread | 218 | 2.10 s | 135.32 us | 9.64 ms | 91.77 ms | 10 | NULL | |
log_writer_thread | 7606 | 1.70 s | 460.94 ns | 223.04 us | 99.21 ms | 20 | NULL | |
log_checkpointer_thread | 297 | 1.66 s | 7.12 us | 4.71 ms | 24.28 ms | 15 | NULL | |
io_write_thread | 100 | 892.29 ms | 1.47 ms | 8.92 ms | 27.31 ms | 11 | NULL | |
io_write_thread | 75 | 748.41 ms | 1.49 ms | 9.98 ms | 29.68 ms | 12 | NULL | |
main | 151 | 108.81 ms | 90.29 ns | 432.31 us | 31.70 ms | 1 | NULL | |
srv_purge_thread | 4 | 6.61 ms | 241.90 us | 1.65 ms | 4.07 ms | 36 | NULL | |
srv_worker_thread | 2 | 1.69 ms | 22.93 us | 846.69 us | 1.67 ms | 42 | NULL | |
clone_gtid_thread | 4 | 554.42 us | 6.94 us | 138.60 us | 277.53 us | 35 | NULL | |
srv_worker_thread | 1 | 324.09 us | 324.09 us | 324.09 us | 324.09 us | 40 | NULL | |
srv_worker_thread | 2 | 26.12 us | 8.97 us | 13.06 us | 17.15 us | 38 | NULL |
|