heap config
dbms.memory.heap.initial_size=32g
dbms.memory.heap.max_size=32g
dbms.memory.pagecache.size=16g
physical memory
128G
neo4j version
4.4.3 community
I use show transaction to filter long-time query, find some query estimatedUsedHeapMemory big than 32G, even up to 100G and this query triggers off neo4j Full GC with high level full CPU used that leads to neo4j cannot server.
I want to know how to convert estimatedUsedHeapMemory to physical so i can limit the query used memory.
Add transaction result:
{
"results": [
{
"columns": [
"txId",
"elapsedTimeMillis",
"currentQuery",
"parameters",
"username",
"estimatedUsedHeapMemory",
"cpuTimeMillis",
"waitTimeMillis",
"idleTimeMillis"
],
"data": [
{
"row": [
"neo4j-transaction-1029604",
98548,
"\n MATCH p = allShortestPaths( (a:Company)-[:EMPLOY|INVEST|LEGAL|BRANCH|HISEMPLOY|HISINVEST|HISLEGAL*..15]-(b:Company) ) \n WHERE\n a.keyNo=$sid AND b.keyNo=$eid\n RETURN p\n LIMIT 40",
{
"eid": "bb8373d20beb13a0ea741b0c2419b06",
"sid": "744cb4758f9f63e3376a8e2dd36f902"
},
"***",
43651311344,
0,
0,
98548
],
"meta": [
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null
]
}
]
}
],
"errors": []
}