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 | 540 | 7777096351200 | 77591712 | 14402030280.0000 | 176926562736 | 18 | NULL | |
page_flush_coordinator_thread | 1399 | 1508738014608 | 3509088 | 553544376.0000 | 107576575920 | 13 | NULL | |
io_write_thread | 77 | 1014254002608 | 1607673936 | 13172129784.0000 | 36581024832 | 9 | NULL | |
log_checkpointer_thread | 60 | 414631694928 | 8327616 | 6910528152.0000 | 21436892928 | 15 | NULL | |
io_write_thread | 40 | 412525595328 | 1504296288 | 10313139672.0000 | 27862332432 | 10 | NULL | |
io_write_thread | 29 | 362044062864 | 2301520848 | 12484277784.0000 | 28317032304 | 11 | NULL | |
log_writer_thread | 1000 | 261775295760 | 477840 | 261775272.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 |
|