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 | 350 | 5005444519680 | 66559152 | 14301269928.0000 | 76599297984 | 18 | NULL | |
page_flush_coordinator_thread | 1122 | 1055331376176 | 3830112 | 502053552.0000 | 49959307728 | 13 | NULL | |
io_write_thread | 73 | 1018673551104 | 1602330048 | 13954432008.0000 | 49856624400 | 9 | NULL | |
io_write_thread | 41 | 464959973280 | 90487584 | 11340486960.0000 | 28506551568 | 10 | NULL | |
log_checkpointer_thread | 54 | 403362874464 | 11142384 | 7469682792.0000 | 25116688080 | 15 | NULL | |
log_writer_thread | 664 | 137238699312 | 474144 | 206684544.0000 | 13883658624 | 20 | NULL | |
io_write_thread | 11 | 111310548624 | 1488479520 | 10119140592.0000 | 15745898256 | 11 | NULL | |
main | 147 | 90047210880 | 74448 | 361966638.0000 | 20807105616 | 1 | NULL | |
io_write_thread | 6 | 66625992048 | 1819586208 | 11104331832.0000 | 26564074416 | 12 | NULL | |
srv_purge_thread | 3 | 1767689088 | 247439808 | 589229520.0000 | 845571936 | 36 | NULL | |
clone_gtid_thread | 5 | 1070255472 | 7479648 | 214050936.0000 | 365021184 | 35 | NULL | |
io_read_thread | 14 | 533911488 | 25151808 | 38136384.0000 | 97911264 | 5 | NULL | |
root@192.168.30.20 | 1 | 466903536 | 466903536 | 466903536.0000 | 466903536 | 1755 | 1559 | |
srv_worker_thread | 2 | 34944096 | 13867392 | 17472048.0000 | 21076704 | 40 | NULL | |
srv_worker_thread | 2 | 23584704 | 8298048 | 11792352.0000 | 15286656 | 42 | NULL |
|