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 | 47 | 716501519184 | 109369920 | 15244713000.0000 | 42879279696 | 18 | NULL | |
page_flush_coordinator_thread | 260 | 293120220624 | 3767808 | 1127385336.0000 | 48456462384 | 13 | NULL | |
io_write_thread | 12 | 180042773328 | 2833107552 | 15003564312.0000 | 27687953568 | 9 | NULL | |
main | 148 | 111570286608 | 90288 | 464172060.0000 | 30702057936 | 1 | NULL | |
log_checkpointer_thread | 12 | 86801547888 | 25561536 | 7233462192.0000 | 16686993312 | 15 | NULL | |
io_write_thread | 4 | 60010895472 | 7920242352 | 15002723736.0000 | 26995960992 | 12 | NULL | |
io_write_thread | 4 | 39986572560 | 7137654480 | 9996643008.0000 | 17463852912 | 10 | NULL | |
io_write_thread | 4 | 33844660080 | 6237457248 | 8461164888.0000 | 11063401008 | 11 | NULL | |
log_writer_thread | 79 | 19636533312 | 704352 | 248563656.0000 | 6403632048 | 20 | NULL | |
root@192.168.30.20 | 3 | 2587116576 | 348522768 | 862372104.0000 | 1873059936 | 257 | 217 | |
srv_worker_thread | 1 | 1857827136 | 1857827136 | 1857827136.0000 | 1857827136 | 38 | NULL | |
clone_gtid_thread | 5 | 1733745552 | 7625904 | 346748952.0000 | 925388112 | 35 | NULL | |
srv_purge_thread | 1 | 438883632 | 438883632 | 438883632.0000 | 438883632 | 36 | NULL | |
srv_worker_thread | 1 | 10610688 | 10610688 | 10610688.0000 | 10610688 | 42 | NULL |
|