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 | 358 | 5018856492672 | 52082976 | 14019152136.0000 | 82301119824 | 18 | NULL | |
page_flush_coordinator_thread | 1442 | 1552987305408 | 3765696 | 893352768.0000 | 48279925056 | 13 | NULL | |
io_write_thread | 106 | 1156279978656 | 1501750272 | 10908301536.0000 | 33686801808 | 9 | NULL | |
log_checkpointer_thread | 96 | 689782200096 | 11801856 | 7185231240.0000 | 24230179248 | 15 | NULL | |
io_write_thread | 54 | 614875792080 | 1575502368 | 11386588488.0000 | 30916780224 | 10 | NULL | |
io_write_thread | 19 | 278736242400 | 1716780912 | 14670328464.0000 | 41390357712 | 11 | NULL | |
log_writer_thread | 593 | 185434389360 | 533280 | 312705360.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 | |
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 |
|