Please find the answers:
1.
What indexes have
been created? Do they match the attributes that your applications use most
often? --- All required attributes related
application indexed(equality)
2.
In this age of cheap
RAM, 2GB RAM for a server seems puny. Latest Dell R710s come packed with
32-64GB RAM. Consider a hardware upgrade.—We
can increase it by 3-4 GB only
3.
Configure LB for
active-active instead of active-passive?—I
have configured PEN LB as a active-active(both master are active-active)
4.
Turn on logging
(any), run a small sample from the application and see what transactions eat up
most cycles on the LDAP server.(I have configured
loglevel 256, if I set loglevel -1, it will slow the read write speed
from/to openldap server and also eating cpu. )
5.
Upgrade from 2.4.16
to 2.4.xx?---I don’t think that up
gradation will solve this issue.
Here my concern is:
I think I need to set below parameter in DB_CONFIG file:
set_cachesize (but what should be the tuned value according to my data?)
Thanks & Regards,
Devender Singh
Senior Unix Administrator,
(SOA Support Team)
________________________________________________________________________________________________________________________
SDG Software India Pvt. Ltd
A-10, Sector 2, Noida 201301, U.P, India
M: +91-9910024231 O: +91.120.401.4000 F: +91.120.401.4020
website : www.sdgc.com
________________________________________________________________________________________________________________________
Please Note: The e-mail content is intended for the
sole use of the intended recipient/s and may contain material that is
CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others
or copying or distribution or forwarding of any or all of the contents in this
message is STRICTLY PROHIBITED. If you have erroneously received this message,
please delete it immediately and notify the sender. Before opening any
attachments please check them for viruses and defects.
From: openldap-technical-bounces@OpenLDAP.org
[mailto:openldap-technical-bounces@OpenLDAP.org] On Behalf Of Siddhartha
Jain
Sent: Thursday, August 19, 2010 4:17 AM
To: openldap-technical@openldap.org
Subject: RE: Openldap2.4.16 performance issue
Off the top of my head:
6.
What indexes have
been created? Do they match the attributes that your applications use most
often?
7.
In this age of cheap
RAM, 2GB RAM for a server seems puny. Latest Dell R710s come packed with
32-64GB RAM. Consider a hardware upgrade.
8.
Configure LB for
active-active instead of active-passive?
9.
Turn on logging
(any), run a small sample from the application and see what transactions eat up
most cycles on the LDAP server.
10.
Upgrade from 2.4.16
to 2.4.xx?
From:
openldap-technical-bounces@OpenLDAP.org
[mailto:openldap-technical-bounces@OpenLDAP.org] On Behalf Of Singh,
Devender (GE Capital, consultant)
Sent: Wednesday, August 18, 2010 3:15 PM
To: hyc@symas.com
Cc: openldap-technical@openldap.org
Subject: RE: Openldap2.4.16 performance issue
Hi Chu,
Please help me on my below issue. It’s very urgent.
Thanks & Regards,
Devender Singh
Senior Unix Administrator,
From: openldap-technical-bounces@OpenLDAP.org
[mailto:openldap-technical-bounces@OpenLDAP.org] On Behalf Of Singh,
Devender (GE Capital, consultant)
Sent: Tuesday, August 17, 2010 5:12 AM
To: openldap-technical@openldap.org
Subject: Openldap2.4.16 performance issue
Hi All,
I need help for openldap slapd 200% cpu utilization issue.
I have configured three openldap servers(2 Masters and 1 Slave). I have
configure PEN load balancer for failover setup on 2 master openldap servers.It
means application server first of all hit the loadbalancer port and than PEN LB
will forwad that request to Master 1 or 2 openldap server.
Hardware configuration on all boxes:
OS: RHEL5(x86_64)
RAM: 2GB
Number of CPU: 2(Intel(R) Xeon(R)2.00GHz)
Number of BDB databases: 2
Databse1:
Number of users : 830000
Number of dns: 830000
Database2:
Number of users: 2000
Number of dns: 800000
My Application1 using Databse1 and Application2 using Databse2.
Application2 just authenticating the users and store last 10 password history
only, It means Application1 is not using openldap too much.
In Application2(90% dependent on openldap) every user have 1000+ sub leafs
entries. when I want to do major changes(number of leafs write) into this, it.s
got hanged and got socket closed error in application logs and CPU utilization
goes 200% and RAM 52%. My DB_CONFIG file is below:
# $OpenLDAP: pkg/ldap/servers/slapd/DB_CONFIG,v 1.3.2.4 2007/12/18 11:53:27
ghenry Exp $
# Example DB_CONFIG file for use with slapd(8) BDB/HDB databases.
#
# See the Oracle Berkeley DB documentation
# <http://www.oracle.com/technology/documentation/berkeley-db/db/ref/env/db_config.html>
# for detail description of DB_CONFIG syntax and semantics.
#
# Hints can also be found in the OpenLDAP Software FAQ
# <http://www.openldap.org/faq/index.cgi?file=2>
# in particular:
# <http://www.openldap.org/faq/index.cgi?file=1075>
# Note: most DB_CONFIG settings will take effect only upon rebuilding
# the DB environment.
# one 0.25 GB cache
set_cachesize 0 268435456 1
# Data Directory
#set_data_dir db
# Transaction Log settings
set_lg_regionmax 262144
set_lg_bsize 2097152
#set_lg_dir logs
# Note: special DB_CONFIG flags are no longer needed for "quick"
# slapadd(8) or slapindex(8) access (see their -q option).
Please help me here that what I need to do for better performance. Thanks in
advance.
My contact number is +919650477441
Thanks & Regards,
Devender Singh
Senior Unix Administrator,