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 | 154 | 2185919761344 | 1537216032 | 14194283928.0000 | 50978496624 | 18 | NULL | |
page_flush_coordinator_thread | 608 | 585534069120 | 4480608 | 963049296.0000 | 44184448704 | 13 | NULL | |
io_write_thread | 29 | 416014353744 | 2625871248 | 14345322288.0000 | 33182450928 | 9 | NULL | |
log_checkpointer_thread | 34 | 291405838416 | 19738752 | 8570759736.0000 | 38840390688 | 15 | NULL | |
io_write_thread | 22 | 226762101456 | 1484837376 | 10307368104.0000 | 19114106880 | 10 | NULL | |
io_write_thread | 15 | 193194681504 | 3184353744 | 12879645240.0000 | 24344365056 | 11 | NULL | |
main | 149 | 110563764960 | 74448 | 430182423.0000 | 33885556320 | 1 | NULL | |
io_write_thread | 5 | 66469349760 | 8560337280 | 13293869952.0000 | 23531148960 | 12 | NULL | |
log_writer_thread | 247 | 43858557072 | 510576 | 177564816.0000 | 8936456496 | 20 | NULL | |
srv_purge_thread | 2 | 3773966592 | 293573808 | 1886983296.0000 | 3480392784 | 36 | NULL | |
srv_worker_thread | 2 | 1885124736 | 6692400 | 942562368.0000 | 1878432336 | 38 | NULL | |
clone_gtid_thread | 4 | 610143072 | 14196864 | 152535768.0000 | 326400096 | 35 | NULL | |
root@192.168.30.20 | 1 | 333574032 | 333574032 | 333574032.0000 | 333574032 | 497 | 421 | |
io_read_thread | 1 | 46700544 | 46700544 | 46700544.0000 | 46700544 | 5 | NULL | |
srv_worker_thread | 2 | 36838032 | 7651248 | 18419016.0000 | 29186784 | 42 | NULL |
|