SELECT * FROM `io_by_thread_by_latency`
|
user | total | total_latency | min_latency | avg_latency | max_latency | thread_id | processlist_id | |
---|---|---|---|---|---|---|---|---|
log_flusher_thread | 569 | 8.05 s | 1.31 ms | 14.14 ms | 268.40 ms | 18 | NULL | |
page_flush_coordinator_thread | 1352 | 1.51 s | 3.54 us | 583.53 us | 144.41 ms | 13 | NULL | |
io_write_thread | 66 | 827.67 ms | 1.69 ms | 12.54 ms | 25.69 ms | 9 | NULL | |
io_write_thread | 53 | 646.26 ms | 2.31 ms | 12.19 ms | 38.33 ms | 10 | NULL | |
log_checkpointer_thread | 70 | 565.69 ms | 10.16 us | 8.08 ms | 29.96 ms | 15 | NULL | |
log_writer_thread | 1233 | 471.52 ms | 466.22 ns | 382.42 us | 107.52 ms | 20 | NULL | |
io_write_thread | 33 | 467.48 ms | 2.76 ms | 14.17 ms | 41.85 ms | 11 | NULL | |
main | 149 | 89.79 ms | 91.87 ns | 374.48 us | 34.40 ms | 1 | NULL | |
io_write_thread | 2 | 45.23 ms | 18.57 ms | 22.61 ms | 26.66 ms | 12 | NULL | |
srv_purge_thread | 2 | 1.29 ms | 413.01 us | 643.72 us | 874.43 us | 36 | NULL | |
srv_worker_thread | 1 | 1.12 ms | 1.12 ms | 1.12 ms | 1.12 ms | 40 | NULL | |
clone_gtid_thread | 5 | 816.79 us | 4.46 us | 163.36 us | 329.42 us | 35 | NULL | |
io_read_thread | 4 | 116.45 us | 27.34 us | 29.11 us | 31.20 us | 5 | NULL | |
srv_worker_thread | 2 | 33.57 us | 8.61 us | 16.79 us | 24.96 us | 38 | NULL | |
srv_worker_thread | 2 | 16.28 us | 7.11 us | 8.14 us | 9.16 us | 42 | NULL |
|