SELECT * FROM `io_by_thread_by_latency`
|
user | total | total_latency | min_latency | avg_latency | max_latency | thread_id | processlist_id | |
---|---|---|---|---|---|---|---|---|
log_flusher_thread | 400 | 5.04 s | 48.48 us | 12.59 ms | 45.86 ms | 18 | NULL | |
page_flush_coordinator_thread | 2271 | 2.45 s | 3.44 us | 776.85 us | 442.35 ms | 13 | NULL | |
io_write_thread | 191 | 1.80 s | 72.59 us | 9.44 ms | 51.55 ms | 9 | NULL | |
log_checkpointer_thread | 170 | 1.16 s | 10.06 us | 6.83 ms | 28.14 ms | 15 | NULL | |
io_write_thread | 79 | 780.59 ms | 1.52 ms | 9.88 ms | 30.28 ms | 10 | NULL | |
io_write_thread | 38 | 325.81 ms | 1.58 ms | 8.57 ms | 18.85 ms | 11 | NULL | |
io_write_thread | 22 | 207.58 ms | 1.60 ms | 9.44 ms | 24.21 ms | 12 | NULL | |
main | 147 | 118.71 ms | 181.10 ns | 485.04 us | 34.20 ms | 1 | NULL | |
log_writer_thread | 598 | 56.72 ms | 484.70 ns | 94.85 us | 10.37 ms | 20 | NULL | |
srv_purge_thread | 2 | 7.03 ms | 2.93 ms | 3.51 ms | 4.09 ms | 36 | NULL | |
srv_worker_thread | 3 | 2.08 ms | 6.85 us | 694.97 us | 1.86 ms | 42 | NULL | |
clone_gtid_thread | 4 | 690.73 us | 11.91 us | 172.68 us | 356.97 us | 35 | NULL | |
io_read_thread | 11 | 340.84 us | 17.39 us | 30.99 us | 41.93 us | 5 | NULL | |
srv_worker_thread | 3 | 68.70 us | 6.70 us | 22.90 us | 39.05 us | 40 | NULL |
|