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 | 477 | 6815494305312 | 77591712 | 14288247864.0000 | 176926562736 | 18 | NULL | |
page_flush_coordinator_thread | 1113 | 1292963954832 | 3742992 | 597283764.0000 | 107576575920 | 13 | NULL | |
io_write_thread | 54 | 728502381024 | 1607673936 | 13490784648.0000 | 36581024832 | 9 | NULL | |
io_write_thread | 32 | 335172609024 | 1504296288 | 10474144032.0000 | 21165017808 | 10 | NULL | |
io_write_thread | 25 | 301689627360 | 2301520848 | 12067584936.0000 | 28317032304 | 11 | NULL | |
log_checkpointer_thread | 42 | 290787674496 | 8327616 | 6923515896.0000 | 21436892928 | 15 | NULL | |
log_writer_thread | 888 | 251301315408 | 477840 | 282996912.0000 | 13859887536 | 20 | NULL | |
main | 149 | 121315924224 | 166848 | 486723435.0000 | 37325602512 | 1 | NULL | |
io_write_thread | 6 | 59384486304 | 1644964464 | 9897414384.0000 | 17422438176 | 12 | NULL | |
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 |
|