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 | 577 | 8371540572384 | 378235440 | 14508735648.0000 | 759949264272 | 18 | NULL | |
page_flush_coordinator_thread | 1341 | 1070384059008 | 4159056 | 428279544.0000 | 60414614832 | 13 | NULL | |
io_write_thread | 80 | 1048603809792 | 1515326736 | 13107547464.0000 | 43460415504 | 9 | NULL | |
log_checkpointer_thread | 74 | 512655578160 | 9693552 | 6927777912.0000 | 22028318400 | 15 | NULL | |
io_write_thread | 26 | 438623216592 | 1668425088 | 16870123512.0000 | 43626520080 | 11 | NULL | |
io_write_thread | 27 | 315272502336 | 1667758752 | 11676759336.0000 | 37101748464 | 10 | NULL | |
log_writer_thread | 1286 | 264294987264 | 481008 | 205516872.0000 | 14239082352 | 20 | NULL | |
io_write_thread | 12 | 147956322096 | 1562555808 | 12329693376.0000 | 34035031536 | 12 | NULL | |
main | 148 | 132771045792 | 72864 | 515165178.0000 | 34855579440 | 1 | NULL | |
io_read_thread | 19 | 11979371184 | 18314208 | 630492984.0000 | 11288947824 | 5 | NULL | |
srv_worker_thread | 3 | 1923029328 | 7538784 | 641009688.0000 | 1896248112 | 42 | NULL | |
srv_purge_thread | 3 | 1672407792 | 381755616 | 557469264.0000 | 756084912 | 36 | NULL | |
srv_worker_thread | 2 | 1014533520 | 13000944 | 507266760.0000 | 1001532576 | 38 | NULL | |
clone_gtid_thread | 5 | 949056240 | 8479152 | 189811248.0000 | 330066528 | 35 | NULL |
|