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 | 119 | 1435293148080 | 54513360 | 12061286952.0000 | 36951344496 | 18 | NULL | |
io_write_thread | 28 | 348460165680 | 1661611776 | 12445005672.0000 | 28599677040 | 9 | NULL | |
page_flush_coordinator_thread | 511 | 313182407472 | 4192848 | 319316976.0000 | 43876153728 | 13 | NULL | |
log_checkpointer_thread | 26 | 235873787424 | 8525088 | 9072068544.0000 | 66392231136 | 15 | NULL | |
main | 148 | 89970746448 | 74448 | 378313155.0000 | 33991386528 | 1 | NULL | |
io_write_thread | 8 | 86689229088 | 1500153600 | 10836153504.0000 | 18476998848 | 10 | NULL | |
io_write_thread | 4 | 39336824736 | 2424587088 | 9834206184.0000 | 14768280912 | 11 | NULL | |
log_writer_thread | 190 | 35450703552 | 495792 | 186582528.0000 | 7087074192 | 20 | NULL | |
srv_purge_thread | 2 | 6071495232 | 1818178032 | 3035747616.0000 | 4253317200 | 36 | NULL | |
root@192.168.30.20 | 1 | 1837759440 | 1837759440 | 1837759440.0000 | 1837759440 | 549 | 509 | |
srv_worker_thread | 2 | 1186072800 | 12161952 | 593036400.0000 | 1173910848 | 42 | NULL | |
clone_gtid_thread | 5 | 964300128 | 9183504 | 192859920.0000 | 438156576 | 35 | NULL | |
srv_worker_thread | 2 | 27070032 | 11757504 | 13535016.0000 | 15312528 | 38 | NULL |
|