SELECT * FROM `io_by_thread_by_latency`
|
user | total | total_latency | min_latency | avg_latency | max_latency | thread_id | processlist_id | |
---|---|---|---|---|---|---|---|---|
log_flusher_thread | 115 | 1.74 s | 104.39 us | 15.10 ms | 283.31 ms | 18 | NULL | |
page_flush_coordinator_thread | 892 | 915.05 ms | 3.58 us | 899.42 us | 133.00 ms | 13 | NULL | |
io_write_thread | 71 | 697.18 ms | 1.52 ms | 9.82 ms | 42.60 ms | 9 | NULL | |
log_checkpointer_thread | 59 | 422.50 ms | 10.25 us | 10.45 ms | 28.28 ms | 15 | NULL | |
io_write_thread | 18 | 160.81 ms | 1.68 ms | 8.93 ms | 23.73 ms | 10 | NULL | |
main | 148 | 137.84 ms | 90.82 ns | 524.15 us | 42.67 ms | 1 | NULL | |
io_write_thread | 11 | 110.16 ms | 1.54 ms | 10.01 ms | 18.07 ms | 11 | NULL | |
log_writer_thread | 166 | 17.66 ms | 689.04 ns | 106.38 us | 4.41 ms | 20 | NULL | |
srv_worker_thread | 1 | 1.93 ms | 1.93 ms | 1.93 ms | 1.93 ms | 42 | NULL | |
clone_gtid_thread | 5 | 786.98 us | 6.68 us | 157.40 us | 337.88 us | 35 | NULL | |
srv_purge_thread | 2 | 503.95 us | 146.34 us | 251.98 us | 357.61 us | 36 | NULL | |
root@192.168.30.20 | 1 | 302.96 us | 302.96 us | 302.96 us | 302.96 us | 2236 | 2168 | |
srv_worker_thread | 1 | 8.41 us | 8.41 us | 8.41 us | 8.41 us | 38 | NULL |
|