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 | 232 | 4576714325040 | 1420710192 | 19727216784.0000 | 825059697792 | 18 | NULL | |
page_flush_coordinator_thread | 886 | 841069074912 | 3430416 | 543497064.0000 | 35053188720 | 13 | NULL | |
io_write_thread | 85 | 822842608896 | 81624048 | 9680501160.0000 | 30199257264 | 9 | NULL | |
log_checkpointer_thread | 84 | 602083995216 | 9753216 | 7167666528.0000 | 27775682880 | 15 | NULL | |
io_write_thread | 46 | 430505503296 | 1637581968 | 9358815048.0000 | 27562463808 | 10 | NULL | |
io_write_thread | 18 | 160453226208 | 1603915632 | 8914067976.0000 | 14883250800 | 11 | NULL | |
log_writer_thread | 348 | 111760691328 | 466752 | 321151248.0000 | 43823053824 | 20 | NULL | |
main | 149 | 96231643728 | 74448 | 384193986.0000 | 41162465520 | 1 | NULL | |
srv_purge_thread | 2 | 4527532944 | 916218336 | 2263766472.0000 | 3611314608 | 36 | NULL | |
srv_worker_thread | 2 | 1158727680 | 6644880 | 579363840.0000 | 1152082800 | 42 | NULL | |
clone_gtid_thread | 5 | 770346192 | 10422192 | 154069080.0000 | 278648304 | 35 | NULL | |
io_read_thread | 9 | 327057984 | 20129472 | 36339600.0000 | 129362112 | 5 | NULL | |
srv_worker_thread | 3 | 48931344 | 11323488 | 16310448.0000 | 26205168 | 38 | NULL |
|