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 | 849 | 12385131983664 | 103609968 | 14587905552.0000 | 66941210160 | 18 | NULL | |
page_flush_coordinator_thread | 3193 | 3788960865360 | 3361248 | 1347667860.0000 | 176545611792 | 13 | NULL | |
io_write_thread | 208 | 2452275180432 | 1436394432 | 11789784336.0000 | 39355584576 | 9 | NULL | |
log_checkpointer_thread | 230 | 1914861475824 | 5904096 | 8325484464.0000 | 107173599456 | 15 | NULL | |
io_write_thread | 103 | 1058641465200 | 184740336 | 10278072288.0000 | 40688590800 | 10 | NULL | |
io_write_thread | 85 | 999043180608 | 1511779104 | 11753448960.0000 | 32336895360 | 11 | NULL | |
io_write_thread | 54 | 620340335472 | 1600459872 | 11487783912.0000 | 36228742704 | 12 | NULL | |
log_writer_thread | 1428 | 381912371280 | 482064 | 267445464.0000 | 9234514080 | 20 | NULL | |
main | 147 | 91070899392 | 72336 | 373766283.0000 | 34473055056 | 1 | NULL | |
srv_purge_thread | 2 | 5087412000 | 1941837216 | 2543706000.0000 | 3145574784 | 36 | NULL | |
srv_worker_thread | 1 | 1498616592 | 1498616592 | 1498616592.0000 | 1498616592 | 40 | NULL | |
clone_gtid_thread | 5 | 690216912 | 6070416 | 138043224.0000 | 343058496 | 35 | NULL | |
io_read_thread | 19 | 511027968 | 18431424 | 26896056.0000 | 48825216 | 5 | NULL | |
srv_worker_thread | 4 | 301533936 | 6751536 | 75383352.0000 | 262234368 | 38 | NULL | |
root@192.168.30.20 | 4 | 206203536 | 777744 | 51550752.0000 | 174806016 | 6455 | 6103 | |
srv_worker_thread | 2 | 33731808 | 14672592 | 16865904.0000 | 19059216 | 42 | NULL |
|