Optimum Settings in dbmail.org?

Hello,

I am running dbmail 2.2.5 on a dual Pentium server.  The
server has 2G
of ram.  The MySQL database and a LDAP replicant used for
authentication
reside on the email server.  The server load is always
around 0.00 - 1.00.

We have 18 clients, the majority of whom use Thunderbird.

What are the best settings for the following configuration
variables, I
couldn't find a lot of documentation on it:?
NCHILDREN             =
MAXCHILDREN           =
MINSPARECHILDREN      =
MAXSPARECHILDREN      =
MAXCONNECTS           =


We are experiencing a lot slow responses and time outs from
dbmail.  The
logs have a lot of these entries:
dbmail-imapd[10643]: Error:[auth]
authldap.c,auth_search(+244): Can't
contact LDAP server
dbmail-imapd[16199]: Error:[server] pool.c,set_lock(+66):
Error setting
lock. Trying again.
dbmail-lmtpd[13088]: Error:[server] pool.c,set_lock(+66):
Error setting
lock. Trying again.

Thank you,
Dan
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Daniel Durgin wrote:
> Hello,
> 
> I am running dbmail 2.2.5 on a dual Pentium server. 
The server has 2G
> of ram.  The MySQL database and a LDAP replicant used
for authentication
> reside on the email server.  The server load is always
around 0.00 - 1.00.
> 
> We have 18 clients, the majority of whom use
Thunderbird.
> 
> What are the best settings for the following
configuration variables, I
> couldn't find a lot of documentation on it:?
> NCHILDREN             =
> MAXCHILDREN           =
> MINSPARECHILDREN      =
> MAXSPARECHILDREN      =
> MAXCONNECTS           =

It very much depends on whether your users use imap or
pop3.

For 18 clients doing IMAP use something like

nchildren	 = 4
maxchildren	 = 150
minsparechildren = 4
maxsparechildren = 8
maxconnects      = 100

but really ymmv. Dual pentium doesn't really mean anything
to me. 2G sounds good
though, assuming you've properly tuned mysql.

> We are experiencing a lot slow responses and time outs
from dbmail.  The
> logs have a lot of these entries:
> dbmail-imapd[10643]: Error:[auth]
authldap.c,auth_search(+244): Can't
> contact LDAP server

Now what is going on here with your ldap server? This can't
be good.

> dbmail-imapd[16199]: Error:[server]
pool.c,set_lock(+66): Error setting
> lock. Trying again.

You can ignore these.

-- 
 
____________________________________________________________
____
  Paul Stevens                                      paul at
nfg.nl
  NET FACILITIES GROUP                     GPG/PGP:
1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

On 10/17/07, Paul J Stevens <paulnfg.nl> wrote:

Hello!

How about 80 IMAP users? In dbmail.conf I set
"maxchildren      = 250"
but in dbmail-imapd.state i see something like this
Scoreboard state: children [28/200], spares [5 (2 - 4)]

maxchildren MAX value is hardcoded?

I ask, because I has problem when many users use mail server
and
children value is maximum -  Thunderbird can't store
outgoing mails in
sent folder. All mail clients with default setting
"Maximum number of
server connections to cache"= 5

> > Hello,
> >
> nchildren        = 4
> maxchildren      = 150
> minsparechildren = 4
> maxsparechildren = 8
> maxconnects      = 100
>
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Edvins wrote:
> On 10/17/07, Paul J Stevens <paulnfg.nl> wrote:
> 
> Hello!
> 
> How about 80 IMAP users? In dbmail.conf I set
"maxchildren      = 250"
> but in dbmail-imapd.state i see something like this
> Scoreboard state: children [28/200], spares [5 (2 -
4)]
> 
> maxchildren MAX value is hardcoded?

It's capped at 200 in pool.h

Feel free to change that. There is no real reason to
maintain that value
other than as a safety net. The sum of MAXCHILDREN over all
dbmail
servers should never exceed the number of connections your
database can
handle.



> 
> I ask, because I has problem when many users use mail
server and
> children value is maximum -  Thunderbird can't store
outgoing mails in
> sent folder. All mail clients with default setting
"Maximum number of
> server connections to cache"= 5

consider using imapproxy


-- 
 
____________________________________________________________
____
  Paul Stevens                                      paul at
nfg.nl
  NET FACILITIES GROUP                     GPG/PGP:
1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

On 10/17/07, Paul J Stevens <paulnfg.nl> wrote:
> Edvins wrote:
> > On 10/17/07, Paul J Stevens <paulnfg.nl> wrote:
> >
> > Hello!
> >
> > How about 80 IMAP users? In dbmail.conf I set
"maxchildren      = 250"
> > but in dbmail-imapd.state i see something like
this
> > Scoreboard state: children [28/200], spares [5 (2
- 4)]
> >
> > maxchildren MAX value is hardcoded?
>
> It's capped at 200 in pool.h
>
> Feel free to change that. There is no real reason to
maintain that value
> other than as a safety net. The sum of MAXCHILDREN over
all dbmail
> servers should never exceed the number of connections
your database can
> handle.

I don't want compile dbmail. I think, for many reasons, 
better is
binary package with good configuration file from
repository.


>
> >
> > I ask, because I has problem when many users use
mail server and
> > children value is maximum -  Thunderbird can't
store outgoing mails in
> > sent folder. All mail clients with default setting
"Maximum number of
> > server connections to cache"= 5
>
> consider using imapproxy

Imapproxy don't solve this problem. Today I install
UP-ImapProxy.

#head -n1 /var/run/dbmail/dbmail-imapd.state
Scoreboard state: children [177/200], spares [2 (2 - 4)]


>
>
> --
>  
____________________________________________________________
____
>   Paul Stevens                                     
paul at nfg.nl
>   NET FACILITIES GROUP                     GPG/PGP:
1024D/11F8CD31
>   The Netherlands________________________________http://www.nfg.nl
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Edvins wrote:

> I don't want compile dbmail. I think, for many reasons,
 better is
> binary package with good configuration file from
repository.

I understand, and I'll fix that limit in the next releases.

> Imapproxy don't solve this problem. Today I install
UP-ImapProxy.
> 
> #head -n1 /var/run/dbmail/dbmail-imapd.state
> Scoreboard state: children [177/200], spares [2 (2 -
4)]

Bummer.

-- 
 
____________________________________________________________
____
  Paul Stevens                                      paul at
nfg.nl
  NET FACILITIES GROUP                     GPG/PGP:
1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

On 10/18/07, Paul J Stevens <paulnfg.nl> wrote:
> Edvins wrote:
>
> > I don't want compile dbmail. I think, for many
reasons,  better is
> > binary package with good configuration file from
repository.
>
> I understand, and I'll fix that limit in the next
releases.
>
Thanks!
> > Imapproxy don't solve this problem. Today I
install UP-ImapProxy.
> >
> > #head -n1 /var/run/dbmail/dbmail-imapd.state
> > Scoreboard state: children [177/200], spares [2 (2
- 4)]
>
> Bummer.
This is one of many reasons why I don't want compile and
create debian
package :P
>
> --
>  
____________________________________________________________
____
>   Paul Stevens                                     
paul at nfg.nl
>   NET FACILITIES GROUP                     GPG/PGP:
1024D/11F8CD31
>   The Netherlands________________________________http://www.nfg.nl
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Paul J Stevens wrote:

> maxconnects      = 100

The default value with the dbmail.conf shipped is 10000,
that's quite 
different from your setup/suggestion(?). How often should we
restart 
children?


Regards,

-- 
Aleksander Kamenik
system administrator
+372 6659 649
aleksanderkrediidiinfo.ee

Krediidiinfo AS
http://www.krediidiinfo.e
e/
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Aleksander Kamenik wrote:
> Paul J Stevens wrote:
> 
>> maxconnects      = 100
> 
> The default value with the dbmail.conf shipped is
10000, that's quite
> different from your setup/suggestion(?). How often
should we restart
> children?

Whatever you feel comfortable with. There have been some
serious
problems in the earlier 2.2 versions with memory leakage.
Setting
maxconnects to something low will help out there.

Currently leakage is minimal afaict, so something like 1000
or even
10000 should be ok. For pop3d 10000 (the default will most
likely be
just fine), but for imap I prefer to err on the side of
caution.

-- 
 
____________________________________________________________
____
  Paul Stevens                                      paul at
nfg.nl
  NET FACILITIES GROUP                     GPG/PGP:
1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail