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 | 105 | 1214775157200 | 69615744 | 11569287048.0000 | 32351549472 | 18 | NULL | |
page_flush_coordinator_thread | 325 | 181265006736 | 4236672 | 557738280.0000 | 55159733904 | 13 | NULL | |
io_write_thread | 9 | 120345447024 | 6354656352 | 13371716160.0000 | 30831002400 | 9 | NULL | |
main | 147 | 107755105392 | 73920 | 468221589.0000 | 30856177440 | 1 | NULL | |
log_checkpointer_thread | 12 | 101932944432 | 13393248 | 8494411992.0000 | 31863412416 | 15 | NULL | |
io_write_thread | 8 | 69823303440 | 1623312768 | 8727912864.0000 | 20666682960 | 10 | NULL | |
log_writer_thread | 167 | 61060095888 | 489456 | 365629176.0000 | 5299401888 | 20 | NULL | |
io_write_thread | 4 | 52243901424 | 7988824800 | 13060975224.0000 | 18339114816 | 12 | NULL | |
io_write_thread | 4 | 41510948160 | 1620996960 | 10377737040.0000 | 19778361504 | 11 | NULL | |
root@192.168.30.20 | 1 | 2076914928 | 2076914928 | 2076914928.0000 | 2076914928 | 519 | 463 | |
srv_worker_thread | 1 | 1812801408 | 1812801408 | 1812801408.0000 | 1812801408 | 38 | NULL | |
clone_gtid_thread | 5 | 1279746864 | 11603328 | 255949320.0000 | 433465296 | 35 | NULL | |
srv_worker_thread | 2 | 325695744 | 8350320 | 162847872.0000 | 317345424 | 40 | NULL | |
srv_purge_thread | 1 | 268639008 | 268639008 | 268639008.0000 | 268639008 | 36 | NULL | |
srv_worker_thread | 2 | 31017360 | 13646688 | 15508680.0000 | 17370672 | 42 | NULL |
|