Recommended Transaction Timeouts

[mike_blum_neo4j]

Using neo4j 3.4.3 we're seeing some transaction timeouts using SDN for some bulk saving and we're curious if modifying the timeouts would help. Currently we have this configuration deployed everywhere:

dbms.lock.acquisition.timeout=30s
dbms.transaction.timeout=180s

What would be some sane defaults? Could the acquisition timeout be too aggressive?

Understanding transaction and lock timeouts

[stefan_armbrust]

There is no general answer to this since it depends on some many aspects of the given use case & setup.
If you're doing large batched write transactions concurrently you'll more likely to run into lock contention than doing small transactions. But small txwill have a higher overhead and therefore be slower.