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 | 2933 | 39645811901520 | 44115456 | 13517153496.0000 | 120519114672 | 18 | NULL | |
page_flush_coordinator_thread | 5765 | 6658996043040 | 3478464 | 2814715860.0000 | 534676177200 | 13 | NULL | |
io_write_thread | 282 | 2746245690672 | 125709936 | 9738459720.0000 | 38004669648 | 9 | NULL | |
io_write_thread | 166 | 1929704100192 | 1558047744 | 11624723352.0000 | 44051163024 | 10 | NULL | |
log_checkpointer_thread | 248 | 1716411997344 | 7373520 | 6921016080.0000 | 35234371920 | 15 | NULL | |
log_writer_thread | 5867 | 1392103948224 | 472560 | 237276864.0000 | 16281149280 | 20 | NULL | |
io_write_thread | 106 | 1262986459152 | 1579009872 | 11914966536.0000 | 38225912208 | 11 | NULL | |
io_write_thread | 88 | 952739564304 | 1611815040 | 10826585880.0000 | 31540682976 | 12 | NULL | |
main | 150 | 100150011456 | 76032 | 429388608.0000 | 29137519488 | 1 | NULL | |
srv_purge_thread | 3 | 5109760128 | 162391152 | 1703253288.0000 | 4148668128 | 36 | NULL | |
clone_gtid_thread | 5 | 714826992 | 4119456 | 142965240.0000 | 288133824 | 35 | NULL | |
io_read_thread | 19 | 680824848 | 22663872 | 35832720.0000 | 57364560 | 5 | NULL | |
srv_worker_thread | 3 | 67029600 | 5964816 | 22343112.0000 | 52829568 | 42 | NULL | |
srv_worker_thread | 2 | 45000384 | 18944112 | 22500192.0000 | 26056272 | 40 | NULL |
|