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 | 160 | 2193387439056 | 89574672 | 13708671240.0000 | 38027966064 | 18 | NULL | |
page_flush_coordinator_thread | 762 | 906963932688 | 3586176 | 1434333912.0000 | 164667031584 | 13 | NULL | |
io_write_thread | 78 | 791722579824 | 1538217120 | 10150289424.0000 | 25658800464 | 9 | NULL | |
log_checkpointer_thread | 68 | 565123200048 | 10366752 | 8310635256.0000 | 75482872608 | 15 | NULL | |
io_write_thread | 27 | 262736841312 | 1597945536 | 9730994064.0000 | 35672778768 | 10 | NULL | |
io_write_thread | 19 | 229738940640 | 1566058032 | 12091523136.0000 | 30052092048 | 11 | NULL | |
main | 146 | 84515811600 | 110880 | 393407916.0000 | 21750020688 | 1 | NULL | |
log_writer_thread | 249 | 37011388128 | 510576 | 148639920.0000 | 6918711888 | 20 | NULL | |
srv_purge_thread | 2 | 1807545696 | 283865472 | 903772848.0000 | 1523680224 | 36 | NULL | |
clone_gtid_thread | 5 | 1657553040 | 13547952 | 331510608.0000 | 1183707360 | 35 | NULL | |
srv_worker_thread | 1 | 1503198576 | 1503198576 | 1503198576.0000 | 1503198576 | 40 | NULL | |
root@192.168.30.20 | 1 | 502491264 | 502491264 | 502491264.0000 | 502491264 | 3291 | 3203 | |
srv_worker_thread | 3 | 31509984 | 5762592 | 10503240.0000 | 15959856 | 42 | NULL | |
srv_worker_thread | 2 | 19985856 | 7173936 | 9992928.0000 | 12811920 | 38 | NULL |
|