SELECT * FROM `io_by_thread_by_latency`
|
user | total | total_latency | min_latency | avg_latency | max_latency | thread_id | processlist_id | |
---|---|---|---|---|---|---|---|---|
log_flusher_thread | 39 | 489.32 ms | 1.46 ms | 12.55 ms | 38.96 ms | 18 | NULL | |
page_flush_coordinator_thread | 288 | 120.65 ms | 3.66 us | 307.76 us | 22.72 ms | 13 | NULL | |
io_write_thread | 11 | 82.36 ms | 1.68 ms | 7.49 ms | 11.06 ms | 9 | NULL | |
log_checkpointer_thread | 14 | 80.61 ms | 10.39 us | 5.76 ms | 15.26 ms | 15 | NULL | |
io_write_thread | 3 | 45.60 ms | 10.61 ms | 15.20 ms | 22.69 ms | 10 | NULL | |
main | 128 | 45.44 ms | 98.21 ns | 221.71 us | 20.97 ms | 1 | NULL | |
io_write_thread | 3 | 29.80 ms | 2.36 ms | 9.93 ms | 15.11 ms | 11 | NULL | |
log_writer_thread | 57 | 8.44 ms | 601.39 ns | 148.10 us | 3.47 ms | 20 | NULL | |
clone_gtid_thread | 5 | 1.23 ms | 22.61 us | 246.81 us | 360.96 us | 35 | NULL | |
io_read_thread | 13 | 417.25 us | 25.34 us | 32.10 us | 42.84 us | 5 | NULL |
|