Tuning the performance of Red Hat Directory Server Red Hat Directory Server 12 Improving the server and database performance Red Hat Customer Content Services

Commands:
dsconf -D " cn=Directory Manager " ldap://server.example.com monitor backend userRoot
(|(parentid= search_base_id )(entryid= search_base_id )
nsViewFilter: (&(objectClass=inetOrgPerson)(roomNumber=*66))
dsconf -D " cn=Directory Manager " instance_name backend suffix list dc=example,dc=com (userroot)
dsconf -D " cn=Directory Manager " instance_name backend index add --attr roomNumber --index-type sub userroot
dsconf -D " cn=Directory Manager " instance_name backend index reindex userroot
ldapsearch -D " cn=Directory Manager " -W -H ldap://server.example.com -x -b dc=example,dc=com (&(objectClass=inetOrgPerson)(roomNumber=*66)) ldapsearch -D " cn=Directory Manager " -W -H ldap://server.example.com -x -b dc=example,dc=com " (&(objectClass=inetOrgPerson)(roomNumber=*66)) "
(|(parentid= search_base_id )(entryid= search_base_id )
nsViewFilter: (&(objectClass=inetOrgPerson)(roomNumber=*66))
dsconf -D " cn=Directory Manager " ldap://server.example.com backend config set --idlistscanlimit= 8000
dsctl instance_name restart
ldapmodify -D " cn=Directory Manager " -W -H ldap://server.example.com -x dn: cn=objectclass,cn=index,cn= userRoot ,cn=ldbm database,cn=plugins,cn=config changetype: modify replace: nsIndexIDListScanLimit nsIndexIDListScanLimit: limit=0 type=eq flags=AND values=inetOrgPerson
nsIndexIDListScanLimit: limit=NNN [type=eq[,sub,...]] [flags=AND[,XXX,...]] [values=val[,val,...]]
nsIndexIDListScanLimit: limit=0 type=eq values=uid=user\2Cou=People\2Cdc=example\2Cdc=com
libdb: Lock table is out of available locks
dsconf instance_name backend config set --locks-monitoring-enabled on --locks-monitoring-pause 600 --locks-monitoring-threshold 85
dsctl instance_name restart
dsconf -D " cn=Directory Manager " ldap://supplier.example.com backend config get | grep "nsslapd-db-locks-monitoring" nsslapd-db-locks-monitoring-enabled: on nsslapd-db-locks-monitoring-threshold: 85 nsslapd-db-locks-monitoring-pause: 600
ldapsearch -D " cn=Directory Manager " -W -H ldap://server.example.com -x -s sub -b "cn=database,cn=monitor,cn=ldbm database,cn=plugins,cn=config" nsslapd-db-current-locks nsslapd-db-max-locks nsslapd-db-current-locks: 37 nsslapd-db-max-locks: 39
dsconf instance_name backend config set --locks= 20000
dsctl instance_name restart
dsconf instance_name backend config get | grep "nsslapd-db-locks:" nsslapd-db-locks: 20000
dsconf -D "cn=Directory Manager" ldap:// server.example.com config replace nsslapd-threadnumber="-1" Successfully replaced "nsslapd-threadnumber"
dsconf -D "cn=Directory Manager" ldap:// server.example.com config get nsslapd-threadnumber nsslapd-threadnumber: 16
dsconf -D " cn=Directory Manager " ldap://server.example.com config replace nsslapd-threadnumber=" 64 " Successfully replaced "nsslapd-threadnumber"
dsconf -D " cn=Directory Manager " ldap://server.example.com config replace parameter_name = value
dsctl instance_name restart
cat /sys/kernel/mm/transparent_hugepage/enabled
transparent_hugepage=never
echo never > /sys/kernel/mm/transparent_hugepage/enabled echo never > /sys/kernel/mm/transparent_hugepage/defrag
dsconf -D "cn=Directory Manager" instance_name config replace nsslapd-statlog-level=1
dsctl instance_name restart
ldapsearch -D "cn=Directory Manager" -H ldap:// server.example.com -b "dc=example,dc=com" -s sub -x "cn=user*"
cat /var/log/dirsrv/slapd- instance_name /access [16/Nov/2022:11:34:11.834135997 +0100] conn=1 op=73 SRCH base="dc=example,dc=com" scope=2 filter="(cn=user )"* attrs=ALL [16/Nov/2022:11:34:11.835750508 +0100] conn=1 op=73 STAT read index: attribute=objectclass key(eq)= referral --> count 0 [16/Nov/2022:11:34:11.836648697 +0100] conn=1 op=73 STAT read index: attribute=cn key(sub)= er_ --> count 25 [16/Nov/2022:11:34:11.837538489 +0100] conn=1 op=73 STAT read index: attribute=cn key(sub)= ser --> count 25 [16/Nov/2022:11:34:11.838814948 +0100] conn=1 op=73 STAT read index: attribute=cn key(sub)= use --> count 25 [16/Nov/2022:11:34:11.841241531 +0100] conn=1 op=73 STAT read index: attribute=cn key(sub)= ^us --> count 25 [16/Nov/2022:11:34:11.842230318 +0100] conn=1 op=73 STAT read index: duration 0.000010276 [16/Nov/2022:11:34:11.843185322 +0100] conn=1 op=73 RESULT err=0 tag=101 nentries=24 wtime=0.000078414 optime=0.001614101 etime=0.001690742
dsconf -D " cn=Directory Manager " ldap://server.example.com config replace nsslapd-disk-monitoring= on nsslapd-disk-monitoring-threshold= 3221225472 nsslapd-disk-monitoring-grace-period= 60
dsconf -D " cn=Directory Manager " ldap://server.example.com config replace nsslapd-disk-monitoring-logging-critical= on
dsctl instance_name restart
dsconf -D " cn=Directory Manager " ldap://server.example.com backend config set --checkpoint-interval= 120
dsctl instance_name stop
dn: cn=config,cn=ldbm database,cn=plugins,cn=config nsslapd-db-durable-transaction: off
dsctl instance_name start
dsconf -D " cn=Directory Manager " ldap://server.example.com monitor dbmon DB Monitor Report: 2022-02-24 10:25:16 -------------------------------------------------------- Database Cache: - Cache Hit Ratio: 50% - Free Space: 397.31 KB - Free Percentage: 2.2% - RO Page Drops: 0 - Pages In: 2934772 - Pages Out: 219075 Normalized DN Cache: - Cache Hit Ratio: 60% - Free Space: 19.98 MB - Free Percentage: 99.9% - DN Count: 100000 - Evictions: 9282348 Backends: - dc=example,dc=com (userroot): - Entry Cache Hit Ratio: 66% - Entry Cache Count: 50000 - Entry Cache Free Space: 2.0 KB - Entry Cache Free Percentage: 0.8% - Entry Cache Average Size: 8.9 KB - DN Cache Hit Ratio: 21% - DN Cache Count: 100000 - DN Cache Free Space: 4.29 MB - DN Cache Free Percentage: 69.8% - DN Cache Average Size: 130.0 B
Database Cache: - Free Space: 397.31 KB - Free Percentage: 2.2%
Backends: - dc=example,dc=com (userroot): - DN Cache Count: 100000 - DN Cache Free Space: 4.29 MB - DN Cache Free Percentage: 69.8% - DN Cache Average Size: 130.0 B
Backends: - dc=example,dc=com (userroot): - Entry Cache Count: 50000 - Entry Cache Free Space: 2.0 KB - Entry Cache Free Percentage: 0.8% - Entry Cache Average Size: 8.9 KB
dsconf -D " cn=Directory Manager " ldap://server.example.com backend config set --cache-autosize=0
dsconf -D " cn=Directory Manager " ldap://server.example.com backend config set --dbcachesize= 268435456
dsctl instance_name restart
dsconf -D " cn=Directory Manager " ldap://server.example.com suffix list dc=example,dc=com (userroot)
dsconf -D " cn=Directory Manager " ldap://server.example.com backend suffix set --dncache-memsize= 20971520 userRoot
dsctl instance_name restart
dsconf -D " cn=Directory Manager " ldap://server.example.com backend config set --cache-autosize=0
dsconf -D " cn=Directory Manager " ldap://server.example.com suffix list dc=example,dc=com (userroot)
dsconf -D " cn=Directory Manager " ldap://server.example.com backend suffix set --cache-memsize= 2147483648 userRoot
dsctl instance_name restart
dsconf -D "cn=Directory Manager" ldap://server.example.com config get nsslapd-numlisteners
dsconf -D "cn=Directory Manager" ldap://server.example.com config replace nsslapd-numlisteners=4
dsctl instance_name restart