SELECT * FROM `io_by_thread_by_latency`
|
user | total | total_latency | min_latency | avg_latency | max_latency | thread_id | processlist_id | |
---|---|---|---|---|---|---|---|---|
log_flusher_thread | 237 | 3.50 s | 118.68 us | 14.78 ms | 128.95 ms | 18 | NULL | |
io_write_thread | 89 | 1.02 s | 1.68 ms | 11.41 ms | 27.81 ms | 9 | NULL | |
page_flush_coordinator_thread | 902 | 954.20 ms | 3.54 us | 606.42 us | 41.87 ms | 13 | NULL | |
log_checkpointer_thread | 82 | 594.88 ms | 8.20 us | 7.25 ms | 23.30 ms | 15 | NULL | |
io_write_thread | 40 | 427.99 ms | 1.58 ms | 10.70 ms | 34.07 ms | 10 | NULL | |
log_writer_thread | 364 | 188.73 ms | 515.33 ns | 518.48 us | 65.68 ms | 20 | NULL | |
io_write_thread | 16 | 188.67 ms | 5.04 ms | 11.79 ms | 19.49 ms | 11 | NULL | |
main | 149 | 118.74 ms | 76.03 ns | 454.28 us | 27.56 ms | 1 | NULL | |
io_write_thread | 4 | 42.87 ms | 8.71 ms | 10.72 ms | 12.52 ms | 12 | NULL | |
srv_purge_thread | 2 | 3.31 ms | 1.02 ms | 1.65 ms | 2.29 ms | 36 | NULL | |
srv_worker_thread | 2 | 1.87 ms | 14.13 us | 934.56 us | 1.85 ms | 42 | NULL | |
clone_gtid_thread | 4 | 831.98 us | 18.86 us | 208.00 us | 413.72 us | 35 | NULL | |
root@192.168.30.20 | 1 | 592.78 us | 592.78 us | 592.78 us | 592.78 us | 4420 | 4092 | |
io_read_thread | 13 | 352.55 us | 20.48 us | 27.12 us | 37.44 us | 5 | NULL | |
srv_worker_thread | 2 | 25.37 us | 7.50 us | 12.69 us | 17.87 us | 38 | NULL |
|