SELECT * FROM `x$io_by_thread_by_latency`
|
user | total | total_latency | min_latency | avg_latency | max_latency | thread_id | processlist_id | |
---|---|---|---|---|---|---|---|---|
log_flusher_thread | 219 | 2979351304512 | 55995984 | 13604343720.0000 | 112016008896 | 18 | NULL | |
page_flush_coordinator_thread | 881 | 871630265088 | 3906144 | 518787060.0000 | 50922009072 | 13 | NULL | |
io_write_thread | 85 | 864878078064 | 1527874656 | 10175035992.0000 | 29574082560 | 9 | NULL | |
log_checkpointer_thread | 78 | 544335071808 | 7915248 | 6978654672.0000 | 25645587264 | 15 | NULL | |
io_write_thread | 36 | 352388365296 | 1600070736 | 9788565600.0000 | 27596593200 | 10 | NULL | |
log_writer_thread | 334 | 150016730160 | 536976 | 449151648.0000 | 64215013104 | 20 | NULL | |
io_write_thread | 15 | 135196742736 | 1648885392 | 9013116024.0000 | 15940796256 | 11 | NULL | |
main | 149 | 130200155184 | 133056 | 500526312.0000 | 37563417408 | 1 | NULL | |
io_write_thread | 8 | 59220331104 | 1635312624 | 7402541256.0000 | 11476723104 | 12 | NULL | |
srv_purge_thread | 2 | 4493234592 | 865760544 | 2246617296.0000 | 3627474048 | 36 | NULL | |
srv_worker_thread | 1 | 1844156160 | 1844156160 | 1844156160.0000 | 1844156160 | 40 | NULL | |
clone_gtid_thread | 5 | 966612240 | 10164528 | 193322448.0000 | 385512864 | 35 | NULL | |
io_read_thread | 1 | 53706576 | 53706576 | 53706576.0000 | 53706576 | 5 | NULL | |
srv_worker_thread | 3 | 47591808 | 7442688 | 15863760.0000 | 23385120 | 42 | NULL | |
srv_worker_thread | 2 | 19416144 | 6519744 | 9708072.0000 | 12896400 | 38 | NULL |
|