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 | 694 | 9339399800544 | 48942960 | 13457348256.0000 | 135615579264 | 18 | NULL | |
page_flush_coordinator_thread | 2613 | 1555611322848 | 3358080 | 311777928.0000 | 47497351968 | 13 | NULL | |
io_write_thread | 108 | 1042949531712 | 1580241168 | 9656939952.0000 | 39889968624 | 9 | NULL | |
io_write_thread | 66 | 787603159200 | 1497600720 | 11933381064.0000 | 133341645888 | 10 | NULL | |
log_checkpointer_thread | 108 | 727964678496 | 8070480 | 6740413680.0000 | 22707902448 | 15 | NULL | |
log_writer_thread | 1110 | 428635253376 | 506352 | 386157816.0000 | 76020546096 | 20 | NULL | |
io_write_thread | 39 | 381500723472 | 1558042464 | 9782069616.0000 | 23875786176 | 11 | NULL | |
io_write_thread | 18 | 198209582736 | 1536673248 | 11011643280.0000 | 30623455104 | 12 | NULL | |
main | 150 | 93587548032 | 101376 | 404394639.0000 | 29334459792 | 1 | NULL | |
srv_purge_thread | 3 | 3320274672 | 264385968 | 1106758224.0000 | 1928785056 | 36 | NULL | |
srv_worker_thread | 1 | 1333426512 | 1333426512 | 1333426512.0000 | 1333426512 | 40 | NULL | |
clone_gtid_thread | 4 | 672982992 | 4842288 | 168245616.0000 | 339631776 | 35 | NULL | |
srv_worker_thread | 2 | 284670144 | 7786944 | 142335072.0000 | 276883200 | 42 | NULL | |
srv_worker_thread | 2 | 15624048 | 7717776 | 7812024.0000 | 7906272 | 38 | NULL |
|