4 Replies Latest reply: Jun 20, 2013 8:51 AM by d36505d2-f794-4e27-bffa-ba85ab8761e3 RSS

    BDB JE: DB Cache size

    d36505d2-f794-4e27-bffa-ba85ab8761e3

      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