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 | 116 | 1354690488624 | 45896400 | 11678366040.0000 | 28964754192 | 18 | NULL | |
page_flush_coordinator_thread | 486 | 502248375552 | 4088304 | 997624848.0000 | 94718206704 | 13 | NULL | |
io_write_thread | 29 | 299982394800 | 1579618656 | 10344220392.0000 | 22287556896 | 9 | NULL | |
log_checkpointer_thread | 24 | 150242706240 | 12735360 | 6260112672.0000 | 19688963712 | 15 | NULL | |
io_write_thread | 9 | 95552859600 | 1624398864 | 10616984400.0000 | 19820788944 | 12 | NULL | |
main | 133 | 50087625984 | 101376 | 228868134.0000 | 16244002896 | 1 | NULL | |
log_writer_thread | 175 | 23488094256 | 492096 | 134217600.0000 | 4547185104 | 20 | NULL | |
clone_gtid_thread | 4 | 974099808 | 231765600 | 243524952.0000 | 269459520 | 35 | NULL | |
buf_dump_thread | 2 | 241867824 | 8479152 | 120933912.0000 | 233388672 | 34 | NULL |
|