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 | 268 | 4426624884000 | 110057904 | 16517256888.0000 | 627263526384 | 18 | NULL | |
page_flush_coordinator_thread | 1030 | 1148637632208 | 3263568 | 599746224.0000 | 51991809408 | 13 | NULL | |
io_write_thread | 75 | 829020334560 | 1660593264 | 11053604232.0000 | 22478911488 | 9 | NULL | |
io_write_thread | 63 | 678261696288 | 197782992 | 10766058600.0000 | 26514307776 | 10 | NULL | |
log_checkpointer_thread | 82 | 583612792224 | 7865616 | 7117229064.0000 | 24589463184 | 15 | NULL | |
io_write_thread | 13 | 205463323824 | 1691553600 | 15804870840.0000 | 40187314992 | 11 | NULL | |
log_writer_thread | 417 | 145109757408 | 592416 | 347985000.0000 | 60594212448 | 20 | NULL | |
main | 149 | 113103911712 | 71808 | 430522686.0000 | 27904120992 | 1 | NULL | |
srv_worker_thread | 3 | 2574798864 | 225187248 | 858266112.0000 | 2092815120 | 40 | NULL | |
srv_worker_thread | 2 | 2004054096 | 8462784 | 1002027048.0000 | 1995591312 | 42 | NULL | |
clone_gtid_thread | 5 | 987770784 | 16506864 | 197554104.0000 | 340705200 | 35 | NULL | |
srv_purge_thread | 2 | 521794944 | 249650544 | 260897472.0000 | 272144400 | 36 | NULL | |
srv_worker_thread | 2 | 24001296 | 6602640 | 12000648.0000 | 17398656 | 38 | NULL |
|