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 | 176 | 3785221448448 | 1420710192 | 21506940048.0000 | 825059697792 | 18 | NULL | |
page_flush_coordinator_thread | 667 | 530931203616 | 3637920 | 468304584.0000 | 35053188720 | 13 | NULL | |
io_write_thread | 51 | 453090263472 | 81624048 | 8884122720.0000 | 30199257264 | 9 | NULL | |
log_checkpointer_thread | 52 | 379682656848 | 9753216 | 7301589504.0000 | 27775682880 | 15 | NULL | |
io_write_thread | 36 | 340989480480 | 1637581968 | 9471929808.0000 | 27562463808 | 10 | NULL | |
io_write_thread | 14 | 124767607536 | 1603915632 | 8911971816.0000 | 14883250800 | 11 | NULL | |
log_writer_thread | 267 | 105625792272 | 466752 | 395602152.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 | 2 | 166793616 | 37431504 | 83396808.0000 | 129362112 | 5 | NULL | |
srv_worker_thread | 3 | 48931344 | 11323488 | 16310448.0000 | 26205168 | 38 | NULL |
|