SELECT * FROM `io_by_thread_by_latency`
|
user | total | total_latency | min_latency | avg_latency | max_latency | thread_id | processlist_id | |
---|---|---|---|---|---|---|---|---|
log_flusher_thread | 211 | 3.02 s | 1.33 ms | 14.33 ms | 48.74 ms | 18 | NULL | |
io_write_thread | 119 | 1.40 s | 67.25 us | 11.76 ms | 70.98 ms | 9 | NULL | |
page_flush_coordinator_thread | 947 | 1.31 s | 3.63 us | 729.56 us | 65.44 ms | 13 | NULL | |
log_checkpointer_thread | 108 | 767.42 ms | 8.19 us | 7.11 ms | 22.57 ms | 15 | NULL | |
io_write_thread | 46 | 389.80 ms | 1.51 ms | 8.47 ms | 23.25 ms | 10 | NULL | |
io_write_thread | 14 | 198.68 ms | 2.26 ms | 14.19 ms | 33.77 ms | 11 | NULL | |
main | 148 | 91.02 ms | 76.03 ns | 357.81 us | 27.80 ms | 1 | NULL | |
log_writer_thread | 327 | 63.26 ms | 511.63 ns | 193.46 us | 17.61 ms | 20 | NULL | |
io_write_thread | 4 | 35.70 ms | 3.95 ms | 8.93 ms | 15.40 ms | 12 | NULL | |
srv_purge_thread | 2 | 5.56 ms | 1.10 ms | 2.78 ms | 4.46 ms | 36 | NULL | |
root@192.168.30.20 | 1 | 1.75 ms | 1.75 ms | 1.75 ms | 1.75 ms | 1235 | 1123 | |
clone_gtid_thread | 5 | 966.81 us | 7.93 us | 193.36 us | 365.76 us | 35 | NULL | |
io_read_thread | 12 | 791.56 us | 13.31 us | 65.96 us | 213.20 us | 5 | NULL | |
srv_worker_thread | 2 | 37.49 us | 7.74 us | 18.74 us | 29.75 us | 38 | NULL | |
srv_worker_thread | 1 | 27.92 us | 27.92 us | 27.92 us | 27.92 us | 42 | NULL |
|