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 | 142 | 2140969580640 | 1294176576 | 15077250408.0000 | 82301119824 | 18 | NULL | |
page_flush_coordinator_thread | 681 | 718402496064 | 3765696 | 1044945396.0000 | 48279925056 | 13 | NULL | |
io_write_thread | 54 | 578746220448 | 1648298784 | 10717522464.0000 | 33686801808 | 9 | NULL | |
log_checkpointer_thread | 42 | 285517476288 | 12184128 | 6798035112.0000 | 24230179248 | 15 | NULL | |
io_write_thread | 10 | 167638195824 | 1716780912 | 16763819424.0000 | 41390357712 | 11 | NULL | |
main | 148 | 104012582256 | 73392 | 422972154.0000 | 26150281872 | 1 | NULL | |
io_write_thread | 7 | 97550950464 | 4058918688 | 13935849840.0000 | 28059179808 | 10 | NULL | |
log_writer_thread | 221 | 94643882784 | 676368 | 428252616.0000 | 44005884912 | 20 | 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 |
|