Hello Angus:
Seems like you are good to go. How does the processlist look? Is it what you
would expect based on your dbmail.conf? How is the mail setup working for
you overall?
The number of connections alowed each daemon is established in your
/etc/dbmail.conf configuration file. You can set the MAXCHILDREN and both
MIN and MAX SPARECHILDREN which will cause some connects opening and
sleeping or closing for unused children etc..
Below are some examples appended to this:
best...
Mike
from dbmail.conf
../
[LMTP]
EFFECTIVE_USER=dbmail
EFFECTIVE_GROUP=dbmail
BINDIP=*
PORT=24
NCHILDREN=30
MAXCHILDREN=34
MAXCONNECTS=100
MINSPARECHILDREN=2
MAXSPARECHILDREN=4
TIMEOUT=300
RESOLVE_IP=yes
TRACE_LEVEL=1
MAX_ERRORS=500
MAX_RECONNECTS=1
[POP]
EFFECTIVE_USER=dbmail
EFFECTIVE_GROUP=dbmail
BINDIP=*
PORT=110
NCHILDREN=20
MAXCHILDREN=24
MINSPARECHILDREN=2
MAXSPARECHILDREN=4
MAXCONNECTS=100
TIMEOUT=300
RESOLVE_IP=yes
POP_BEFORE_SMTP=yes
TRACE_LEVEL=1
[IMAP]
EFFECTIVE_USER=dbmail
EFFECTIVE_GROUP=dbmail
BINDIP=*
PORT=143
NCHILDREN=25
MAXCHILDREN=31
MINSPARECHILDREN=2
MAXSPARECHILDREN=6
MAXCONNECTS=100
TIMEOUT=4000
RESOLVE_IP=yes
IMAP_BEFORE_SMTP=yes
TRACE_LEVEL=1
/..
Here is a snapshot of processlist of production db handling about twelve
thousand connections per hour avg.:
ID User Host
Database Command Time
4023093 dbmail localhost.canadaemails.net:3949 canadaemails Sleep
2124
4024602 dbmail localhost.canadaemails.net:2336 canadaemails Sleep
1524
4026154 dbmail localhost.canadaemails.net:2822 canadaemails Sleep
1524
4026155 dbmail localhost.canadaemails.net:2851 canadaemails Sleep
1225
4027702 dbmail localhost.canadaemails.net:1388 canadaemails Sleep
1224
4027705 dbmail localhost.canadaemails.net:3814 canadaemails Sleep
924
4029254 dbmail localhost.canadaemails.net:1208 canadaemails Sleep
924
4029260 dbmail localhost.canadaemails.net:4873 canadaemails Sleep
624
4030777 dbmail localhost.canadaemails.net:3328 canadaemails Sleep
624
4030780 dbmail localhost.canadaemails.net:4301 canadaemails Sleep
574
4032277 dbmail localhost.canadaemails.net:3820 canadaemails Sleep
494
4032279 dbmail localhost.canadaemails.net:1636 canadaemails Sleep
324
4033784 dbmail localhost.canadaemails.net:1519 canadaemails Sleep
324
4033786 dbmail localhost.canadaemails.net:3915 canadaemails Sleep
24
4033876 dbmail localhost.canadaemails.net:1894 canadaemails Sleep
23
4034133 dbmail localhost.canadaemails.net:3672 canadaemails Sleep
2425
4035302 dbmail localhost.canadaemails.net:3990 canadaemails Sleep
2424
4035305 dbmail localhost.canadaemails.net:4807 canadaemails Sleep
2124
4036808 dbmail localhost.canadaemails.net:4542 canadaemails Sleep
1824
4038314 dbmail localhost.canadaemails.net:4912 canadaemails Sleep
1824
4213116 dbmail localhost.canadaemails.net:4126 canadaemails Sleep
15341
4227381 dbmail localhost.canadaemails.net:1815 canadaemails Sleep
14431
4607609 dbmail localhost.canadaemails.net:4212 canadaemails Sleep
504
4615141 dbmail localhost.canadaemails.net:4556 canadaemails Sleep
484
4615350 dbmail localhost.canadaemails.net:1278 canadaemails Sleep
480
4643139 dbmail localhost.canadaemails.net:1197 canadaemails Sleep
23
4660979 dbmail localhost.canadaemails.net:1833 canadaemails Sleep
253
4666461 dbmail localhost.canadaemails.net:4392 canadaemails Sleep
286
4670815 dbmail localhost.canadaemails.net:3896 canadaemails Sleep
503
4670926 dbmail localhost.canadaemails.net:4678 canadaemails Sleep
484
4684738 dbmail localhost.canadaemails.net:4410 canadaemails Sleep
418
4684784 dbmail localhost.canadaemails.net:3453 canadaemails Sleep
417
4684797 dbmail localhost.canadaemails.net:3669 canadaemails Sleep
501
4684861 dbmail localhost.canadaemails.net:3985 canadaemails Sleep
324
4698304 dbmail localhost.canadaemails.net:2097 canadaemails Sleep
482
4698310 dbmail localhost.canadaemails.net:4198 canadaemails Sleep
510
4698867 dbmail localhost.canadaemails.net:1078 canadaemails Sleep
411
4698893 dbmail localhost.canadaemails.net:3972 canadaemails Sleep
281
4702822 dbmail localhost.canadaemails.net:3313 canadaemails Sleep
502
4702828 dbmail localhost.canadaemails.net:3759 canadaemails Sleep
480
4712966 dbmail snowball.canadaemails.net:56347 canadaemails Sleep
489
4713014 dbmail localhost.canadaemails.net:1529 canadaemails Sleep
482
4716034 dbmail localhost.canadaemails.net:3098 canadaemails Sleep
652
4721065 dbmail localhost.canadaemails.net:1523 canadaemails Sleep
511
4726698 dbmail localhost.canadaemails.net:2816 canadaemails Sleep
24
4726705 dbmail localhost.canadaemails.net:2055 canadaemails Sleep
15635
4732507 dbmail localhost.canadaemails.net:2525 canadaemails Sleep
15197
4737755 dbmail localhost.canadaemails.net:3469 canadaemails Sleep
15094
4742487 dbmail localhost.canadaemails.net:4849 canadaemails Sleep
14798
4754594 dbmail localhost.canadaemails.net:1273 canadaemails Sleep
324
4766177 dbmail localhost.canadaemails.net:3936 canadaemails Sleep
14210
4768354 dbmail localhost.canadaemails.net:4696 canadaemails Sleep
412
4768415 dbmail localhost.canadaemails.net:1127 canadaemails Sleep
508
4777504 dbmail localhost.canadaemails.net:1703 canadaemails Sleep
13655
4778039 dbmail localhost.canadaemails.net:4304 canadaemails Sleep
13132
4779992 dbmail snowball.canadaemails.net:64381 canadaemails Sleep
490
4782374 dbmail localhost.canadaemails.net:3113 canadaemails Sleep
500
4782522 dbmail snowball.canadaemails.net:61861 canadaemails Sleep
322
4783825 dbmail localhost.canadaemails.net:1214 canadaemails Sleep
12812
4789313 dbmail localhost.canadaemails.net:1732 canadaemails Sleep
12297
4796366 dbmail localhost.canadaemails.net:1235 canadaemails Sleep
12094
4798904 dbmail localhost.canadaemails.net:1474 canadaemails Sleep
11426
4801422 dbmail localhost.canadaemails.net:4701 canadaemails Sleep
11164
4810873 dbmail localhost.canadaemails.net:3826 canadaemails Sleep
10923
4812451 dbmail localhost.canadaemails.net:1134 canadaemails Sleep
9652
4817479 dbmail localhost.canadaemails.net:3525 canadaemails Sleep
9266
4819440 dbmail snowball.canadaemails.net:61671 canadaemails Sleep
21
4820949 dbmail snowball.canadaemails.net:50350 canadaemails Sleep
322
4821354 dbmail localhost.canadaemails.net:4318 canadaemails Sleep
8763
4822213 dbmail localhost.canadaemails.net:4344 canadaemails Sleep
8362
4827431 dbmail localhost.canadaemails.net:3754 canadaemails Sleep
5778
4831349 dbmail localhost.canadaemails.net:4501 canadaemails Sleep
4989
4835633 dbmail localhost.canadaemails.net:1952 canadaemails Sleep
4753
4839642 dbmail localhost.canadaemails.net:2678 canadaemails Sleep
4061
4840283 dbmail snowball.canadaemails.net:55960 canadaemails Sleep
21
4842134 dbmail localhost.canadaemails.net:1463 canadaemails Sleep
3565
4851040 dbmail localhost.canadaemails.net:1311 canadaemails Sleep
3107
4852056 dbmail localhost.canadaemails.net:1467 canadaemails Sleep
2981
4853378 dbmail localhost.canadaemails.net:1187 canadaemails Sleep
2770
4853939 dbmail localhost.canadaemails.net:4044 canadaemails Sleep
2424
4855154 dbmail localhost.canadaemails.net:3344 canadaemails Sleep
2061
4885961 dbmail snowball.canadaemails.net:53245 canadaemails Sleep
6466
4889219 dbmail snowball.canadaemails.net:52687 canadaemails Sleep
6466
4900304 dbmail snowball.canadaemails.net:64538 canadaemails Sleep
6466
4900305 dbmail snowball.canadaemails.net:56514 canadaemails Sleep
7365
4900306 dbmail snowball.canadaemails.net:54001 canadaemails Sleep
7365
4900307 dbmail snowball.canadaemails.net:59320 canadaemails Sleep
7365
4904820 dbmail snowball.canadaemails.net:62710 canadaemails Sleep
6466
4937813 dbmail smtp2.canadaemails.com:62240 canadaemails Sleep 25
4937879 root smtp2.canadaemails.com:53867 canadaemails Sleep 11
4937882 root smtp2.canadaemails.com:56622 canadaemails Sleep 11
----- Original Message -----
From: "Angus Jordan" <[EMAIL PROTECTED]>
To: <dbmail@dbmail.org>
Sent: Wednesday, September 07, 2005 2:23 PM
Subject: [Dbmail] Mysql - excessive Connect and quit in log
Hello all,
I am running Dbmail 2.0.5, and I am noticing a huge amount of connects and
quits to my database while any of the daemons are running. Here is a quick
excerpt from the query logfile:
<--snip-->
635 Connect [EMAIL PROTECTED] on dbmail
635 Quit
050907 11:15:07 636 Connect [EMAIL PROTECTED] on dbmail
636 Quit
637 Connect [EMAIL PROTECTED] on dbmail
637 Quit
638 Connect [EMAIL PROTECTED] on dbmail
638 Quit
050907 11:15:08 639 Connect [EMAIL PROTECTED] on dbmail
639 Quit
640 Connect [EMAIL PROTECTED] on dbmail
641 Connect [EMAIL PROTECTED] on dbmail
641 Quit
640 Quit
050907 11:15:09 642 Connect [EMAIL PROTECTED] on dbmail
642 Quit
643 Connect [EMAIL PROTECTED] on dbmail
643 Quit
644 Connect [EMAIL PROTECTED] on dbmail
644 Quit
050907 11:15:10 645 Connect [EMAIL PROTECTED] on dbmail
645 Quit
646 Connect [EMAIL PROTECTED] on dbmail
646 Quit
647 Connect [EMAIL PROTECTED] on dbmail
647 Quit
050907 11:15:11 648 Connect [EMAIL PROTECTED] on dbmail
648 Quit
649 Connect [EMAIL PROTECTED] on dbmail
649 Quit
650 Connect [EMAIL PROTECTED] on dbmail
650 Quit
050907 11:15:12 651 Connect [EMAIL PROTECTED] on dbmail
651 Quit
653 Connect [EMAIL PROTECTED] on dbmail
653 Quit
652 Connect [EMAIL PROTECTED] on dbmail
652 Quit
050907 11:15:13 654 Connect [EMAIL PROTECTED] on dbmail
654 Quit
655 Connect [EMAIL PROTECTED] on dbmail
655 Quit
050907 11:15:14 657 Connect [EMAIL PROTECTED] on dbmail
657 Quit
656 Connect [EMAIL PROTECTED] on dbmail
656 Quit
658 Connect [EMAIL PROTECTED] on dbmail
658 Quit
050907 11:15:15 659 Connect [EMAIL PROTECTED] on dbmail
659 Quit
660 Connect [EMAIL PROTECTED] on dbmail
660 Quit
661 Connect [EMAIL PROTECTED] on dbmail
661 Quit
050907 11:15:16 662 Connect [EMAIL PROTECTED] on dbmail
662 Quit
663 Connect [EMAIL PROTECTED] on dbmail
<--snip-->
Does anyone know why the daemons would do this? I can't imagine that this is
normal operation, I can't think of a reason why it would be in any case...
If you look closely, you will notice that there are 2 different hosts
connecting. One is my master server, and the other is the lmtp daemon on my
secondary mx.
Can someone shed some light on this for me?
Much appreciated,
Angus Jordan
--------------------------------------------------------------------------------
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
