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 | 927 | 13343462646624 | 82578144 | 14394242280.0000 | 66941210160 | 18 | NULL | |
page_flush_coordinator_thread | 3620 | 4061417406288 | 3361248 | 888332544.0000 | 176545611792 | 13 | NULL | |
io_write_thread | 246 | 2724822634512 | 1436394432 | 11076514680.0000 | 39355584576 | 9 | NULL | |
log_checkpointer_thread | 258 | 2075606780016 | 5904096 | 8044987368.0000 | 107173599456 | 15 | NULL | |
io_write_thread | 109 | 1109796312240 | 184740336 | 10181617512.0000 | 40688590800 | 10 | NULL | |
io_write_thread | 94 | 1076148573456 | 1488872352 | 11448389040.0000 | 32336895360 | 11 | NULL | |
io_write_thread | 54 | 620340335472 | 1600459872 | 11487783912.0000 | 36228742704 | 12 | NULL | |
log_writer_thread | 1542 | 409048382688 | 482064 | 265271160.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 | 20 | 528865920 | 17837952 | 26443296.0000 | 48825216 | 5 | NULL | |
srv_worker_thread | 4 | 301533936 | 6751536 | 75383352.0000 | 262234368 | 38 | NULL | |
srv_worker_thread | 2 | 33731808 | 14672592 | 16865904.0000 | 19059216 | 42 | NULL |
|