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 | 30 | 415540084608 | 56628528 | 13851336048.0000 | 34635868608 | 18 | NULL | |
io_write_thread | 8 | 190846732560 | 3073796880 | 23855841504.0000 | 76480994832 | 9 | NULL | |
page_flush_coordinator_thread | 185 | 104080327296 | 4354944 | 295810284.0000 | 40990920432 | 13 | NULL | |
main | 148 | 91770568032 | 73392 | 371244786.0000 | 35562330672 | 1 | NULL | |
log_checkpointer_thread | 6 | 43205175024 | 13277088 | 7200862416.0000 | 16675447536 | 15 | NULL | |
io_write_thread | 4 | 33194811408 | 6218630880 | 8298702720.0000 | 10739080176 | 10 | NULL | |
log_writer_thread | 48 | 4965911808 | 478896 | 103456320.0000 | 3811570224 | 20 | NULL | |
srv_purge_thread | 1 | 1153696896 | 1153696896 | 1153696896.0000 | 1153696896 | 36 | NULL | |
srv_worker_thread | 3 | 1085840448 | 7770048 | 361946640.0000 | 1070032128 | 38 | NULL | |
srv_worker_thread | 1 | 847427856 | 847427856 | 847427856.0000 | 847427856 | 40 | NULL | |
clone_gtid_thread | 4 | 537123312 | 10973952 | 134280696.0000 | 285657504 | 35 | NULL | |
srv_worker_thread | 2 | 271032432 | 13633488 | 135516216.0000 | 257398944 | 42 | NULL |
|