SELECT * FROM `io_by_thread_by_latency`
|
user | total | total_latency | min_latency | avg_latency | max_latency | thread_id | processlist_id | |
---|---|---|---|---|---|---|---|---|
log_flusher_thread | 1382 | 19.44 s | 36.83 us | 14.07 ms | 591.22 ms | 18 | NULL | |
page_flush_coordinator_thread | 3938 | 4.81 s | 3.50 us | 809.99 us | 519.66 ms | 13 | NULL | |
io_write_thread | 177 | 1.87 s | 1.51 ms | 10.56 ms | 28.70 ms | 9 | NULL | |
log_writer_thread | 2747 | 1.25 s | 468.86 ns | 456.31 us | 464.73 ms | 20 | NULL | |
log_checkpointer_thread | 130 | 898.76 ms | 9.44 us | 6.18 ms | 25.73 ms | 15 | NULL | |
io_write_thread | 72 | 830.40 ms | 225.79 us | 11.53 ms | 27.07 ms | 10 | NULL | |
io_write_thread | 46 | 529.42 ms | 1.52 ms | 11.51 ms | 52.27 ms | 11 | NULL | |
io_write_thread | 43 | 455.60 ms | 2.29 ms | 10.60 ms | 27.28 ms | 12 | NULL | |
main | 149 | 84.84 ms | 77.09 ns | 337.54 us | 25.74 ms | 1 | NULL | |
srv_worker_thread | 1 | 914.55 us | 914.55 us | 914.55 us | 914.55 us | 40 | NULL | |
clone_gtid_thread | 5 | 742.00 us | 10.16 us | 148.40 us | 251.32 us | 35 | NULL | |
io_read_thread | 21 | 479.60 us | 7.79 us | 22.84 us | 56.14 us | 5 | NULL | |
srv_worker_thread | 3 | 385.20 us | 21.64 us | 128.40 us | 266.73 us | 38 | NULL | |
srv_purge_thread | 1 | 178.71 us | 178.71 us | 178.71 us | 178.71 us | 36 | NULL | |
srv_worker_thread | 2 | 59.67 us | 28.83 us | 29.83 us | 30.84 us | 42 | NULL |
|