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 | 217 | 3049219546032 | 103251456 | 14051702808.0000 | 116586134544 | 18 | NULL | |
io_write_thread | 92 | 1050974727792 | 1509924240 | 11423638248.0000 | 29877885312 | 9 | NULL | |
log_writer_thread | 321 | 840610823712 | 475728 | 2618725296.0000 | 784607730192 | 20 | NULL | |
page_flush_coordinator_thread | 732 | 796006466640 | 3256176 | 581900352.0000 | 46641572208 | 13 | NULL | |
log_checkpointer_thread | 68 | 516305694960 | 10271184 | 7592730552.0000 | 21819504960 | 15 | NULL | |
io_write_thread | 11 | 110967131616 | 2358409680 | 10087921008.0000 | 15568625952 | 11 | NULL | |
main | 149 | 103985730288 | 74976 | 417073404.0000 | 26362897440 | 1 | NULL | |
io_write_thread | 8 | 99277851024 | 4096796352 | 12409731312.0000 | 24761002992 | 12 | NULL | |
io_write_thread | 9 | 74844319440 | 1508885664 | 8316035376.0000 | 23830715568 | 10 | NULL | |
srv_worker_thread | 3 | 2336342976 | 14120832 | 778780992.0000 | 1974680928 | 40 | NULL | |
srv_worker_thread | 3 | 1282280208 | 17129376 | 427426560.0000 | 1243636416 | 42 | NULL | |
clone_gtid_thread | 5 | 1255386000 | 10012464 | 251077200.0000 | 417446832 | 35 | NULL | |
io_read_thread | 15 | 762462624 | 27610176 | 50830824.0000 | 142800240 | 5 | NULL | |
srv_purge_thread | 2 | 601976496 | 291419040 | 300988248.0000 | 310557456 | 36 | NULL |
|