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 | 751 | 10072506951408 | 48942960 | 13412126376.0000 | 135615579264 | 18 | NULL | |
page_flush_coordinator_thread | 2698 | 1628588738304 | 3358080 | 315889332.0000 | 47497351968 | 13 | NULL | |
io_write_thread | 111 | 1071147130416 | 1580241168 | 9649974048.0000 | 39889968624 | 9 | NULL | |
io_write_thread | 69 | 829896059520 | 1497600720 | 12027479112.0000 | 133341645888 | 10 | NULL | |
log_checkpointer_thread | 112 | 755670225024 | 8070480 | 6747055392.0000 | 22707902448 | 15 | NULL | |
log_writer_thread | 1201 | 449797085232 | 506352 | 374518584.0000 | 76020546096 | 20 | NULL | |
io_write_thread | 45 | 426998186736 | 1558042464 | 9488848512.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 |
|