[Date Prev][Date Next] [Chronological] [Thread] [Top]

Re: How to use a DB_CONFIG file to berkeley data base



On Friday 21 October 2005 18:34, you wrote:
> Hi,
>
> I found a db_config file to berkeley data base

Where? And, did you consult any documentation that will help you decide if you 
should use it?

>
> are parameters are good ?

No.

> # Set the entry cache size to 5000.
> #
> cachesize       5000

cachesize is not a Berkeley BD Configuration directive, but an OpenLDAP one, 
this should be in slapd.conf. Please see the slapd-bdb man page for details.

> #
> # Set transactional checkpoint.
> #
> checkpoint      512     720

Same for checkpoint. And, 720 minutes is probably too long IMHO.

> #
> # Set the database in memory cache size.
> #
> set_cachesize   0       52428800        0

You don't say how large your data set is, or give any details of the hardware, 
so it's impossible to comment on this.

> #
> # Set database flags.
> #
> set_flags       DB_TXN_NOSYNC

You really should not set this for a production server without very good 
reasons.

> #
> # Set log values.
> #
> #1048576
> #10485760
> #2097152
> set_lg_regionmax        10
> set_lg_max              10
> set_lg_bsize            10

These are all way too small, and violate some of the rules in the Berkeley DB 
documentation regarding relationships between these parameters.

> set_lg_dir              /usr/local/openLdap2.2.28/log
>
>
> #
> # Set temporary file creation directory.
> #
> set_tmp_dir             /tmp
>
>
> So if it good how i use it ?

I think you need to read the documentation. Using random configuration values 
without understanding what they do is not going to help the performance of 
your database.

Please read at least these documents and the documents they link to:

http://www.openldap.org/faq/data/cache/190.html
http://www.openldap.org/faq/data/cache/1166.html

Regards,
Buchan

-- 
Buchan Milne
ISP Systems Specialist
B.Eng,RHCE(803004789010797),LPIC-2(LPI000074592)

Attachment: pgpDIzkX3eVSv.pgp
Description: PGP signature