Hello Neo4j Guru's,
I know this question has been asked already in previous posts (which I have
read) but I feel like something else is causing my issue maybe.
To lay out as much as I can, I have been assigned to manage a database
based off of Neo4j version 2.0.0 with a database size of ~250 Gigabytes.
The problem my team has been encountering is ridiculously slow database
querying (from 30 minutes to an hour before receiving results). The queries
are executed using the web front end on the webadmin page. Below are the
details for the graph nodes and relationship details to get an ideal of the
size of the database I am dealing with. I am wondering if the sheer size of
the database is the cause for such a slow query performance or is there
something else that may be going on which I must look into.
Test Query (With actual label information removed for privacy reasons):
MATCH (n) WHERE has(n.`person`) RETURN DISTINCT "node" as element,
n.`person` AS `person` LIMIT 25 UNION ALL MATCH ()-[r]-() WHERE
has(r.`person`) RETURN DISTINCT "relationship" AS element, r.`person` AS
`person` LIMIT 25
*The server Configuration:*
CPU's: 24x E5-2630 2.30 GHz
Memory: 125 Gigabytes of DDR3
Hard disk: 5 Terrabytes
*JVM Settings manually set (in neo4j-wrapper.conf):*
# Initial Java Heap Size (in MB)
wrapper.java.initmemory=16
# Maximum Java Heap Size (in MB)
wrapper.java.maxmemory=32768
*Linux system settings manually set:*
ulimit set to 40000
under /etc/sysctl.conf:
vm.dirty_background_ratio = 50
vm.dirty_ratio = 80
*Node and relation information:*
"description": "Estimates of the numbers of different kinds of Neo4j
primitives",
"description": "An estimation of the number of nodes used in this Neo4j
instance",
"name": "NumberOfNodeIdsInUse",
"value": 255857300,
"description": "An estimation of the number of relationships used in
this Neo4j instance",
"name": "NumberOfRelationshipIdsInUse",
"value": 375613862,
"description": "An estimation of the number of properties used in this
Neo4j instance",
"name": "NumberOfPropertyIdsInUse",
"value": 1518707868,
"description": "The number of relationship types used in this Neo4j
instance",
"name": "NumberOfRelationshipTypeIdsInUse",
"value": 8,
I want to apologize in advance for my lack of knowledge of Neo4j but I am
willing to learn as much as I can to fix this issue.
Sincerely,
JP
--
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.
