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 | 463 | 6605239745808 | 77591712 | 14266176408.0000 | 176926562736 | 18 | NULL | |
page_flush_coordinator_thread | 1070 | 1153702052448 | 3742992 | 1078226160.0000 | 107576575920 | 13 | NULL | |
io_write_thread | 40 | 616118180304 | 2330982192 | 15402954336.0000 | 36581024832 | 9 | NULL | |
io_write_thread | 25 | 301689627360 | 2301520848 | 12067584936.0000 | 28317032304 | 11 | NULL | |
io_write_thread | 27 | 279645621024 | 1504296288 | 10357245096.0000 | 21165017808 | 10 | NULL | |
log_writer_thread | 869 | 251035421472 | 477840 | 288878304.0000 | 13859887536 | 20 | NULL | |
log_checkpointer_thread | 32 | 215455152528 | 8327616 | 6732973368.0000 | 16343317584 | 15 | NULL | |
main | 149 | 121315924224 | 166848 | 486723435.0000 | 37325602512 | 1 | NULL | |
io_write_thread | 6 | 59384486304 | 1644964464 | 9897414384.0000 | 17422438176 | 12 | NULL | |
root@192.168.30.20 | 1 | 1847536944 | 1847536944 | 1847536944.0000 | 1847536944 | 843 | 787 | |
srv_purge_thread | 2 | 1569629952 | 268708176 | 784814976.0000 | 1300921776 | 36 | NULL | |
clone_gtid_thread | 4 | 816925824 | 6711936 | 204231456.0000 | 406324512 | 35 | NULL | |
io_read_thread | 2 | 253493328 | 125640768 | 126746664.0000 | 127852560 | 5 | NULL | |
srv_worker_thread | 3 | 193440720 | 7575216 | 64480152.0000 | 169294224 | 40 | NULL | |
srv_worker_thread | 2 | 30445536 | 8152320 | 15222768.0000 | 22293216 | 42 | NULL |
|