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 | 145 | 2135432712864 | 1570263024 | 14727121992.0000 | 48403654464 | 18 | NULL | |
io_write_thread | 63 | 757283685840 | 1560787008 | 12020375928.0000 | 33367352832 | 9 | NULL | |
page_flush_coordinator_thread | 701 | 678620593728 | 3868656 | 563907960.0000 | 44957511984 | 13 | NULL | |
log_checkpointer_thread | 60 | 459295769328 | 6675504 | 7654929480.0000 | 24093117312 | 15 | NULL | |
io_write_thread | 14 | 177145945680 | 5160375792 | 12653281608.0000 | 23650333872 | 11 | NULL | |
io_write_thread | 15 | 140403653280 | 2000007504 | 9360243552.0000 | 14564704176 | 10 | NULL | |
main | 149 | 91615926336 | 90288 | 367977951.0000 | 32503599744 | 1 | NULL | |
log_writer_thread | 222 | 34613364720 | 732336 | 155916024.0000 | 5558126112 | 20 | NULL | |
srv_purge_thread | 2 | 4632645600 | 950505600 | 2316322800.0000 | 3682140000 | 36 | NULL | |
srv_worker_thread | 1 | 1190216016 | 1190216016 | 1190216016.0000 | 1190216016 | 38 | NULL | |
clone_gtid_thread | 5 | 996572016 | 5940000 | 199314192.0000 | 343712688 | 35 | NULL | |
io_read_thread | 13 | 487900512 | 23305920 | 37530768.0000 | 68719728 | 5 | NULL | |
srv_worker_thread | 2 | 32332608 | 13639296 | 16166304.0000 | 18693312 | 40 | NULL | |
srv_worker_thread | 2 | 29103360 | 11160336 | 14551680.0000 | 17943024 | 42 | NULL |
|