LDAP performance tool

[Norman_21]

Guys,

CAn anyone recommend a good perfomance monitoring tool to collect performance data for RedHat directory server 7.1 SP2?

[Steven E. Protter]

Shalom Latif,

Not to be flippant, the best performance measurement tool I have in that area is the users. They complain, I know I have trouble.

Tough to get data but you can spot some problems with a simple sniffer like wireshark or tcpdump. Too much time between transactions is a sign of trouble.

If you are having trouble I just learned of a performance enhancement called ncsd that caches results from the windows PDC and makes the second try much faster.

SEP

[Norman_21]

Shalom Steve,

Long time dude!

I don't have a PDC. LDAP is running in HP-UX.
Here is an example of an LDAP native tool, it's reporting different activity but it's not very detailed.
Parsing the access log file is kind of a pain. There must be a tool that will make my life easier. Even if its a 3rd party tool. Please searching and I'll do the same:

HPADM1/home/rootlbm > ldapsearch -h hostname -p 389 -D "cn=directory manager" -w - -b cn=monitor cn=snmp
Enter bind password:
version: 1
dn: cn=snmp,cn=monitor
objectClass: top
objectClass: extensibleObject
cn: snmp
anonymousbinds: 11
unauthbinds: 11
simpleauthbinds: 1465
strongauthbinds: 0
bindsecurityerrors: 54
inops: 3071
readops: 0
compareops: 0
addentryops: 3
removeentryops: 0
modifyentryops: 1
modifyrdnops: 0
listops: 0
searchops: 133
onelevelsearchops: 88
wholesubtreesearchops: 39
referrals: 0
chainings: 0
securityerrors: 26
errors: 123
connections: 7
connectionseq: 1445
bytesrecv: 0
bytessent: 3098388
entriesreturned: 39314
referralsreturned: 0
masterentries: 0
copyentries: 0
cacheentries: 0
cachehits: 0
slavehits: 0

[VK2COT]

Hello,

A good reference to simple and efficient LDAP monitoring:

http://prefetch.net/articles/monitoringldap.html

It is based on several Perl scripts and ORCA...

Cheers,

VK2COT

[Norman_21]

Dusan,

Thanks for the link. I'll look into it.

However, I went through the RHDS admin guide and decided to write a simpel script to gather the performance statistics and database activity.

For future reference, the following output from the ldapsearch can help you gather data performance but you'll need to read the manual to understand the value of the attributes. Most likely, you'll need to focus on the values of the ratio and the catche size attributes:

LDAP Performance:

ldapsearch -h -p 389 -D "cn=directory manager" -w - -s base -b cn=monitor "(objectclass=*)"
dn: cn=monitor
objectClass: top
objectClass: extensibleObject
cn: monitor
version: Red Hat-Directory/7.1 SP2 B2006.090.144
threads: 30

currentconnections: 12
totalconnections: 1635
dtablesize: 2048
readwaiters: 0
opsinitiated: 3940
opscompleted: 3939
entriessent: 43299
bytessent: 4323517
currenttime: 20080106053151Z
starttime: 20071221222433Z
nbackends: 2
backendmonitordn: cn=monitor,cn=,cn=ldbm database,cn=plugins,cn=conf
ig
backendmonitordn: cn=monitor,cn=NetscapeRoot,cn=ldbm database,cn=plugins,cn=co
nfig

Database activity:

ldapsearch -h -p 389 -D "cn=directory manager" -w - -s base -b "cn=monitor,cn=,cn=ldbm database,cn=plugins,cn=config" "(objectclass=*)"
dn: cn=monitor, cn=, cn=ldbm database, cn=plugins, cn=config
objectClass: top
objectClass: extensibleObject
cn: monitor
database: ldbm database
readonly: 0
entrycachehits: 279051
entrycachetries: 282135
entrycachehitratio: 98
currententrycachesize: 7461294
maxentrycachesize: 10485760
currententrycachecount: 3026
maxentrycachecount: -1

ldapsearch -h -p 389 -D "cn=directory manager" -w - -s base -b "cn=monitor,cn=,cn=ldbm database,cn=plugins,cn=config" "(objectclass=*)"

[Norman_21]

Typo: catche=cache.

[Norman_21]

Thread closed.