1.8 Gb OpenLdap DB.....

[Cena Salvatore <cena-nospam@flexmail.it>]

Hi all,

Developer team built OPENLDAP system for user profiling.

With all users (450.000) OPENLDAP database is 1.8 Gb.....

1) Is 1.8 Gb DB reliable ?

2) What is the max size of OpenLdap Database for user profiling (very 
high access)

We use:

openldap version is OpenLDAP: slapd 2.1.21 (Aug 14 2003 12:16:19)
Sleepycat Software: Berkeley DB 4.1.25: (December 19, 2002)

OpenLdap runs on SUN Sparc v480 4 cpu 1 ghz 4 gb of ram, external 
disk-array with 6x36 gb disk.

I try tune slapd.conf and DB_CONFIG.....

this is slapd.conf

###############################################
# Global
threads         12

#
# Set the entry cache size to 300000.
#
cachesize       300000

#
# Set transactional checkpoint.
#
checkpoint      5120     60

#
# Set the entry found max
#
#sizelimit 100

#
# Set Max time for search.
#
#timelimit 15

###########################################

this is DB_CONFIG

##########################################
#
# Set the database in memory cache size.
#
#set_cachesize   0       104857600        0
set_cachesize   0       209715200        0

#
# Set database flags.
#
#set_flags       DB_NOPANIC
set_flags       DB_TXN_NOSYNC


#
# Set log values.
#
#
# set_lg_regionmax <bytes>
#
# Set the maximum in memory cache in <bytes> for database file name caching.
# This value should be increased as the number of database files 
increases (tables and indexes).
#
#
# set_lg_max <bytes>
#
# Set the maximum size of log files in <bytes> .
# Logs will be rotated when <bytes> amount of data have been written to 
one log file.
# This value should be at least four times the size of set_lg_bsize.
#
#
# set_lg_bsize <bytes>
#
# Set the in memory cache for log information.
# When <bytes> amount of logging information have been written
#      to this cache it will be flushed to disk.
#

#set_lg_regionmax        20971520
#set_lg_max              20971520
#set_lg_bsize            5242880

set_lg_regionmax        41943040
set_lg_max              41943040
set_lg_bsize            10485760

#
# Directory Log e DB
#

#set_lg_dir              /ldap/Database-Redo
#set_data_dir           /ldap/Database
set_lg_dir              /app/Database-Redo
set_data_dir            /app/Database


#
# Set temporary file creation directory.
#
set_tmp_dir             /tmp


#########################################