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 | 136 | 2073668528448 | 2161783008 | 15247562616.0000 | 112877827392 | 18 | NULL | |
io_write_thread | 46 | 484453520496 | 1585653168 | 10531598088.0000 | 39889968624 | 9 | NULL | |
page_flush_coordinator_thread | 557 | 397104671568 | 3650592 | 712934640.0000 | 47497351968 | 13 | NULL | |
log_checkpointer_thread | 34 | 228915890544 | 8070480 | 6732820248.0000 | 21034894320 | 15 | NULL | |
log_writer_thread | 225 | 212756142192 | 551232 | 945582792.0000 | 76020546096 | 20 | NULL | |
main | 150 | 93587548032 | 101376 | 404394639.0000 | 29334459792 | 1 | NULL | |
io_write_thread | 11 | 75615078528 | 1609588464 | 6874098000.0000 | 13484785248 | 11 | NULL | |
io_write_thread | 9 | 56098776096 | 1517152560 | 6233197344.0000 | 11481068016 | 10 | NULL | |
srv_purge_thread | 2 | 2193171024 | 264385968 | 1096585512.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 | |
root@192.168.30.20 | 2 | 633346032 | 288058320 | 316673016.0000 | 345287712 | 1219 | 1127 | |
srv_worker_thread | 2 | 284670144 | 7786944 | 142335072.0000 | 276883200 | 42 | NULL | |
srv_worker_thread | 2 | 15624048 | 7717776 | 7812024.0000 | 7906272 | 38 | NULL |
|