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 | 403 | 5459431345104 | 104377680 | 13546975992.0000 | 116198231952 | 18 | NULL | |
page_flush_coordinator_thread | 1514 | 830817840864 | 3537600 | 541773540.0000 | 120924555840 | 13 | NULL | |
io_write_thread | 55 | 597590603808 | 1604356512 | 10865283528.0000 | 29671231920 | 9 | NULL | |
io_write_thread | 34 | 427457784864 | 1475298000 | 12572287728.0000 | 35809787376 | 10 | NULL | |
log_checkpointer_thread | 42 | 258179767824 | 12576960 | 6147137304.0000 | 17873449440 | 15 | NULL | |
log_writer_thread | 644 | 251663117904 | 477840 | 390780984.0000 | 22508629968 | 20 | NULL | |
main | 147 | 112940085984 | 104544 | 440013354.0000 | 35547195024 | 1 | NULL | |
io_write_thread | 6 | 47566290816 | 2496587808 | 7927715136.0000 | 14391651648 | 12 | NULL | |
io_write_thread | 4 | 41493708960 | 1780839984 | 10373427240.0000 | 15883975536 | 11 | NULL | |
srv_purge_thread | 2 | 4402151424 | 1064085264 | 2201075712.0000 | 3338066160 | 36 | NULL | |
srv_worker_thread | 2 | 1489366560 | 18661632 | 744683280.0000 | 1470704928 | 38 | NULL | |
root@192.168.30.20 | 46 | 1063526112 | 350592 | 23120064.0000 | 105054576 | 2045 | 1857 | |
clone_gtid_thread | 5 | 909830592 | 4311648 | 181965960.0000 | 313576560 | 35 | NULL | |
io_read_thread | 6 | 66239712 | 6010224 | 11039952.0000 | 16278240 | 5 | NULL | |
srv_worker_thread | 2 | 29687328 | 10693584 | 14843664.0000 | 18993744 | 42 | NULL |
|