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 | 348 | 4816441904208 | 55995984 | 13840350216.0000 | 114372353568 | 18 | NULL | |
page_flush_coordinator_thread | 1311 | 1589821027872 | 3906144 | 641719980.0000 | 50922009072 | 13 | NULL | |
io_write_thread | 157 | 1536138744096 | 1527874656 | 9784323120.0000 | 33927957360 | 9 | NULL | |
log_checkpointer_thread | 146 | 1006844780304 | 7915248 | 6896196912.0000 | 25645587264 | 15 | NULL | |
log_writer_thread | 518 | 840080624592 | 536976 | 1621777080.0000 | 645069400272 | 20 | NULL | |
io_write_thread | 65 | 657412430928 | 1600070736 | 10114037208.0000 | 27596593200 | 10 | NULL | |
io_write_thread | 22 | 200060691600 | 1648885392 | 9093667704.0000 | 17005011936 | 11 | NULL | |
io_write_thread | 24 | 188638111200 | 1612357824 | 7859921256.0000 | 12542152656 | 12 | NULL | |
main | 149 | 130200155184 | 133056 | 500526312.0000 | 37563417408 | 1 | NULL | |
srv_purge_thread | 2 | 4493234592 | 865760544 | 2246617296.0000 | 3627474048 | 36 | NULL | |
srv_worker_thread | 1 | 1844156160 | 1844156160 | 1844156160.0000 | 1844156160 | 40 | NULL | |
clone_gtid_thread | 5 | 966612240 | 10164528 | 193322448.0000 | 385512864 | 35 | NULL | |
io_read_thread | 2 | 80466144 | 26759568 | 40233072.0000 | 53706576 | 5 | NULL | |
srv_worker_thread | 3 | 47591808 | 7442688 | 15863760.0000 | 23385120 | 42 | NULL | |
srv_worker_thread | 2 | 19416144 | 6519744 | 9708072.0000 | 12896400 | 38 | NULL |
|