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 | 126 | 3111714362592 | 1433600256 | 24696145584.0000 | 825059697792 | 18 | NULL | |
page_flush_coordinator_thread | 553 | 307711560288 | 3637920 | 367971384.0000 | 35053188720 | 13 | NULL | |
io_write_thread | 31 | 290456303808 | 81624048 | 9369558000.0000 | 30199257264 | 9 | NULL | |
log_checkpointer_thread | 28 | 216063667776 | 9785424 | 7716559488.0000 | 27775682880 | 15 | NULL | |
io_write_thread | 17 | 176761434960 | 1637581968 | 10397731344.0000 | 27562463808 | 10 | NULL | |
log_writer_thread | 200 | 100020576480 | 466752 | 500102856.0000 | 43823053824 | 20 | NULL | |
main | 149 | 96231643728 | 74448 | 384193986.0000 | 41162465520 | 1 | NULL | |
io_write_thread | 8 | 62958016704 | 1603915632 | 7869752088.0000 | 14883250800 | 11 | 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 |
|