Those indexes look fine to me, so there must be something else wrong. This
is probably something that needs to be asked on the ldap list, I know
there are a lot of threads on ldap performance in the archives. Openldap
absolutely should be able to perform the log with satisfactory
performance.
Andreas Stollar
Senior System Administrator
Speakeasy
On Thu, 21 Jul 2005, Catalin Petrescu wrote:
Date: Thu, 21 Jul 2005 18:25:42 +0300
From: Catalin Petrescu <[EMAIL PROTECTED]>
To: 'Andreas Stollar' <[EMAIL PROTECTED]>
Cc: 'HyperAxe' <[EMAIL PROTECTED]>, [email protected]
Subject: RE: Ldap search is slow , busy mail server
I have :
index objectclass eq
index mail,mailAlternateAddress,uid eq,sub
index accountStatus,mailHost,deliveryMode eq
index default sub
Thakns.
-----Original Message-----
From: Andreas Stollar [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 21, 2005 6:24 PM
To: Catalin Petrescu
Cc: 'HyperAxe'; [email protected]
Subject: RE: Ldap search is slow , busy mail server
You have to make sure you have proper indexes in your LDAP database, at
least these:
index objectClass eq
index cn pres,eq,sub
index mail pres,eq,sub
index uid pres,eq,sub
I have 175,000 records in my LDAP db, two slaves get hit by 28
mailservers. The lookups are very fast, and the ldap boxes rarely hit a
load higher than 0.50 .
Andreas Stollar
Senior System Administrator
Speakeasy
On Thu, 21 Jul 2005, Catalin Petrescu wrote:
Date: Thu, 21 Jul 2005 11:28:40 +0300
From: Catalin Petrescu <[EMAIL PROTECTED]>
To: 'HyperAxe' <[EMAIL PROTECTED]>, [email protected]
Subject: RE: Ldap search is slow , busy mail server
Not much somewhere around 700 records .
_____
From: HyperAxe [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 21, 2005 11:26 AM
To: 'Catalin Petrescu'; [email protected]
Subject: RE: Ldap search is slow , busy mail server
Do you already have a large number of records in your ldap database?
HyperAxe
Email: [EMAIL PROTECTED]
Web: http://www.hyperaxe.com
-----Original Message-----
From: Catalin Petrescu [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 21, 2005 4:02 PM
To: 'HyperAxe'; [email protected]
Subject: RE: Ldap search is slow , busy mail server
It’s mot a hardware problem . Now I’m running qmail + vpopmai on the same
hardware and with no problem.
_____
From: HyperAxe [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 21, 2005 10:59 AM
To: 'Catalin Petrescu'; [email protected]
Subject: RE: Ldap search is slow , busy mail server
Hi Catalin,
You can also have a check with your hardware, especially the disk IO. I had
experienced problems such as this before on a production mail server I am
maintaining and found out that the problem was due to a faulty disk array
installed on the server.
Best regards,
HyperAxe
Email: [EMAIL PROTECTED]
Web: http://www.hyperaxe.com
-----Original Message-----
From: Catalin Petrescu [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 21, 2005 3:54 PM
To: [email protected]
Subject: Ldap search is slow , busy mail server
Hello
I have the following setup: openldap 2.2.36 qmail-1.03 +
qmail-ldap-1.03-20050401a , courier pop3 + imap (with authlib latest version).
The ldif looks like this : --ou=administrators
--ou=Groups
--ou=Domain1.com
[EMAIL PROTECTED] (this is
a qmail-group for mailing list)
--ou=Domain1.com
[EMAIL PROTECTED] (same for
domain2.com)
--ou=Users
--ou=Domain1.com
--ou=a
[EMAIL PROTECTED]
Etc.
The messages in queue takes too long to be delivered to users Maildir , I’ve
turn on debugging for ldap and qmail does one search for mail address and the
stop (unbind) for 2 sec and the starts all over again for the next mail. I
know that persistent connection is not an option with openldap , but for what I
have read this setup (openldap +qmail-ldap) is one of the fastest and I this
that I’m doing something wrong . Please give me an advice .
Catalin Petrescu
