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 | 775 | 10367468450592 | 52082976 | 13377378432.0000 | 82301119824 | 18 | NULL | |
page_flush_coordinator_thread | 2254 | 1986518088720 | 3531792 | 789877836.0000 | 48279925056 | 13 | NULL | |
io_write_thread | 129 | 1407478633440 | 1501750272 | 10910687040.0000 | 33686801808 | 9 | NULL | |
log_checkpointer_thread | 110 | 797904302976 | 11801856 | 7253675352.0000 | 25495469472 | 15 | NULL | |
io_write_thread | 61 | 732004165200 | 1575502368 | 12000068256.0000 | 38673528432 | 10 | NULL | |
io_write_thread | 27 | 383474500992 | 1716780912 | 14202759120.0000 | 41390357712 | 11 | NULL | |
log_writer_thread | 1635 | 381239238864 | 463056 | 233173776.0000 | 44005884912 | 20 | NULL | |
io_write_thread | 27 | 337318134912 | 3211937520 | 12493264080.0000 | 26194997664 | 12 | NULL | |
main | 148 | 104012582256 | 73392 | 422972154.0000 | 26150281872 | 1 | NULL | |
srv_purge_thread | 4 | 2823550224 | 242008800 | 705887424.0000 | 1602620976 | 36 | NULL | |
srv_worker_thread | 1 | 1431534720 | 1431534720 | 1431534720.0000 | 1431534720 | 40 | NULL | |
clone_gtid_thread | 5 | 1134109680 | 7498656 | 226821936.0000 | 428427648 | 35 | NULL | |
io_read_thread | 8 | 222812832 | 19899792 | 27851472.0000 | 43030416 | 5 | NULL | |
srv_worker_thread | 2 | 41855616 | 20147424 | 20927808.0000 | 21708192 | 42 | NULL | |
srv_worker_thread | 2 | 30682608 | 9462288 | 15341304.0000 | 21220320 | 38 | NULL |
|