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 | 127 | 1923709796976 | 129998880 | 15147321024.0000 | 142691531664 | 18 | NULL | |
page_flush_coordinator_thread | 419 | 450206141616 | 4110480 | 1074477624.0000 | 49997795232 | 13 | NULL | |
io_write_thread | 22 | 328179863616 | 2527652688 | 14917266408.0000 | 33329970432 | 9 | NULL | |
log_checkpointer_thread | 18 | 120628758096 | 8227824 | 6701597496.0000 | 18152441472 | 15 | NULL | |
io_write_thread | 8 | 91380079824 | 1965927216 | 11422509912.0000 | 16569060288 | 11 | NULL | |
main | 147 | 85296615888 | 74448 | 374123376.0000 | 28030063776 | 1 | NULL | |
io_write_thread | 8 | 63868762320 | 1796887488 | 7983595224.0000 | 12827240976 | 10 | NULL | |
log_writer_thread | 227 | 59729423952 | 480480 | 263125104.0000 | 8649007488 | 20 | NULL | |
srv_worker_thread | 2 | 1322033328 | 15728592 | 661016664.0000 | 1306304736 | 42 | NULL | |
clone_gtid_thread | 5 | 827703360 | 4580928 | 165540672.0000 | 305439024 | 35 | NULL | |
srv_worker_thread | 1 | 279832080 | 279832080 | 279832080.0000 | 279832080 | 40 | NULL | |
srv_purge_thread | 1 | 204151200 | 204151200 | 204151200.0000 | 204151200 | 36 | NULL | |
srv_worker_thread | 3 | 51787824 | 7787472 | 17262432.0000 | 32131440 | 38 | NULL |
|