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