Geek Answers Handbook

How and when to delete old neo4j transaction log files

In my local Neo4j there are many transaction logs in data/graph.db :

 251M 3 Sep 16:44 neostore.transaction.db.0 255M 3 Sep 20:01 neostore.transaction.db.1 255M 3 Sep 23:20 neostore.transaction.db.2 251M 4 Sep 19:34 neostore.transaction.db.3 250M 4 Sep 22:16 neostore.transaction.db.4 134M 5 Sep 05:02 neostore.transaction.db.5 16B 5 Sep 09:57 neostore.transaction.db.6 16B 7 Sep 16:44 neostore.transaction.db.7

I keep the graph.db folder up (I stopped the neo4j instance) to reload in another remote instance, so it would be nice to reduce the size of the folder.

  • What are the methods for managing these logs?
  • How to check if this neostore.transaction.db.X file has neostore.transaction.db.X processed neostore.transaction.db.X ?
  • Is it safe to delete old processed files?

Logical logs are mentioned in documents that I believe are the same files: http://neo4j.com/docs/stable/configuration-logical-logs.html

In conf/neo4j.properties I changed the keep_logical_logs parameter to 100M size :

 # Keep logical logs, helps debugging but uses more disk space, enabled for # legacy reasons To limit space needed to store historical logs use values such # as: "7 days" or "100M size" instead of "true". keep_logical_logs=100M size

and restarted neo4j, but it did not delete any of the old log files. Can I do it manually when neo4j stopped? Or do you need all these files? I stopped neo4j, made a backup of the graph.db directory, deleted all lines of neostore.transaction.db.7 and started neo4j again. He seems happy, but ...

Thanks!

+6
source share
3 answers

If your database is in good condition, you can delete all neostore.transaction.db.x files, but I recommend that you back them up.

  • Stop Neo4j
  • Delete neostore.transaction.db.x files
  • Launch Neo4j
+10
source

Update:

In neo4j 3.1, the configuration has changed to:

 dbms.tx_log.rotation.retention_policy=<true/false> dbms.tx_log.rotation.retention_policy=<amount> <type>

see https://neo4j.com/docs/operations-manual/current/performance/transaction-logs/ for more details

+3
source

There is a parameter in the properties file for rotating TX logs:

 # Will keep logical logs which contains any transaction committed within 2 days keep_logical_logs=2 days

Check the docs for more details on the various options available.

+1
source

More articles:


All Articles