SELECT * FROM `io_by_thread_by_latency`
|
user | total | total_latency | min_latency | avg_latency | max_latency | thread_id | processlist_id | |
---|---|---|---|---|---|---|---|---|
log_flusher_thread | 743 | 10.69 s | 56.06 us | 14.38 ms | 45.58 ms | 18 | NULL | |
page_flush_coordinator_thread | 2739 | 3.56 s | 3.34 us | 1.30 ms | 50.96 ms | 13 | NULL | |
io_write_thread | 211 | 2.50 s | 105.69 us | 11.83 ms | 43.80 ms | 9 | NULL | |
log_checkpointer_thread | 238 | 1.68 s | 10.42 us | 7.06 ms | 28.62 ms | 15 | NULL | |
io_write_thread | 142 | 1.49 s | 77.33 us | 10.47 ms | 34.73 ms | 10 | NULL | |
io_write_thread | 45 | 557.18 ms | 1.70 ms | 12.38 ms | 35.36 ms | 11 | NULL | |
log_writer_thread | 1240 | 311.04 ms | 478.90 ns | 250.84 us | 8.27 ms | 20 | NULL | |
io_write_thread | 29 | 290.31 ms | 1.62 ms | 10.01 ms | 28.39 ms | 12 | NULL | |
main | 148 | 113.29 ms | 129.89 ns | 436.56 us | 40.11 ms | 1 | NULL | |
srv_worker_thread | 2 | 2.77 ms | 13.87 us | 1.38 ms | 2.75 ms | 40 | NULL | |
dict_stats_thread | 2 | 1.48 ms | 682.37 us | 739.86 us | 797.35 us | 26 | NULL | |
srv_purge_thread | 2 | 902.76 us | 233.49 us | 451.38 us | 669.27 us | 36 | NULL | |
clone_gtid_thread | 5 | 862.87 us | 6.38 us | 172.57 us | 319.24 us | 35 | NULL | |
io_read_thread | 12 | 387.24 us | 15.64 us | 32.27 us | 66.75 us | 5 | NULL | |
srv_worker_thread | 2 | 48.88 us | 13.06 us | 24.44 us | 35.82 us | 42 | NULL |
|