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 | 283 | 4219429418160 | 374022528 | 14909644464.0000 | 110499496272 | 18 | NULL | |
page_flush_coordinator_thread | 816 | 991029083088 | 3754080 | 664186116.0000 | 54681710688 | 13 | NULL | |
io_write_thread | 93 | 925128036624 | 107443248 | 9947613192.0000 | 56235965808 | 9 | NULL | |
log_checkpointer_thread | 100 | 750259700784 | 11660880 | 7502596992.0000 | 25896263184 | 15 | NULL | |
io_write_thread | 58 | 580566189984 | 1609153920 | 10009761696.0000 | 26220428784 | 10 | NULL | |
log_writer_thread | 409 | 204216101760 | 532224 | 499305840.0000 | 39934783680 | 20 | NULL | |
io_write_thread | 14 | 104854241184 | 1633305696 | 7489588656.0000 | 13803969696 | 11 | NULL | |
io_write_thread | 9 | 98104074288 | 1691473872 | 10900452552.0000 | 19137195792 | 12 | NULL | |
main | 150 | 97603410960 | 77088 | 383445678.0000 | 26555857680 | 1 | NULL | |
clone_gtid_thread | 4 | 809384928 | 6632208 | 202346232.0000 | 409970880 | 35 | NULL | |
srv_purge_thread | 2 | 736604352 | 250183296 | 368302176.0000 | 486421056 | 36 | NULL | |
io_read_thread | 2 | 68468928 | 29371056 | 34234464.0000 | 39097872 | 5 | NULL | |
srv_worker_thread | 3 | 35257728 | 8320752 | 11752488.0000 | 16393872 | 42 | NULL | |
srv_worker_thread | 2 | 22437888 | 7500768 | 11218944.0000 | 14937120 | 38 | NULL |
|