Neo4j database size grows -

-

im using neo4j 3.0.1 community, , have few gbs of data. data become outdated (like 2,3 times per day) , have create new data first, , delete old stuff (so @ point in time data available).

the problem neo4j doesnt reuse space deleted nodes/relationships. im using match (n) condition deteach delete n

i can see nodes beeing deleted (their number constant ~30m) size growing (after 12 updates, size 12x bigger should be).

i found previous posts neo4j database size / shrinking store-utils find better solution.

i found old question (from version 1.x) neostore.* file size after deleting millions node doesnt work in answer @ least in case.

there advices delete database files , create new one, require service stopped shouldn't happen.

i found information in order reuse space need restart db first, tried , didn't work.

is there way free/reuse space deleted nodes/relationships ? maybe miss configuration, or available in enterprise version?

edit:

finally had time test , run scenario when data refreshed few times, restarting server few times aswell. test made on neo4j 3.0.0 on windows 10 environment. results are(not yet allowed embeed images):

neo4j storage sizes

each column presents storage size further updates, blue line means neo4j server restart, , last column (separated brown line) stands size after running store-utils.

as desribed earlier, size growing pretty fast , against documentation, restart doesn't help. store-utils helps (they clean files except neostore.nodestore.db) hard , messy solution integrate store-utils production solution.

can give me hint why storage growing ?

starting neo4j 3.0.4, enterprise edition support reuse node ids , relationship ids without need restart instance. works both single instance , ha deployments.

to enable feature need set following in neo4j.conf:

 dbms.ids.reuse.types.override=node,relationship

Comments

Post a Comment

Popular posts from this blog

wordpress - (T_ENDFOREACH) php error -

-
creating wordpress website , i'm getting following php error: parse error: syntax error, unexpected 'endforeach' (t_endforeach) in /home/soralmedia/public_html/wp-content/themes/soral media/woocommerce/myaccount/my-orders.php on line 98 here's code file: <?php /** * orders * * shows recent orders on account page. * * template can overridden copying yourtheme/woocommerce/myaccount/my-orders.php. * * however, on occasion woocommerce need update template files , (the theme developer). * need copy new files theme maintain compatibility. try this. * little possible, happen. when occurs version of template file will. * bumped , readme list important changes. * * @see http://docs.woothemes.com/document/template-structure/ * @author woothemes * @package woocommerce/templates * @version 2.5.0 */ if ( ! defined( 'abspath' ) ) { exit; } $my_orders_columns = apply_filters( 'woocommerce_my_account_my_orders_columns', array( ...
Read more

Export Excel workseet into txt file using vba - (text and numbers with formulas) -

-
i new vba have developed code use in excel move text/numbers txt file. issue have 3 functions need go same txt file. when run first function has set fs = createobject("scripting.filesystemobject") set = fs.createtextfile(module1.nys45uploadfilename, true) a.writeline (str) a.close. the other 2 functions had save. set fs = createobject("scripting.filesystemobject") set = fs.savetextfile(module1.nys45uploadfilename, true) a.writeline (str) a.close. the first function go txt file, other 2 error object doesn't support property or method. when changed 3 create last function goes txt file. can not figure out word use in order make other 2 functions follow txt file in order keyed. the entire code follows private sub addrecord_click() on error goto errhandler module1.nys45uploadfilename = application.getsaveasfilename(filefilter:="textfiles (*.txt), *.txt") if module1.nys45uploadfilename = "false" exit sub ...
Read more

Using django-mptt to get only the categories that have items -

-
sample structure: all uppercase: category mixed case: item root ├── books │   ├── fiction │   │   └── classics │   └── non-fiction ├── clothing └── electronics ├── laptops ├── phones │   ├── apple │   │   ├── iphone 6 │   │   ├── iphone 6 plus │   │   ├── iphone 6s │   │   └── iphone 6s plus │   ├── motorola │   │   ├── moto g4 │   │   ├── moto g4 play │   │   ├── moto g4 plus │   │   └── moto x │   └── samsung └── tablets └── apple i'm trying have index page show "electronics" category. "clothing" category shouldn't show since it's empty , "books" category shouldn't show either since, although has child categories, child categories don't have items. similarly, "electronics" page should show "phones" category. "laptops" category shouldn't show since it's empty , "tablets" category shouldn't show either since...
Read more