The mail setup is working fine overall, but this is happening on a small environment. This only started happening when I upgrade to 2.0.4 when it was released. Before that, the queries were down to a normal rate. I don't see why it has to connect and then disconnect every 1 second. Why won't it just take a persistent connection until the daemon is killed and re-created?
In any case, it's a minor issue anyways because my mail is getting delivered still without any issues. It's just increasing the load on the DB server. My queries per second average have jumped from 1.5 to 3 (this is a small implementation of dbmail of course) since upgrading to 2.0.4. Hopefully someone can determine if this is a problem or not. It just seems wrong to me. Thanks, Angus On 9/7/05, M. J. [Mike] O'Brien <[EMAIL PROTECTED]> wrote: > > 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<http://localhost.canadaemails.net:3949>canadaemails > Sleep > 2124 > 4024602 dbmail > localhost.canadaemails.net:2336<http://localhost.canadaemails.net:2336>canadaemails > Sleep > 1524 > 4026154 dbmail > localhost.canadaemails.net:2822<http://localhost.canadaemails.net:2822>canadaemails > Sleep > 1524 > 4026155 dbmail > localhost.canadaemails.net:2851<http://localhost.canadaemails.net:2851>canadaemails > Sleep > 1225 > 4027702 dbmail > localhost.canadaemails.net:1388<http://localhost.canadaemails.net:1388>canadaemails > Sleep > 1224 > 4027705 dbmail > localhost.canadaemails.net:3814<http://localhost.canadaemails.net:3814>canadaemails > Sleep > 924 > 4029254 dbmail > localhost.canadaemails.net:1208<http://localhost.canadaemails.net:1208>canadaemails > Sleep > 924 > 4029260 dbmail > localhost.canadaemails.net:4873<http://localhost.canadaemails.net:4873>canadaemails > Sleep > 624 > 4030777 dbmail > localhost.canadaemails.net:3328<http://localhost.canadaemails.net:3328>canadaemails > Sleep > 624 > 4030780 dbmail > localhost.canadaemails.net:4301<http://localhost.canadaemails.net:4301>canadaemails > Sleep > 574 > 4032277 dbmail > localhost.canadaemails.net:3820<http://localhost.canadaemails.net:3820>canadaemails > Sleep > 494 > 4032279 dbmail > localhost.canadaemails.net:1636<http://localhost.canadaemails.net:1636>canadaemails > Sleep > 324 > 4033784 dbmail > localhost.canadaemails.net:1519<http://localhost.canadaemails.net:1519>canadaemails > Sleep > 324 > 4033786 dbmail > localhost.canadaemails.net:3915<http://localhost.canadaemails.net:3915>canadaemails > Sleep > 24 > 4033876 dbmail > localhost.canadaemails.net:1894<http://localhost.canadaemails.net:1894>canadaemails > Sleep > 23 > 4034133 dbmail > localhost.canadaemails.net:3672<http://localhost.canadaemails.net:3672>canadaemails > Sleep > 2425 > 4035302 dbmail > localhost.canadaemails.net:3990<http://localhost.canadaemails.net:3990>canadaemails > Sleep > 2424 > 4035305 dbmail > localhost.canadaemails.net:4807<http://localhost.canadaemails.net:4807>canadaemails > Sleep > 2124 > 4036808 dbmail > localhost.canadaemails.net:4542<http://localhost.canadaemails.net:4542>canadaemails > Sleep > 1824 > 4038314 dbmail > localhost.canadaemails.net:4912<http://localhost.canadaemails.net:4912>canadaemails > Sleep > 1824 > 4213116 dbmail > localhost.canadaemails.net:4126<http://localhost.canadaemails.net:4126>canadaemails > Sleep > 15341 > 4227381 dbmail > localhost.canadaemails.net:1815<http://localhost.canadaemails.net:1815>canadaemails > Sleep > 14431 > 4607609 dbmail > localhost.canadaemails.net:4212<http://localhost.canadaemails.net:4212>canadaemails > Sleep > 504 > 4615141 dbmail > localhost.canadaemails.net:4556<http://localhost.canadaemails.net:4556>canadaemails > Sleep > 484 > 4615350 dbmail > localhost.canadaemails.net:1278<http://localhost.canadaemails.net:1278>canadaemails > Sleep > 480 > 4643139 dbmail > localhost.canadaemails.net:1197<http://localhost.canadaemails.net:1197>canadaemails > Sleep > 23 > 4660979 dbmail > localhost.canadaemails.net:1833<http://localhost.canadaemails.net:1833>canadaemails > Sleep > 253 > 4666461 dbmail > localhost.canadaemails.net:4392<http://localhost.canadaemails.net:4392>canadaemails > Sleep > 286 > 4670815 dbmail > localhost.canadaemails.net:3896<http://localhost.canadaemails.net:3896>canadaemails > Sleep > 503 > 4670926 dbmail > localhost.canadaemails.net:4678<http://localhost.canadaemails.net:4678>canadaemails > Sleep > 484 > 4684738 dbmail > localhost.canadaemails.net:4410<http://localhost.canadaemails.net:4410>canadaemails > Sleep > 418 > 4684784 dbmail > localhost.canadaemails.net:3453<http://localhost.canadaemails.net:3453>canadaemails > Sleep > 417 > 4684797 dbmail > localhost.canadaemails.net:3669<http://localhost.canadaemails.net:3669>canadaemails > Sleep > 501 > 4684861 dbmail > localhost.canadaemails.net:3985<http://localhost.canadaemails.net:3985>canadaemails > Sleep > 324 > 4698304 dbmail > localhost.canadaemails.net:2097<http://localhost.canadaemails.net:2097>canadaemails > Sleep > 482 > 4698310 dbmail > localhost.canadaemails.net:4198<http://localhost.canadaemails.net:4198>canadaemails > Sleep > 510 > 4698867 dbmail > localhost.canadaemails.net:1078<http://localhost.canadaemails.net:1078>canadaemails > Sleep > 411 > 4698893 dbmail > localhost.canadaemails.net:3972<http://localhost.canadaemails.net:3972>canadaemails > Sleep > 281 > 4702822 dbmail > localhost.canadaemails.net:3313<http://localhost.canadaemails.net:3313>canadaemails > Sleep > 502 > 4702828 dbmail > localhost.canadaemails.net:3759<http://localhost.canadaemails.net:3759>canadaemails > Sleep > 480 > 4712966 dbmail > snowball.canadaemails.net:56347<http://snowball.canadaemails.net:56347>canadaemails > Sleep > 489 > 4713014 dbmail > localhost.canadaemails.net:1529<http://localhost.canadaemails.net:1529>canadaemails > Sleep > 482 > 4716034 dbmail > localhost.canadaemails.net:3098<http://localhost.canadaemails.net:3098>canadaemails > Sleep > 652 > 4721065 dbmail > localhost.canadaemails.net:1523<http://localhost.canadaemails.net:1523>canadaemails > Sleep > 511 > 4726698 dbmail > localhost.canadaemails.net:2816<http://localhost.canadaemails.net:2816>canadaemails > Sleep > 24 > 4726705 dbmail > localhost.canadaemails.net:2055<http://localhost.canadaemails.net:2055>canadaemails > Sleep > 15635 > 4732507 dbmail > localhost.canadaemails.net:2525<http://localhost.canadaemails.net:2525>canadaemails > Sleep > 15197 > 4737755 dbmail > localhost.canadaemails.net:3469<http://localhost.canadaemails.net:3469>canadaemails > Sleep > 15094 > 4742487 dbmail > localhost.canadaemails.net:4849<http://localhost.canadaemails.net:4849>canadaemails > Sleep > 14798 > 4754594 dbmail > localhost.canadaemails.net:1273<http://localhost.canadaemails.net:1273>canadaemails > Sleep > 324 > 4766177 dbmail > localhost.canadaemails.net:3936<http://localhost.canadaemails.net:3936>canadaemails > Sleep > 14210 > 4768354 dbmail > localhost.canadaemails.net:4696<http://localhost.canadaemails.net:4696>canadaemails > Sleep > 412 > 4768415 dbmail > localhost.canadaemails.net:1127<http://localhost.canadaemails.net:1127>canadaemails > Sleep > 508 > 4777504 dbmail > localhost.canadaemails.net:1703<http://localhost.canadaemails.net:1703>canadaemails > Sleep > 13655 > 4778039 dbmail > localhost.canadaemails.net:4304<http://localhost.canadaemails.net:4304>canadaemails > Sleep > 13132 > 4779992 dbmail > snowball.canadaemails.net:64381<http://snowball.canadaemails.net:64381>canadaemails > Sleep > 490 > 4782374 dbmail > localhost.canadaemails.net:3113<http://localhost.canadaemails.net:3113>canadaemails > Sleep > 500 > 4782522 dbmail > snowball.canadaemails.net:61861<http://snowball.canadaemails.net:61861>canadaemails > Sleep > 322 > 4783825 dbmail > localhost.canadaemails.net:1214<http://localhost.canadaemails.net:1214>canadaemails > Sleep > 12812 > 4789313 dbmail > localhost.canadaemails.net:1732<http://localhost.canadaemails.net:1732>canadaemails > Sleep > 12297 > 4796366 dbmail > localhost.canadaemails.net:1235<http://localhost.canadaemails.net:1235>canadaemails > Sleep > 12094 > 4798904 dbmail > localhost.canadaemails.net:1474<http://localhost.canadaemails.net:1474>canadaemails > Sleep > 11426 > 4801422 dbmail > localhost.canadaemails.net:4701<http://localhost.canadaemails.net:4701>canadaemails > Sleep > 11164 > 4810873 dbmail > localhost.canadaemails.net:3826<http://localhost.canadaemails.net:3826>canadaemails > Sleep > 10923 > 4812451 dbmail > localhost.canadaemails.net:1134<http://localhost.canadaemails.net:1134>canadaemails > Sleep > 9652 > 4817479 dbmail > localhost.canadaemails.net:3525<http://localhost.canadaemails.net:3525>canadaemails > Sleep > 9266 > 4819440 dbmail > snowball.canadaemails.net:61671<http://snowball.canadaemails.net:61671>canadaemails > Sleep > 21 > 4820949 dbmail > snowball.canadaemails.net:50350<http://snowball.canadaemails.net:50350>canadaemails > Sleep > 322 > 4821354 dbmail > localhost.canadaemails.net:4318<http://localhost.canadaemails.net:4318>canadaemails > Sleep > 8763 > 4822213 dbmail > localhost.canadaemails.net:4344<http://localhost.canadaemails.net:4344>canadaemails > Sleep > 8362 > 4827431 dbmail > localhost.canadaemails.net:3754<http://localhost.canadaemails.net:3754>canadaemails > Sleep > 5778 > 4831349 dbmail > localhost.canadaemails.net:4501<http://localhost.canadaemails.net:4501>canadaemails > Sleep > 4989 > 4835633 dbmail > localhost.canadaemails.net:1952<http://localhost.canadaemails.net:1952>canadaemails > Sleep > 4753 > 4839642 dbmail > localhost.canadaemails.net:2678<http://localhost.canadaemails.net:2678>canadaemails > Sleep > 4061 > 4840283 dbmail > snowball.canadaemails.net:55960<http://snowball.canadaemails.net:55960>canadaemails > Sleep > 21 > 4842134 dbmail > localhost.canadaemails.net:1463<http://localhost.canadaemails.net:1463>canadaemails > Sleep > 3565 > 4851040 dbmail > localhost.canadaemails.net:1311<http://localhost.canadaemails.net:1311>canadaemails > Sleep > 3107 > 4852056 dbmail > localhost.canadaemails.net:1467<http://localhost.canadaemails.net:1467>canadaemails > Sleep > 2981 > 4853378 dbmail > localhost.canadaemails.net:1187<http://localhost.canadaemails.net:1187>canadaemails > Sleep > 2770 > 4853939 dbmail > localhost.canadaemails.net:4044<http://localhost.canadaemails.net:4044>canadaemails > Sleep > 2424 > 4855154 dbmail > localhost.canadaemails.net:3344<http://localhost.canadaemails.net:3344>canadaemails > Sleep > 2061 > 4885961 dbmail > snowball.canadaemails.net:53245<http://snowball.canadaemails.net:53245>canadaemails > Sleep > 6466 > 4889219 dbmail > snowball.canadaemails.net:52687<http://snowball.canadaemails.net:52687>canadaemails > Sleep > 6466 > 4900304 dbmail > snowball.canadaemails.net:64538<http://snowball.canadaemails.net:64538>canadaemails > Sleep > 6466 > 4900305 dbmail > snowball.canadaemails.net:56514<http://snowball.canadaemails.net:56514>canadaemails > Sleep > 7365 > 4900306 dbmail > snowball.canadaemails.net:54001<http://snowball.canadaemails.net:54001>canadaemails > Sleep > 7365 > 4900307 dbmail > snowball.canadaemails.net:59320<http://snowball.canadaemails.net:59320>canadaemails > Sleep > 7365 > 4904820 dbmail > snowball.canadaemails.net:62710<http://snowball.canadaemails.net:62710>canadaemails > Sleep > 6466 > 4937813 dbmail > smtp2.canadaemails.com:62240<http://smtp2.canadaemails.com:62240>canadaemails > Sleep 25 > 4937879 root > smtp2.canadaemails.com:53867<http://smtp2.canadaemails.com:53867>canadaemails > Sleep 11 > 4937882 root > smtp2.canadaemails.com:56622<http://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 > > > > _______________________________________________ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail >
