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 | 399 | 5834824736928 | 49768752 | 14623620792.0000 | 118629281232 | 18 | NULL | |
page_flush_coordinator_thread | 1833 | 2179467797232 | 3184896 | 969145056.0000 | 423927352992 | 13 | NULL | |
io_write_thread | 166 | 1599897715680 | 155264208 | 9637938024.0000 | 33401004912 | 9 | NULL | |
log_checkpointer_thread | 131 | 915967411392 | 5198688 | 6465368316.0000 | 26727980400 | 15 | NULL | |
io_write_thread | 41 | 368153829648 | 1555300560 | 8979361512.0000 | 22391353776 | 10 | NULL | |
log_writer_thread | 610 | 226227176736 | 464640 | 370864032.0000 | 67605338064 | 20 | NULL | |
io_write_thread | 21 | 197154237456 | 1683554400 | 9388296984.0000 | 21124882416 | 12 | NULL | |
io_write_thread | 15 | 133058835360 | 1701722880 | 8870589024.0000 | 18145633968 | 11 | NULL | |
main | 149 | 84112452864 | 73920 | 357818934.0000 | 28846138992 | 1 | NULL | |
srv_purge_thread | 2 | 4649508864 | 919141872 | 2324754432.0000 | 3730366992 | 36 | NULL | |
clone_gtid_thread | 5 | 879538176 | 5631648 | 175907424.0000 | 317042352 | 35 | NULL | |
srv_worker_thread | 3 | 353314368 | 10706256 | 117771456.0000 | 321914208 | 42 | NULL | |
srv_worker_thread | 2 | 19759872 | 7846080 | 9879936.0000 | 11913792 | 38 | NULL |
|