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 | 559 | 8039892263040 | 378235440 | 14382633672.0000 | 759949264272 | 18 | NULL | |
page_flush_coordinator_thread | 1307 | 984250357728 | 4159056 | 402219048.0000 | 60414614832 | 13 | NULL | |
io_write_thread | 73 | 943302134016 | 1515326736 | 12921947016.0000 | 43460415504 | 9 | NULL | |
log_checkpointer_thread | 64 | 439425719040 | 9693552 | 6866026728.0000 | 22028318400 | 15 | NULL | |
io_write_thread | 18 | 337739658432 | 1668425088 | 18763314240.0000 | 43626520080 | 11 | NULL | |
io_write_thread | 27 | 315272502336 | 1667758752 | 11676759336.0000 | 37101748464 | 10 | NULL | |
log_writer_thread | 1263 | 249046603872 | 481008 | 197186352.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 |
|