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 | 45 | 632003775216 | 5399032320 | 14044528080.0000 | 47187261792 | 18 | NULL | |
page_flush_coordinator_thread | 221 | 128334356832 | 4546608 | 314292396.0000 | 42920203920 | 13 | NULL | |
io_write_thread | 8 | 103198680816 | 5015135136 | 12899834904.0000 | 25027400112 | 9 | NULL | |
main | 149 | 91615926336 | 90288 | 367977951.0000 | 32503599744 | 1 | NULL | |
log_checkpointer_thread | 10 | 86538607056 | 17086608 | 8653860600.0000 | 24093117312 | 15 | NULL | |
io_write_thread | 7 | 54182714784 | 2000007504 | 7740387600.0000 | 12303393168 | 10 | NULL | |
io_write_thread | 4 | 51797941536 | 9653360112 | 12949485384.0000 | 17714278560 | 11 | NULL | |
log_writer_thread | 72 | 9433821408 | 805728 | 131025048.0000 | 3796757184 | 20 | NULL | |
srv_worker_thread | 1 | 1190216016 | 1190216016 | 1190216016.0000 | 1190216016 | 38 | NULL | |
clone_gtid_thread | 5 | 996572016 | 5940000 | 199314192.0000 | 343712688 | 35 | NULL | |
srv_purge_thread | 1 | 950505600 | 950505600 | 950505600.0000 | 950505600 | 36 | NULL | |
root@192.168.30.20 | 3 | 865000752 | 227931792 | 288333408.0000 | 322344528 | 227 | 183 | |
srv_worker_thread | 2 | 32332608 | 13639296 | 16166304.0000 | 18693312 | 40 | NULL | |
srv_worker_thread | 2 | 29103360 | 11160336 | 14551680.0000 | 17943024 | 42 | NULL |
|