SELECT * FROM `io_by_thread_by_latency`
|
user | total | total_latency | min_latency | avg_latency | max_latency | thread_id | processlist_id | |
---|---|---|---|---|---|---|---|---|
log_flusher_thread | 1380 | 18.63 s | 44.69 us | 13.50 ms | 335.29 ms | 18 | NULL | |
page_flush_coordinator_thread | 4057 | 4.64 s | 3.38 us | 1.21 ms | 180.63 ms | 13 | NULL | |
io_write_thread | 219 | 2.33 s | 1.52 ms | 10.63 ms | 39.28 ms | 9 | NULL | |
log_checkpointer_thread | 214 | 1.45 s | 9.00 us | 8.15 ms | 36.08 ms | 15 | NULL | |
io_write_thread | 118 | 1.38 s | 67.65 us | 11.72 ms | 40.04 ms | 10 | NULL | |
io_write_thread | 62 | 695.67 ms | 380.35 us | 11.22 ms | 32.96 ms | 11 | NULL | |
log_writer_thread | 2752 | 629.91 ms | 477.84 ns | 228.89 us | 11.17 ms | 20 | NULL | |
io_write_thread | 64 | 629.77 ms | 1.71 ms | 9.84 ms | 39.39 ms | 12 | NULL | |
main | 150 | 88.83 ms | 92.40 ns | 359.19 us | 28.63 ms | 1 | NULL | |
srv_purge_thread | 3 | 1.44 ms | 249.21 us | 479.93 us | 695.59 us | 36 | NULL | |
clone_gtid_thread | 5 | 964.60 us | 12.01 us | 192.92 us | 353.54 us | 35 | NULL | |
io_read_thread | 15 | 958.78 us | 25.18 us | 63.92 us | 508.48 us | 5 | NULL | |
srv_worker_thread | 1 | 763.56 us | 763.56 us | 763.56 us | 763.56 us | 40 | NULL | |
srv_worker_thread | 2 | 578.16 us | 16.65 us | 289.08 us | 561.52 us | 38 | NULL | |
srv_worker_thread | 2 | 470.02 us | 218.33 us | 235.01 us | 251.69 us | 42 | NULL |
|