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 | 78 | 1163272785312 | 5399032320 | 14913753624.0000 | 48403654464 | 18 | NULL | |
page_flush_coordinator_thread | 299 | 361858412784 | 4546608 | 639523500.0000 | 42920203920 | 13 | NULL | |
io_write_thread | 26 | 350370000288 | 2545642704 | 13475769120.0000 | 33367352832 | 9 | NULL | |
log_checkpointer_thread | 30 | 237006174768 | 12325632 | 7900205808.0000 | 24093117312 | 15 | NULL | |
io_write_thread | 15 | 140403653280 | 2000007504 | 9360243552.0000 | 14564704176 | 10 | NULL | |
main | 149 | 91615926336 | 90288 | 367977951.0000 | 32503599744 | 1 | NULL | |
io_write_thread | 7 | 87369330048 | 8807012544 | 12481332864.0000 | 17714278560 | 11 | NULL | |
log_writer_thread | 119 | 14189120352 | 805728 | 119236128.0000 | 3796757184 | 20 | NULL | |
srv_worker_thread | 1 | 1190216016 | 1190216016 | 1190216016.0000 | 1190216016 | 38 | NULL | |
clone_gtid_thread | 5 | 996572016 | 5940000 | 199314192.0000 | 343712688 | 35 | NULL | |
srv_purge_thread | 1 | 950505600 | 950505600 | 950505600.0000 | 950505600 | 36 | NULL | |
srv_worker_thread | 2 | 32332608 | 13639296 | 16166304.0000 | 18693312 | 40 | NULL | |
srv_worker_thread | 2 | 29103360 | 11160336 | 14551680.0000 | 17943024 | 42 | NULL |
|