SELECT * FROM `io_by_thread_by_latency`
|
user | total | total_latency | min_latency | avg_latency | max_latency | thread_id | processlist_id | |
---|---|---|---|---|---|---|---|---|
log_flusher_thread | 382 | 5.78 s | 52.71 us | 15.13 ms | 338.55 ms | 18 | NULL | |
page_flush_coordinator_thread | 1336 | 1.72 s | 3.47 us | 687.50 us | 233.27 ms | 13 | NULL | |
io_write_thread | 94 | 1.55 s | 74.50 us | 16.47 ms | 460.57 ms | 9 | NULL | |
io_write_thread | 44 | 545.40 ms | 1.50 ms | 12.40 ms | 33.39 ms | 10 | NULL | |
log_checkpointer_thread | 74 | 527.75 ms | 7.75 us | 7.13 ms | 31.26 ms | 15 | NULL | |
log_writer_thread | 646 | 159.98 ms | 485.23 ns | 247.64 us | 17.35 ms | 20 | NULL | |
io_write_thread | 12 | 145.61 ms | 2.59 ms | 12.13 ms | 22.42 ms | 12 | NULL | |
main | 148 | 114.58 ms | 75.50 ns | 546.92 us | 33.45 ms | 1 | NULL | |
io_write_thread | 8 | 109.40 ms | 1.66 ms | 13.68 ms | 29.97 ms | 11 | NULL | |
root@192.168.30.20 | 3 | 8.20 ms | 576.92 us | 2.73 ms | 6.95 ms | 6029 | 5413 | |
srv_purge_thread | 4 | 3.69 ms | 350.12 us | 922.72 us | 1.79 ms | 36 | NULL | |
srv_worker_thread | 2 | 868.20 us | 12.26 us | 434.10 us | 855.94 us | 42 | NULL | |
clone_gtid_thread | 5 | 754.08 us | 4.67 us | 150.82 us | 257.34 us | 35 | NULL | |
io_read_thread | 21 | 528.20 us | 15.19 us | 25.15 us | 52.53 us | 5 | NULL | |
srv_worker_thread | 2 | 18.95 us | 6.99 us | 9.47 us | 11.96 us | 40 | NULL |
|