SELECT * FROM `io_by_thread_by_latency`
|
user | total | total_latency | min_latency | avg_latency | max_latency | thread_id | processlist_id | |
---|---|---|---|---|---|---|---|---|
log_flusher_thread | 151 | 1.93 s | 60.15 us | 12.77 ms | 46.66 ms | 18 | NULL | |
page_flush_coordinator_thread | 1177 | 459.34 ms | 3.15 us | 519.07 us | 26.91 ms | 13 | NULL | |
io_write_thread | 42 | 376.70 ms | 1.50 ms | 8.97 ms | 35.73 ms | 9 | NULL | |
log_checkpointer_thread | 44 | 279.51 ms | 6.80 us | 6.35 ms | 17.71 ms | 15 | NULL | |
io_write_thread | 19 | 158.19 ms | 1.64 ms | 8.33 ms | 33.67 ms | 11 | NULL | |
io_write_thread | 11 | 102.16 ms | 4.67 ms | 9.29 ms | 16.39 ms | 10 | NULL | |
log_writer_thread | 234 | 45.95 ms | 549.65 ns | 196.36 us | 7.78 ms | 20 | NULL | |
main | 138 | 44.74 ms | 116.16 ns | 195.53 us | 15.84 ms | 1 | NULL | |
clone_gtid_thread | 5 | 1.67 ms | 285.68 us | 334.18 us | 378.89 us | 35 | NULL | |
io_read_thread | 23 | 1.43 ms | 21.80 us | 62.15 us | 317.11 us | 5 | NULL | |
buf_dump_thread | 3 | 45.15 us | 5.92 us | 15.05 us | 30.44 us | 34 | NULL |
|