SELECT * FROM `io_by_thread_by_latency`
|
user | total | total_latency | min_latency | avg_latency | max_latency | thread_id | processlist_id | |
---|---|---|---|---|---|---|---|---|
log_flusher_thread | 199 | 2.55 s | 57.86 us | 12.84 ms | 46.66 ms | 18 | NULL | |
page_flush_coordinator_thread | 1608 | 698.30 ms | 3.15 us | 451.34 us | 35.49 ms | 13 | NULL | |
io_write_thread | 61 | 529.51 ms | 1.50 ms | 8.68 ms | 35.73 ms | 9 | NULL | |
log_checkpointer_thread | 60 | 384.50 ms | 6.80 us | 6.41 ms | 17.90 ms | 15 | NULL | |
io_write_thread | 22 | 193.51 ms | 1.64 ms | 8.80 ms | 33.67 ms | 11 | NULL | |
io_write_thread | 14 | 121.97 ms | 1.62 ms | 8.71 ms | 16.39 ms | 10 | NULL | |
io_write_thread | 9 | 91.58 ms | 1.66 ms | 10.18 ms | 25.44 ms | 12 | NULL | |
log_writer_thread | 310 | 58.07 ms | 549.65 ns | 187.31 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 | 24 | 1.45 ms | 21.80 us | 60.59 us | 317.11 us | 5 | NULL | |
buf_dump_thread | 3 | 45.15 us | 5.92 us | 15.05 us | 30.44 us | 34 | NULL |
|