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 | 105 | 1446609595728 | 50260320 | 13777234152.0000 | 39899451504 | 18 | NULL | |
io_write_thread | 37 | 405883273488 | 1542042480 | 10969818024.0000 | 23305522416 | 9 | NULL | |
page_flush_coordinator_thread | 356 | 361294361472 | 4747248 | 542260356.0000 | 42103072176 | 13 | NULL | |
log_checkpointer_thread | 28 | 187883663616 | 11824032 | 6431496060.0000 | 17826896736 | 15 | NULL | |
io_write_thread | 11 | 99667415760 | 1643480256 | 9060674040.0000 | 18229503072 | 10 | NULL | |
main | 148 | 94373645520 | 74976 | 378993516.0000 | 24308389776 | 1 | NULL | |
io_write_thread | 4 | 34502202240 | 2243378544 | 8625550560.0000 | 11798176896 | 11 | NULL | |
log_writer_thread | 165 | 30631961184 | 504768 | 185648232.0000 | 9908188224 | 20 | NULL | |
clone_gtid_thread | 5 | 1700968896 | 6545088 | 340193568.0000 | 855923904 | 35 | NULL | |
srv_worker_thread | 2 | 902510928 | 9095856 | 451255464.0000 | 893415072 | 42 | NULL | |
srv_purge_thread | 1 | 287270016 | 287270016 | 287270016.0000 | 287270016 | 36 | NULL | |
srv_worker_thread | 1 | 258696768 | 258696768 | 258696768.0000 | 258696768 | 40 | NULL | |
srv_worker_thread | 3 | 87057168 | 8800176 | 29018880.0000 | 48964608 | 38 | NULL | |
io_read_thread | 1 | 66701184 | 66701184 | 66701184.0000 | 66701184 | 5 | NULL |
|