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 | 85 | 1208954888064 | 137265216 | 14222998680.0000 | 116586134544 | 18 | NULL | |
log_writer_thread | 128 | 805787109072 | 475728 | 6295211736.0000 | 784607730192 | 20 | NULL | |
io_write_thread | 16 | 207126967344 | 3945952032 | 12945435360.0000 | 26165356272 | 9 | NULL | |
page_flush_coordinator_thread | 262 | 139876528176 | 4498560 | 287150820.0000 | 46641572208 | 13 | NULL | |
main | 149 | 103985730288 | 74976 | 417073404.0000 | 26362897440 | 1 | NULL | |
log_checkpointer_thread | 8 | 58838755008 | 34333728 | 7354844376.0000 | 16579713744 | 15 | NULL | |
srv_worker_thread | 3 | 2336342976 | 14120832 | 778780992.0000 | 1974680928 | 40 | NULL | |
root@192.168.30.20 | 1 | 2045710128 | 2045710128 | 2045710128.0000 | 2045710128 | 463 | 359 | |
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 | 1 | 310557456 | 310557456 | 310557456.0000 | 310557456 | 36 | NULL |
|