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 | 261 | 3477053198256 | 98063856 | 13322042712.0000 | 121178768832 | 18 | NULL | |
page_flush_coordinator_thread | 696 | 513524285472 | 3591456 | 381033444.0000 | 41130695232 | 13 | NULL | |
io_write_thread | 29 | 388686400080 | 3834430512 | 13402979304.0000 | 31808130816 | 9 | NULL | |
io_write_thread | 31 | 374336621472 | 1612329840 | 12075374784.0000 | 33748493328 | 10 | NULL | |
log_checkpointer_thread | 38 | 270613722720 | 12782880 | 7121413728.0000 | 19352762880 | 15 | NULL | |
log_writer_thread | 496 | 184848250224 | 535392 | 372677712.0000 | 53808944112 | 20 | NULL | |
main | 149 | 130052039040 | 74976 | 527489490.0000 | 35238155040 | 1 | NULL | |
io_write_thread | 9 | 117106373472 | 1664929728 | 13011819216.0000 | 25585944384 | 11 | NULL | |
root@192.168.30.20 | 70 | 109031568624 | 800976 | 3267149952.0000 | 15483586800 | 1091 | 1031 | |
srv_worker_thread | 2 | 1832660016 | 12515184 | 916330008.0000 | 1820144832 | 40 | NULL | |
srv_worker_thread | 1 | 1819087776 | 1819087776 | 1819087776.0000 | 1819087776 | 38 | NULL | |
clone_gtid_thread | 4 | 811490592 | 11923296 | 202872648.0000 | 406834032 | 35 | NULL | |
srv_purge_thread | 2 | 765410448 | 276835152 | 382705224.0000 | 488575296 | 36 | NULL | |
srv_worker_thread | 2 | 26405280 | 7016064 | 13202640.0000 | 19389216 | 42 | NULL | |
io_read_thread | 1 | 24934272 | 24934272 | 24934272.0000 | 24934272 | 5 | NULL |
|