Neo4j server on 100% cpu

hello everyone, I am facing weird issue with neo4j server. cpu is running on above 80% just for 20 connection and some frequent persistence requests .
48 GB ,12 Vpc instance is used .
initial and max heap set to 16g each
page cache set 16g
debug.log keep showing this warning

2020-05-10 00:39:06.251+0000 WARN [o.n.k.i.c.VmPauseMonitorComponent] Detected VM stop-the-world pause: {pauseTime=219, gcTime=235, gcCount=1}
2020-05-10 00:39:20.622+0000 WARN [o.n.k.i.c.VmPauseMonitorComponent] Detected VM stop-the-

query itself taking 0.02 millisecond but CPU is above 80% on just 20 connections. i have spend couple of days on it but unfortunately didn't succeed . quick help is highly appreciated .

1 Like

Most likely issue is that the queries are not tuned properly or are not using indexes. Can you do a profile on the queries that are running and post them?

1 Like