SELECT * FROM `io_by_thread_by_latency`
|
user | total | total_latency | min_latency | avg_latency | max_latency | thread_id | processlist_id | |
---|---|---|---|---|---|---|---|---|
log_flusher_thread | 50 | 615.38 ms | 60.15 us | 12.31 ms | 39.40 ms | 18 | NULL | |
io_write_thread | 18 | 179.07 ms | 1.50 ms | 9.95 ms | 35.73 ms | 9 | NULL | |
page_flush_coordinator_thread | 598 | 165.30 ms | 3.59 us | 353.78 us | 26.25 ms | 13 | NULL | |
log_checkpointer_thread | 16 | 102.05 ms | 6.80 us | 6.38 ms | 15.13 ms | 15 | NULL | |
main | 138 | 44.74 ms | 116.16 ns | 195.53 us | 15.84 ms | 1 | NULL | |
io_write_thread | 4 | 36.80 ms | 5.13 ms | 9.20 ms | 16.39 ms | 10 | NULL | |
log_writer_thread | 74 | 25.10 ms | 549.65 ns | 339.21 us | 7.78 ms | 20 | NULL | |
io_write_thread | 4 | 16.44 ms | 1.64 ms | 4.11 ms | 10.96 ms | 11 | 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 |
|