This discussion is archived
4 Replies Latest reply: Jun 20, 2013 8:42 AM by greybird RSS

BDB JE: DB Cache size

d36505d2-f794-4e27-bffa-ba85ab8761e3 Newbie
Currently Being Moderated

I ran the BDB cache size estimation program and here are the results. Can anyone please explain the results? I want to make sure I am interpreting the results correctly.

 

java -classpath lib/je-5.0.73.jar   com.sleepycat.je.util.DbCacheSize -data 800 -records 1320000000 -key 100

 

=== Environment Cache Overhead ===

 

3,161,086 minimum bytes

 

To account for JE daemon operation and record locks,

a significantly larger amount is needed in practice.

 

=== Database Cache Size ===

 

Minimum Bytes    Maximum Bytes   Description

---------------  ---------------  -----------

200,809,887,312  208,489,887,312  Internal nodes only

1,346,629,238,328  1,354,309,238,328  Internal nodes and leaf nodes

 

=== Internal Node Usage by Btree Level ===

 

Minimum Bytes    Maximum Bytes      Nodes    Level

---------------  ---------------  ----------  -----

198,385,622,336  205,979,330,368  14,831,461    1

  2,397,021,680    2,482,343,920     166,645    2

     26,926,848       27,885,312       1,872    3

        302,064          312,816          21    4

         14,384           14,896           1    5

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points