SELECT * FROM `io_by_thread_by_latency`
|
user | total | total_latency | min_latency | avg_latency | max_latency | thread_id | processlist_id | |
---|---|---|---|---|---|---|---|---|
log_flusher_thread | 183 | 2.62 s | 104.39 us | 14.30 ms | 283.31 ms | 18 | NULL | |
page_flush_coordinator_thread | 1178 | 1.22 s | 3.51 us | 888.15 us | 133.00 ms | 13 | NULL | |
io_write_thread | 106 | 1.00 s | 1.52 ms | 9.48 ms | 42.60 ms | 9 | NULL | |
log_checkpointer_thread | 87 | 629.12 ms | 10.25 us | 10.55 ms | 28.28 ms | 15 | NULL | |
io_write_thread | 30 | 281.81 ms | 1.61 ms | 9.39 ms | 23.73 ms | 10 | NULL | |
io_write_thread | 18 | 187.96 ms | 1.54 ms | 10.44 ms | 18.07 ms | 11 | NULL | |
main | 148 | 137.84 ms | 90.82 ns | 524.15 us | 42.67 ms | 1 | NULL | |
log_writer_thread | 275 | 30.64 ms | 689.04 ns | 111.43 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 | |
io_read_thread | 9 | 220.36 us | 17.85 us | 24.48 us | 46.71 us | 5 | NULL | |
srv_worker_thread | 1 | 8.41 us | 8.41 us | 8.41 us | 8.41 us | 38 | NULL |
|