Neo4j Backup/Recovery + Warm-up and Execution Plan Practice

Backup and Recovery

Stop Service

./bin/neo4j stop

Backup Data

./bin/neo4j-admin dump --database=graph.db --to=/root/wzk_neo4j.dump

Migrate Data

./bin/neo4j-admin load --from=/root/wzk_neo4j.dump --database=graph.db --force

Restart Service

./bin/neo4j start

Optimization Strategies

Configuration File Optimization

dbms.memory.heap.initial_size=1g
dbms.memory.heap.max_size=16g
dbms.memory.pagecache.size=2g

Data Warm-up

MATCH (n)
OPTIONAL MATCH (n)-[r]->()
RETURN count(n.name) + count(r);

Execution Plan

EXPLAIN

EXPLAIN MATCH (p:Person)-[:FRIEND]->(f) RETURN p.name, f.name

PROFILE

PROFILE MATCH (p:Person)-[:FRIEND]->(f) RETURN p.name, f.name