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 | 214 | 3134873267856 | 50260320 | 14648940504.0000 | 40162652112 | 18 | NULL | |
page_flush_coordinator_thread | 881 | 1205927084736 | 3949440 | 3041426520.0000 | 199632995232 | 13 | NULL | |
io_write_thread | 76 | 853652721504 | 1542042480 | 11232272568.0000 | 23412601344 | 9 | NULL | |
log_checkpointer_thread | 74 | 495964336560 | 11194656 | 6412596432.0000 | 22053263232 | 15 | NULL | |
io_write_thread | 37 | 460203822144 | 53481648 | 12437941032.0000 | 44827156176 | 10 | NULL | |
io_write_thread | 14 | 132051321072 | 2172278592 | 9432237144.0000 | 24020139264 | 11 | NULL | |
main | 148 | 94373645520 | 74976 | 378993516.0000 | 24308389776 | 1 | NULL | |
log_writer_thread | 341 | 91847960688 | 504768 | 269348640.0000 | 9908188224 | 20 | NULL | |
io_write_thread | 3 | 75194796864 | 13407181392 | 25064932200.0000 | 43057529856 | 12 | NULL | |
clone_gtid_thread | 5 | 1700968896 | 6545088 | 340193568.0000 | 855923904 | 35 | NULL | |
dict_stats_thread | 2 | 1443540384 | 606466080 | 721770192.0000 | 837074304 | 26 | NULL | |
srv_worker_thread | 2 | 902510928 | 9095856 | 451255464.0000 | 893415072 | 42 | NULL | |
srv_purge_thread | 2 | 441835152 | 154565136 | 220917576.0000 | 287270016 | 36 | NULL | |
srv_worker_thread | 1 | 258696768 | 258696768 | 258696768.0000 | 258696768 | 40 | NULL | |
io_read_thread | 4 | 158869392 | 15480960 | 39717216.0000 | 66701184 | 5 | NULL | |
srv_worker_thread | 3 | 87057168 | 8800176 | 29018880.0000 | 48964608 | 38 | NULL |
|