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 | 72 | 1096163892384 | 5399032320 | 15224498256.0000 | 48403654464 | 18 | NULL | |
page_flush_coordinator_thread | 286 | 342089814528 | 4546608 | 632661744.0000 | 42920203920 | 13 | NULL | |
io_write_thread | 22 | 290858729568 | 2545642704 | 13220851248.0000 | 33367352832 | 9 | NULL | |
log_checkpointer_thread | 28 | 221580524352 | 12325632 | 7913590080.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 | 110 | 14093059728 | 805728 | 128118672.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 |
|