SELECT * FROM `io_by_thread_by_latency`
|
user | total | total_latency | min_latency | avg_latency | max_latency | thread_id | processlist_id | |
---|---|---|---|---|---|---|---|---|
log_flusher_thread | 329 | 4.24 s | 56.88 us | 12.89 ms | 46.66 ms | 18 | NULL | |
page_flush_coordinator_thread | 2529 | 1.10 s | 3.15 us | 460.95 us | 35.49 ms | 13 | NULL | |
io_write_thread | 102 | 859.83 ms | 66.83 us | 8.43 ms | 35.73 ms | 9 | NULL | |
log_checkpointer_thread | 90 | 604.56 ms | 6.80 us | 6.72 ms | 21.26 ms | 15 | NULL | |
io_write_thread | 29 | 279.49 ms | 1.64 ms | 9.64 ms | 33.67 ms | 11 | NULL | |
io_write_thread | 14 | 121.97 ms | 1.62 ms | 8.71 ms | 16.39 ms | 10 | NULL | |
log_writer_thread | 513 | 118.26 ms | 549.65 ns | 230.52 us | 8.57 ms | 20 | NULL | |
io_write_thread | 13 | 116.45 ms | 1.66 ms | 8.96 ms | 25.44 ms | 12 | NULL | |
main | 138 | 44.74 ms | 116.16 ns | 195.53 us | 15.84 ms | 1 | NULL | |
io_read_thread | 40 | 1.94 ms | 21.60 us | 48.49 us | 317.11 us | 5 | NULL | |
clone_gtid_thread | 5 | 1.67 ms | 285.68 us | 334.18 us | 378.89 us | 35 | NULL | |
root@192.168.30.20 | 6 | 633.47 us | 11.95 us | 105.58 us | 300.35 us | 6726 | 6402 | |
dict_stats_thread | 1 | 567.75 us | 567.75 us | 567.75 us | 567.75 us | 26 | NULL | |
buf_dump_thread | 3 | 45.15 us | 5.92 us | 15.05 us | 30.44 us | 34 | NULL |
|