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 | 55 | 836163039360 | 1359798000 | 15202964304.0000 | 91923457824 | 18 | NULL | |
page_flush_coordinator_thread | 197 | 116234565216 | 4550832 | 590023104.0000 | 40762242048 | 13 | NULL | |
io_write_thread | 12 | 97083353136 | 1644435936 | 8090279208.0000 | 15733438512 | 9 | NULL | |
main | 147 | 87146979216 | 82368 | 350560551.0000 | 26377545216 | 1 | NULL | |
log_checkpointer_thread | 8 | 61644047520 | 11229504 | 7705505808.0000 | 25620164064 | 15 | NULL | |
io_write_thread | 4 | 49916232960 | 8801771088 | 12479058240.0000 | 18288906240 | 12 | NULL | |
log_writer_thread | 88 | 49771937424 | 492624 | 565590168.0000 | 35681413680 | 20 | NULL | |
io_write_thread | 4 | 45674714976 | 5409052176 | 11418678744.0000 | 18346202160 | 10 | NULL | |
root@192.168.30.20 | 23 | 2238234768 | 3052896 | 97314360.0000 | 470461728 | 395 | 355 | |
clone_gtid_thread | 5 | 880767888 | 5367120 | 176153472.0000 | 301839648 | 35 | NULL | |
root@192.168.30.20 | 1 | 300687024 | 300687024 | 300687024.0000 | 300687024 | 404 | 360 | |
srv_purge_thread | 1 | 207395232 | 207395232 | 207395232.0000 | 207395232 | 36 | NULL | |
srv_worker_thread | 3 | 104073024 | 4961088 | 34690920.0000 | 91311264 | 38 | NULL | |
srv_worker_thread | 2 | 40649664 | 14979888 | 20324832.0000 | 25669776 | 42 | NULL |
|