SELECT * FROM `io_by_thread_by_latency`
|
user | total | total_latency | min_latency | avg_latency | max_latency | thread_id | processlist_id | |
---|---|---|---|---|---|---|---|---|
log_flusher_thread | 69 | 952.41 ms | 1.70 ms | 13.80 ms | 38.49 ms | 18 | NULL | |
io_write_thread | 30 | 350.62 ms | 3.62 ms | 11.69 ms | 30.34 ms | 9 | NULL | |
page_flush_coordinator_thread | 305 | 326.52 ms | 4.70 us | 573.64 us | 36.25 ms | 13 | NULL | |
log_checkpointer_thread | 26 | 189.24 ms | 11.86 us | 7.28 ms | 21.90 ms | 15 | NULL | |
main | 129 | 49.20 ms | 106.13 ns | 233.97 us | 20.80 ms | 1 | NULL | |
log_writer_thread | 113 | 30.00 ms | 464.11 ns | 265.48 us | 8.31 ms | 20 | NULL | |
io_write_thread | 2 | 20.39 ms | 5.70 ms | 10.20 ms | 14.69 ms | 10 | NULL | |
clone_gtid_thread | 5 | 1.20 ms | 203.79 us | 239.73 us | 336.00 us | 35 | NULL | |
io_read_thread | 13 | 333.20 us | 19.92 us | 25.63 us | 35.54 us | 5 | NULL | |
root@192.168.30.20 | 1 | 224.96 us | 224.96 us | 224.96 us | 224.96 us | 928 | 816 |
|