Ahmad, besides the number of logical logs around (from keep_logical_logs=true), the largest store is really the string-store.
You need to keep the logical logs only in a HA scenario or if you want to be able to take incremental backups (then there should be as many logs kept as the delta between the main instance and the backup). Hmm quite a lot of entries per table, are they all the same (or of the same subset?). Otherwise it is probably cheaper to store them as the string than individual properties. There are some store optimizations underway which might change the picture but that would needed to be tested when those are released. Do many of those values just contain default values like false, 0 or the empty string? Do you access these json-hashmaps in graph operations? Or are they just stored for later retrieval and usage? Then it might be sensible to compress them on the fly when storing them and uncompressing them later when they are used. Michael Am 08.08.2011 um 18:43 schrieb ahmad.bakr: > Michael, > > Well, the average number of entries in a hashtable may be from 300-700 > entries. i don't know if it's ok to store each key/value as properties in > the node, you may tell me about that ? > > And here is the output of the 'ls -lh data/graph.db' > > > total 2.3G > -rw-r--r-- 1 webistrano webistrano 11 2011-08-08 19:20 active_tx_log > drwxr-xr-x 3 webistrano webistrano 4.0K 2011-08-08 11:23 index > -rw-r--r-- 1 webistrano webistrano 167 2011-08-08 11:23 index.db > -rw-r--r-- 1 webistrano webistrano 33K 2011-08-08 19:30 messages.log > -rw-r--r-- 1 webistrano webistrano 36 2011-08-08 19:30 neostore > -rw-r--r-- 1 webistrano webistrano 9 2011-08-08 11:23 neostore.id > -rw-r--r-- 1 webistrano webistrano 1.5M 2011-08-08 18:10 > neostore.nodestore.db > -rw-r--r-- 1 webistrano webistrano 9 2011-08-08 11:23 > neostore.nodestore.db.id > -rw-r--r-- 1 webistrano webistrano 48M 2011-08-08 19:10 > neostore.propertystore.db > -rw-r--r-- 1 webistrano webistrano 133 2011-08-08 11:23 > neostore.propertystore.db.arrays > -rw-r--r-- 1 webistrano webistrano 9 2011-08-08 11:23 > neostore.propertystore.db.arrays.id > -rw-r--r-- 1 webistrano webistrano 12M 2011-08-08 19:30 > neostore.propertystore.db.id > -rw-r--r-- 1 webistrano webistrano 11K 2011-08-08 11:23 > neostore.propertystore.db.index > -rw-r--r-- 1 webistrano webistrano 9 2011-08-08 11:23 > neostore.propertystore.db.index.id > -rw-r--r-- 1 webistrano webistrano 1.1K 2011-08-08 11:23 > neostore.propertystore.db.index.keys > -rw-r--r-- 1 webistrano webistrano 9 2011-08-08 11:23 > neostore.propertystore.db.index.keys.id > -rw-r--r-- 1 webistrano webistrano 880M 2011-08-08 19:30 > neostore.propertystore.db.strings > -rw-r--r-- 1 webistrano webistrano 49M 2011-08-08 19:30 > neostore.propertystore.db.strings.id > -rw-r--r-- 1 webistrano webistrano 21M 2011-08-08 19:20 > neostore.relationshipstore.db > -rw-r--r-- 1 webistrano webistrano 9 2011-08-08 11:23 > neostore.relationshipstore.db.id > -rw-r--r-- 1 webistrano webistrano 24K 2011-08-08 19:30 > neostore.relationshiptypestore.db > -rw-r--r-- 1 webistrano webistrano 9 2011-08-08 11:23 > neostore.relationshiptypestore.db.id > -rw-r--r-- 1 webistrano webistrano 202K 2011-08-08 19:30 > neostore.relationshiptypestore.db.names > -rw-r--r-- 1 webistrano webistrano 9 2011-08-08 11:23 > neostore.relationshiptypestore.db.names.id > -rw-r--r-- 1 webistrano webistrano 1.9M 2011-08-08 19:30 > nioneo_logical.log.2 > -rw-r--r-- 1 webistrano webistrano 4 2011-08-08 19:30 > nioneo_logical.log.active > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 11:26 > nioneo_logical.log.v0 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 11:28 > nioneo_logical.log.v1 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 11:40 > nioneo_logical.log.v10 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 11:41 > nioneo_logical.log.v11 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 11:43 > nioneo_logical.log.v12 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 11:44 > nioneo_logical.log.v13 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 11:45 > nioneo_logical.log.v14 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 11:47 > nioneo_logical.log.v15 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 11:49 > nioneo_logical.log.v16 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 11:50 > nioneo_logical.log.v17 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 11:52 > nioneo_logical.log.v18 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 11:53 > nioneo_logical.log.v19 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 11:30 > nioneo_logical.log.v2 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 11:55 > nioneo_logical.log.v20 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 11:56 > nioneo_logical.log.v21 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 11:57 > nioneo_logical.log.v22 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 11:59 > nioneo_logical.log.v23 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 12:01 > nioneo_logical.log.v24 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 12:02 > nioneo_logical.log.v25 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 12:04 > nioneo_logical.log.v26 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 12:07 > nioneo_logical.log.v27 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 12:09 > nioneo_logical.log.v28 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 12:20 > nioneo_logical.log.v29 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 11:31 > nioneo_logical.log.v3 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 12:40 > nioneo_logical.log.v30 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 13:01 > nioneo_logical.log.v31 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 13:30 > nioneo_logical.log.v32 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 13:50 > nioneo_logical.log.v33 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 14:11 > nioneo_logical.log.v34 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 14:40 > nioneo_logical.log.v35 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 14:50 > nioneo_logical.log.v36 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 15:10 > nioneo_logical.log.v37 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 15:20 > nioneo_logical.log.v38 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 15:31 > nioneo_logical.log.v39 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 11:33 > nioneo_logical.log.v4 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 15:50 > nioneo_logical.log.v40 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 16:10 > nioneo_logical.log.v41 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 16:30 > nioneo_logical.log.v42 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 16:50 > nioneo_logical.log.v43 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 17:10 > nioneo_logical.log.v44 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 17:40 > nioneo_logical.log.v45 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 18:01 > nioneo_logical.log.v46 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 18:11 > nioneo_logical.log.v47 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 18:40 > nioneo_logical.log.v48 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 19:10 > nioneo_logical.log.v49 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 11:34 > nioneo_logical.log.v5 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 19:30 > nioneo_logical.log.v50 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 11:35 > nioneo_logical.log.v6 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 11:37 > nioneo_logical.log.v7 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 11:38 > nioneo_logical.log.v8 > -rw-r--r-- 1 webistrano webistrano 26M 2011-08-08 11:39 > nioneo_logical.log.v9 > -rw-r--r-- 1 webistrano webistrano 9.0K 2011-08-08 19:30 tm_tx_log.1 > -rw-r--r-- 1 webistrano webistrano 29K 2011-08-08 19:20 tm_tx_log.2 > > Thanks, > Ahmad > > -- > View this message in context: > http://neo4j-community-discussions.438527.n3.nabble.com/Neo4j-Neo4j-Disk-Space-Usage-tp3235564p3236139.html > Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. > _______________________________________________ > Neo4j mailing list > User@lists.neo4j.org > https://lists.neo4j.org/mailman/listinfo/user _______________________________________________ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
