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 | 233 | 3443189660592 | 55874544 | 14777637864.0000 | 96501435888 | 18 | NULL | |
page_flush_coordinator_thread | 870 | 1142595118368 | 5117904 | 702103908.0000 | 47497571616 | 13 | NULL | |
io_write_thread | 93 | 1086640686912 | 1482148800 | 11684308416.0000 | 36567864432 | 9 | NULL | |
log_checkpointer_thread | 96 | 690759059232 | 9021408 | 7195406856.0000 | 22474362240 | 15 | NULL | |
io_write_thread | 34 | 390482472336 | 1668095616 | 11484778536.0000 | 38803972416 | 10 | NULL | |
io_write_thread | 19 | 204994623504 | 4060920864 | 10789190544.0000 | 17805363840 | 11 | NULL | |
log_writer_thread | 357 | 157937671056 | 491568 | 442402224.0000 | 66806007312 | 20 | NULL | |
main | 149 | 143124574560 | 74976 | 526170579.0000 | 43713885072 | 1 | NULL | |
io_write_thread | 8 | 75282320784 | 2048103024 | 9410290032.0000 | 15552954912 | 12 | NULL | |
srv_worker_thread | 2 | 1007641536 | 308272800 | 503820768.0000 | 699368736 | 40 | NULL | |
srv_purge_thread | 2 | 867839280 | 381601440 | 433919640.0000 | 486237840 | 36 | NULL | |
clone_gtid_thread | 5 | 821716368 | 4411440 | 164343168.0000 | 277203696 | 35 | NULL | |
srv_worker_thread | 2 | 748693440 | 7493376 | 374346720.0000 | 741200064 | 42 | NULL | |
io_read_thread | 14 | 539346192 | 27781248 | 38524728.0000 | 64487808 | 5 | NULL | |
srv_worker_thread | 2 | 32229648 | 9870960 | 16114824.0000 | 22358688 | 38 | NULL |
|