SELECT * FROM `io_by_thread_by_latency`
|
user | total | total_latency | min_latency | avg_latency | max_latency | thread_id | processlist_id | |
---|---|---|---|---|---|---|---|---|
log_flusher_thread | 388 | 5.41 s | 1.45 ms | 13.94 ms | 99.83 ms | 18 | NULL | |
io_write_thread | 147 | 1.82 s | 1.52 ms | 12.39 ms | 298.23 ms | 9 | NULL | |
page_flush_coordinator_thread | 1260 | 1.70 s | 3.69 us | 708.94 us | 55.44 ms | 13 | NULL | |
log_checkpointer_thread | 142 | 1.05 s | 11.68 us | 7.41 ms | 31.06 ms | 15 | NULL | |
io_write_thread | 62 | 623.75 ms | 2.23 ms | 10.06 ms | 22.22 ms | 10 | NULL | |
io_write_thread | 26 | 237.97 ms | 1.54 ms | 9.15 ms | 21.32 ms | 12 | NULL | |
io_write_thread | 26 | 198.74 ms | 1.68 ms | 7.64 ms | 15.23 ms | 11 | NULL | |
main | 148 | 130.77 ms | 213.84 ns | 563.24 us | 32.51 ms | 1 | NULL | |
log_writer_thread | 572 | 124.29 ms | 470.45 ns | 217.29 us | 14.23 ms | 20 | NULL | |
srv_worker_thread | 3 | 1.91 ms | 15.01 us | 637.98 us | 1.54 ms | 38 | NULL | |
srv_purge_thread | 2 | 1.64 ms | 377.82 us | 822.07 us | 1.27 ms | 36 | NULL | |
clone_gtid_thread | 5 | 1.47 ms | 16.90 us | 293.73 us | 512.24 us | 35 | NULL | |
srv_worker_thread | 1 | 430.28 us | 430.28 us | 430.28 us | 430.28 us | 40 | NULL | |
io_read_thread | 6 | 107.82 us | 8.53 us | 17.97 us | 29.39 us | 5 | NULL | |
srv_worker_thread | 3 | 75.92 us | 12.71 us | 25.30 us | 50.41 us | 42 | NULL |
|