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 | 850 | 12118146409248 | 187357632 | 14256642576.0000 | 66311226960 | 18 | NULL | |
page_flush_coordinator_thread | 2756 | 3465766549872 | 3587232 | 661828860.0000 | 145416731856 | 13 | NULL | |
io_write_thread | 212 | 2167615062624 | 1524967488 | 10224599352.0000 | 33773842080 | 9 | NULL | |
log_checkpointer_thread | 251 | 1827544015440 | 6946896 | 7281051624.0000 | 27527435232 | 15 | NULL | |
io_write_thread | 175 | 1647091762272 | 487312320 | 9411952704.0000 | 48142912224 | 10 | NULL | |
io_write_thread | 70 | 692952867024 | 1567733376 | 9899326536.0000 | 36502708704 | 11 | NULL | |
log_writer_thread | 1379 | 350300662272 | 491040 | 254025024.0000 | 22916586528 | 20 | NULL | |
io_write_thread | 25 | 277931729856 | 1616207472 | 11117269152.0000 | 27084268992 | 12 | NULL | |
main | 150 | 90628965504 | 72336 | 371723550.0000 | 30633299664 | 1 | NULL | |
srv_purge_thread | 2 | 4102289136 | 318943152 | 2051144568.0000 | 3783345984 | 36 | NULL | |
srv_worker_thread | 1 | 1648417056 | 1648417056 | 1648417056.0000 | 1648417056 | 40 | NULL | |
clone_gtid_thread | 5 | 1215696768 | 7249440 | 243139248.0000 | 413997408 | 35 | NULL | |
srv_worker_thread | 3 | 870694176 | 12174096 | 290231304.0000 | 450168576 | 42 | NULL | |
io_read_thread | 30 | 534761040 | 7576272 | 17825280.0000 | 41757936 | 5 | NULL | |
srv_worker_thread | 2 | 22464816 | 10203600 | 11232408.0000 | 12261216 | 38 | NULL |
|