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 | 260 | 3686993147376 | 52082976 | 14180742840.0000 | 82301119824 | 18 | NULL | |
page_flush_coordinator_thread | 1032 | 1141370216976 | 3765696 | 1059533904.0000 | 48279925056 | 13 | NULL | |
io_write_thread | 78 | 904902169248 | 1648298784 | 11601309720.0000 | 33686801808 | 9 | NULL | |
log_checkpointer_thread | 72 | 513035972064 | 12184128 | 7125499392.0000 | 24230179248 | 15 | NULL | |
io_write_thread | 42 | 459017633712 | 1575502368 | 10928991216.0000 | 30916780224 | 10 | NULL | |
io_write_thread | 11 | 178287769968 | 1716780912 | 16207979040.0000 | 41390357712 | 11 | NULL | |
log_writer_thread | 411 | 148621878240 | 533280 | 361610304.0000 | 44005884912 | 20 | NULL | |
main | 148 | 104012582256 | 73392 | 422972154.0000 | 26150281872 | 1 | NULL | |
io_write_thread | 8 | 83502196272 | 3881392944 | 10437774336.0000 | 21604123728 | 12 | NULL | |
srv_worker_thread | 1 | 1431534720 | 1431534720 | 1431534720.0000 | 1431534720 | 40 | NULL | |
clone_gtid_thread | 5 | 1134109680 | 7498656 | 226821936.0000 | 428427648 | 35 | NULL | |
srv_purge_thread | 2 | 516732480 | 242008800 | 258366240.0000 | 274723680 | 36 | NULL | |
srv_worker_thread | 2 | 41855616 | 20147424 | 20927808.0000 | 21708192 | 42 | NULL | |
srv_worker_thread | 2 | 30682608 | 9462288 | 15341304.0000 | 21220320 | 38 | NULL |
|