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 | 318 | 4710109269888 | 49768752 | 14811664296.0000 | 118629281232 | 18 | NULL | |
page_flush_coordinator_thread | 1391 | 1703569038864 | 3379200 | 1053890244.0000 | 423927352992 | 13 | NULL | |
io_write_thread | 112 | 1055562675024 | 1567461456 | 9424666680.0000 | 33401004912 | 9 | NULL | |
log_checkpointer_thread | 95 | 624936680016 | 5198688 | 6256649520.0000 | 17439190032 | 15 | NULL | |
io_write_thread | 37 | 347190639312 | 1620161136 | 9383530728.0000 | 22391353776 | 10 | NULL | |
log_writer_thread | 476 | 210867346800 | 464640 | 442998600.0000 | 67605338064 | 20 | NULL | |
io_write_thread | 17 | 160685331840 | 1683554400 | 9452078328.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 |
|