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

问题描述

我们有一个包含约 1000 万个节点和约 3 亿个关系的 neo4j 数据库.数据库已增长到约 80 Gig.有一些日常工作会删除旧数据并添加新数据，因此节点和关系的大约数量保持相当稳定.但是，db 文件的物理文件大小一直在增长(例如，relationstore 文件当前为 50Gig).

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).

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

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

问题:

a) 我们可以检查什么来找出我们的数据库仍在增长的原因?

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

b) 我使用过的大多数关系数据库总是具有收缩文件"或优化可用空间"功能.Neo4j 是否存在这样的东西?(谷歌搜索不成功！).

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!).

谢谢，

-A

附言我们在 Ubuntu 14 上运行 Neo4j 2.1.5 社区版

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

推荐答案

有一个工具叫 store-utils 这将使您能够有效地压缩商店.不过，您必须在运行该商店之前关闭该商店.

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屋！