SELECT * FROM `io_by_thread_by_latency`
|
user | total | total_latency | min_latency | avg_latency | max_latency | thread_id | processlist_id | |
---|---|---|---|---|---|---|---|---|
log_flusher_thread | 2281 | 31.21 s | 48.50 us | 13.68 ms | 192.61 ms | 18 | NULL | |
page_flush_coordinator_thread | 5213 | 5.56 s | 3.44 us | 580.20 us | 157.58 ms | 13 | NULL | |
io_write_thread | 288 | 2.75 s | 148.33 us | 9.53 ms | 33.37 ms | 9 | NULL | |
log_checkpointer_thread | 306 | 2.11 s | 6.17 us | 6.89 ms | 33.00 ms | 15 | NULL | |
io_write_thread | 164 | 1.64 s | 435.71 us | 9.98 ms | 33.47 ms | 10 | NULL | |
io_write_thread | 139 | 1.46 s | 1.55 ms | 10.53 ms | 32.97 ms | 11 | NULL | |
log_writer_thread | 4139 | 1.26 s | 471.50 ns | 303.46 us | 100.63 ms | 20 | NULL | |
io_write_thread | 60 | 658.11 ms | 1.53 ms | 10.97 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 | 5 | 4.44 ms | 276.41 us | 887.57 us | 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 | |
dict_stats_thread | 1 | 986.42 us | 986.42 us | 986.42 us | 986.42 us | 26 | 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 |
|