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 | 1231 | 16074410204160 | 50896560 | 13058009712.0000 | 232667263488 | 18 | NULL | |
page_flush_coordinator_thread | 3915 | 5290094582256 | 3419856 | 2253008208.0000 | 430788258912 | 13 | NULL | |
io_write_thread | 476 | 3702519537024 | 1416223248 | 7778402280.0000 | 42988670736 | 9 | NULL | |
log_checkpointer_thread | 364 | 2327574422976 | 6345504 | 6394435080.0000 | 24873566256 | 15 | NULL | |
io_write_thread | 175 | 1399012884720 | 116481024 | 7994359296.0000 | 42591527088 | 10 | NULL | |
io_write_thread | 85 | 734511193152 | 1601212800 | 8641307928.0000 | 24091550208 | 11 | NULL | |
log_writer_thread | 1976 | 466108197456 | 453024 | 235884528.0000 | 115221619392 | 20 | NULL | |
io_write_thread | 36 | 337947183024 | 1477180848 | 9387421560.0000 | 29795541600 | 12 | NULL | |
main | 148 | 90241464720 | 74976 | 378293883.0000 | 34978297728 | 1 | NULL | |
srv_purge_thread | 3 | 7095487344 | 171519216 | 2365162272.0000 | 4488255552 | 36 | NULL | |
io_read_thread | 16 | 627285120 | 27664032 | 39205320.0000 | 64732272 | 5 | NULL | |
srv_worker_thread | 2 | 622887408 | 7290624 | 311443704.0000 | 615596784 | 42 | NULL | |
clone_gtid_thread | 4 | 486169728 | 5510208 | 121542432.0000 | 278672064 | 35 | NULL | |
srv_worker_thread | 3 | 175569504 | 9224160 | 58522992.0000 | 156761088 | 38 | NULL | |
srv_worker_thread | 1 | 10656624 | 10656624 | 10656624.0000 | 10656624 | 40 | NULL |
|