Neo4J数据库大小/收缩 [英] Neo4J database size / shrinking

问题描述

我们有一个neo4j数据库，约有10万个节点和约3亿个关系。数据库已经增长到约80吉。有日常工作，杀死旧数据和添加新数据，所以大约节点和关系的数量保持相当恒定。但是，db文件的物理文件大小不断增长（例如，当前，relationshipstore文件位于50Gig）。

我发现以下链接可能解释为什么删除时空间可能不会下降（空格保留，并被新的关系和节点占用），但是它仍然不解释为什么我们的数据库不断增长！
neostore。*删除百万节点后的文件大小

问题：

a）我们可以检查什么才能找出数据库仍在增长的原因？

b）我工作过的大多数关系数据库总是有收缩文件或优化可用空间函数。 Neo4j有这样的东西吗？

谢谢你，

-A

PS我们在Ubuntu 14上运行Neo4j 2.1.5 Community Edition

解决方案

有一个工具叫做 store-utils ，这将允许您有效地压缩商店。你不得不关闭商店之前运行，虽然。

在尝试任何与商店有关的任何工具之前，请务必备份。

We have a neo4j database with ~10Mil nodes and ~300 million relationships. the database has grown to about 80 Gig. There are daily jobs that kill off old data and add new data, so the approx number of nodes and relationships stays fairly constant. However, the physical file size of the db files keeps on growing (for example, the relationshipstore file is at 50Gig currently).

I have found the following link that might explain why the size might not go down when deleting (space is left reserved and is taken up by new relationships and nodes), however it still does not explain why our database keeps growing! neostore.* file size after deleting millions node

Questions:

a) What can we check to find out why our db is still growing?

b) Most relational db's I've worked with always had "shrink files" or "optimize free space" function. Does something like this exist for Neo4j? (google search was unsuccessful!).

Thank you,

-A

P.S. We're running Neo4j 2.1.5 Community Edition on Ubuntu 14

解决方案

There is a tool called store-utils which will allow you to effectively compact the store. You'd have to shut down the store before running that though.

As always take a back up before you try out any tools that do anything with the store.

这篇关于Neo4J数据库大小/收缩的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！