Don't use cache type strong It will just gc all the time I changed your settings inline
Which version are you using? Sent from mobile device Am 24.04.2014 um 16:11 schrieb Alx <[email protected]>: > I have a neo4j db with 1M nodes and 10M relationships running on my local > computer (16GB RAM, 4-core i7). The configuration of the server is as follows: > > neo4j.properties: > neostore.nodestore.db.mapped_memory=25M > neostore.relationshipstore.db.mapped_memory=500M > neostore.propertystore.db.mapped_memory=300M > neostore.propertystore.db.strings.mapped_memory=300M > neostore.propertystore.db.arrays.mapped_memory=0M > cache_type=weak > > neo4j-wrapper.conf: > wrapper.java.initmemory=1512 > wrapper.java.maxmemory=8000 > > > I am running the following query: > > MATCH (m:User)-[:REL1]->(a) - [:REL2]-> (b) With m, b, count(*) as cnt > Match (b)<-[:REL1]-(n) RETURN m.id AS From ,n.id AS To, count(*)*cnt AS > Number Reduce the intermediate count of b's with the aggregation > > The query makes the heap size increase until it hits 11Gib on the memory. > Then the server just struggles (loses connection, re-connects) for a few > hours and eventually it dies with either this error: > > ERROR (-v for expanded information): > > Error unmarshaling return header; nested exception is: > > java.net.SocketException: Operation timed out > > > > or this error: > > ERROR (-v for expanded information): > > Error occurred in server thread; nested exception is: > > java.lang.OutOfMemoryError: Java heap space > > > > I know that [:REL2] are roughly 8M. I don't know what else I can do to fix > this. Perhaps the query needs to be optimized but I don't know how I can make > it simpler because [:REL2] is important to use. Any thoughts or suggestions > would be much appreciated. > > > > -- > You received this message because you are subscribed to the Google Groups > "Neo4j" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
