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 | 150 | 2057338384992 | 55995984 | 13715589096.0000 | 112016008896 | 18 | NULL | |
io_write_thread | 64 | 651474142176 | 1527874656 | 10179283224.0000 | 29574082560 | 9 | NULL | |
page_flush_coordinator_thread | 566 | 565254477744 | 3906144 | 520173324.0000 | 50922009072 | 13 | NULL | |
log_checkpointer_thread | 54 | 354081616944 | 7915248 | 6557066736.0000 | 18285725040 | 15 | NULL | |
io_write_thread | 24 | 228472371072 | 1600070736 | 9519682128.0000 | 27596593200 | 10 | NULL | |
main | 149 | 130200155184 | 133056 | 500526312.0000 | 37563417408 | 1 | NULL | |
log_writer_thread | 217 | 122449193328 | 536976 | 564281784.0000 | 64215013104 | 20 | NULL | |
io_write_thread | 8 | 59220331104 | 1635312624 | 7402541256.0000 | 11476723104 | 12 | NULL | |
io_write_thread | 3 | 18608848896 | 1648885392 | 6202949544.0000 | 10943420400 | 11 | NULL | |
srv_purge_thread | 2 | 4493234592 | 865760544 | 2246617296.0000 | 3627474048 | 36 | NULL | |
srv_worker_thread | 1 | 1844156160 | 1844156160 | 1844156160.0000 | 1844156160 | 40 | NULL | |
clone_gtid_thread | 5 | 966612240 | 10164528 | 193322448.0000 | 385512864 | 35 | NULL | |
io_read_thread | 1 | 53706576 | 53706576 | 53706576.0000 | 53706576 | 5 | NULL | |
srv_worker_thread | 3 | 47591808 | 7442688 | 15863760.0000 | 23385120 | 42 | NULL | |
srv_worker_thread | 2 | 19416144 | 6519744 | 9708072.0000 | 12896400 | 38 | NULL |
|