Interesting, it works for me:
on empty db, create 100k nodes 100k rels delete everything, check sizes
restart create 100k nodes 100k rels delete everything, check sizes
same size on disk
wuqour:neo4j-enterprise-2.3.2 mh$ rm -rf test*.db
wuqour:neo4j-enterprise-2.3.2 mh$ bin/neo4j-shell -path test.db
NOTE: Local Neo4j graph database service at 'test.db'
Welcome to the Neo4j Shell! Enter 'help' for a list of commands
neo4j-sh (?)$ foreach(x in range(1,100000) | create (:Person {name:"person
"+x, age : x % 100}));
+-------------------+
| No data returned. |
+-------------------+
Nodes created: 100000
Properties set: 200000
Labels added: 100000
5996 ms
neo4j-sh (?)$ unwind range(1,100000) as x match (p) where id(p) = x match
(p2) where id(p2) = toInt(rand()*100000) create (p)-[:KNOWS]->(p2);
+-------------------+
| No data returned. |
+-------------------+
Relationships created: 99999
3185 ms
neo4j-sh (?)$ match (n) detach delete n;
+-------------------+
| No data returned. |
+-------------------+
Nodes deleted: 100000
Relationships deleted: 99999
1654 ms
neo4j-sh (?)$ quit
wuqour:neo4j-enterprise-2.3.2 mh$ du -sh test.db/neostore*.db
8,0K test.db/neostore.labeltokenstore.db
1,4M test.db/neostore.nodestore.db
3,9M test.db/neostore.propertystore.db
8,0K test.db/neostore.relationshipgroupstore.db
3,2M test.db/neostore.relationshipstore.db
8,0K test.db/neostore.relationshiptypestore.db
8,0K test.db/neostore.schemastore.db
wuqour:neo4j-enterprise-2.3.2 mh$ bin/neo4j-shell -path test.db
NOTE: Local Neo4j graph database service at 'test.db'
Welcome to the Neo4j Shell! Enter 'help' for a list of commands
neo4j-sh (?)$ foreach(x in range(1,100000) | create (:Person {name:"person
"+x, age : x % 100}));
+-------------------+
| No data returned. |
+-------------------+
Nodes created: 100000
Properties set: 200000
Labels added: 100000
5911 ms
neo4j-sh (?)$ unwind range(1,100000) as x match (p) where id(p) = x match
(p2) where id(p2) = toInt(rand()*100000) create (p)-[:KNOWS]->(p2);
+-------------------+
| No data returned. |
+-------------------+
Relationships created: 99999
1897 ms
neo4j-sh (?)$ match (n) detach delete n;
+-------------------+
| No data returned. |
+-------------------+
Nodes deleted: 100000
Relationships deleted: 99999
1415 ms
neo4j-sh (?)$ wuqour:neo4j-enterprise-2.3.2 mh$ du -sh test.db/neostore*.db
8,0K test.db/neostore.labeltokenstore.db
1,4M test.db/neostore.nodestore.db
3,9M test.db/neostore.propertystore.db
8,0K test.db/neostore.relationshipgroupstore.db
3,2M test.db/neostore.relationshipstore.db
8,0K test.db/neostore.relationshiptypestore.db
8,0K test.db/neostore.schemastore.db
On Sat, Mar 5, 2016 at 6:43 PM, Jesse Hemingway <[email protected]> wrote:
> This is not holding true for my setup, as I've seen my modest 10MB
> database grow to 250MB over the course of repeatedly testing my seeding
> logic, and shutting down the server many times as I made configuration
> changes for new modules, etc. Also, this SO article
> <http://stackoverflow.com/questions/24368176/neo4j-empty-database-takes-up-a-lot-of-disk-space>
> (outdated? but seems to hold true) indicates that space is not reclaimed.
> I've come across a tool in the public domain to accomplish neo4j
> compaction, implying it isn't (or wasn't) automatically supported.
>
> I repeated the restart-server test just now, and it does not alter the
> size on disk -- the store is 18.2MB (19.4 on disk), twice my 'fresh' data
> size, and I have reset/reseeded once. Next, I deleted the db, and after
> reseeding, the size is back down to 9.14, with all the same data as before.
> My log files were a drop in the bucket either way.
>
> Either way, I'm not going to quibble that if it's more efficient to re-use
> old records than create new ones, it doesn't make sense to aggressively
> compact the database. It would just be nice as an option, e.g. to assist in
> file transfer when moving a database around, etc.
>
>
> On Saturday, March 5, 2016 at 7:18:56 AM UTC-6, Michael Hunger wrote:
>>
>> Unused recoreds are reclaimed after restart, so if you restart after
>> cleaning out then it will.
>> But you can also just delete the db-directory.
>>
>> On Fri, Mar 4, 2016 at 10:52 PM, Jesse Hemingway <[email protected]>
>> wrote:
>>
>>> I actually just delete my database if I want to reset everything to a
>>> clean slate (shutting down server first). We have an auto-seeding solution
>>> that reconstitutes our base data, so that may not be an option for you.
>>> Otherwise, MATCH <stuff> DETACH DELETE <stuff> does the job.
>>>
>>> But on a related note, I notice that e.g. repeated use of MATCH (n)
>>> DETACH DELETE n (with reseeding in between) does not seem to reclaim
>>> data storage, and the overall database size keeps growing. Is this expected
>>> behavior, or is there some garbage-collection process I need to trigger?
>>>
>>>
>>> On Saturday, February 27, 2016 at 6:43:52 PM UTC-6, Ara wrote:
>>>>
>>>> Hi ,
>>>> Recently installed Neo4j community version, I'am not able to clear
>>>> the node labels, relationship type from database information. Kindly guide
>>>> me on this issue.Thank you
>>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "Neo4j" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to [email protected].
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> For more options, visit https://groups.google.com/d/optout.
>
--
You received this message because you are subscribed to the Google Groups
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
