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 | 1259 | 16193547318432 | 49141488 | 12862229688.0000 | 96495447312 | 18 | NULL | |
page_flush_coordinator_thread | 4570 | 3397409900016 | 3359136 | 393697392.0000 | 40693117344 | 13 | NULL | |
io_write_thread | 219 | 2117346778800 | 1458692400 | 9668249976.0000 | 29539728768 | 9 | NULL | |
io_write_thread | 131 | 1331276902560 | 74345568 | 10162418904.0000 | 30187727856 | 10 | NULL | |
log_checkpointer_thread | 190 | 1240246536672 | 7421568 | 6527613312.0000 | 20361488400 | 15 | NULL | |
io_write_thread | 75 | 725207866416 | 130597632 | 9669437976.0000 | 33931657056 | 11 | NULL | |
log_writer_thread | 2075 | 507465770592 | 479424 | 244561680.0000 | 32724399840 | 20 | NULL | |
io_write_thread | 54 | 495697635312 | 1548654096 | 9179585712.0000 | 23424185664 | 12 | NULL | |
main | 148 | 110731385424 | 75504 | 420373602.0000 | 29582725920 | 1 | NULL | |
srv_purge_thread | 6 | 13228141344 | 196170480 | 2204690136.0000 | 4940933184 | 36 | NULL | |
clone_gtid_thread | 4 | 649659648 | 10379424 | 162414912.0000 | 346418688 | 35 | NULL | |
srv_worker_thread | 2 | 271591056 | 13981440 | 135795528.0000 | 257609616 | 38 | NULL | |
srv_worker_thread | 2 | 38792688 | 15886992 | 19396344.0000 | 22905696 | 42 | NULL |
|