Version 2.1? Okay, what I'm going to do is have a look around the net for more info on this. Having a MySQL backend should ease a few performance issues. Also I got a mail from someone saying that sending out about 100k mails with a few bad ones would bring my server to it's knees... hmm... that is SO not good! But it has one function, yep you guessed it, it's my mail server, and that's all it does. It runs a samba client, but that's just so that my windows boxes can see it. What would be a better MTA to use? Any recommendations?
-----Original Message----- From: Harold Paulson [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 12:20 AM To: [EMAIL PROTECTED] Cc: Angel Gabriel Subject: RE: [Mailman-Users] Does mailman support a MySQL backend? Angel, For what it's worth... Mailman 2.1 is supposed to be able to use alternative backends (such as MySQL) to store user information. However, I haven't actually seen this working yet. Personally, I have given up on using Mailman for large broadcast-only lists. Mailman seems to do a lot of things based on the assumption that it's being used for an interactive list. Configuring it for broadcasting tends to be a lot of work. I use a custom-built Perl+PHP+MySQL thingy I wrote, for large broadcast lists these days. On a side note, if you are planning to send to a list of 100k+ addresses with a large number of bad ones, you had better be using something other than Sendmail. It *will* bring your machine to it's knees spawning a limitless number of queue running processes[1]. Good luck! :) - H Note: [1] If someone would like to contradict me on this point, I'd love to hear your argument, and see what config you suggest. Seriously, I really would like to see a solution. Please include more than MAX_DAEMON_CHILDREN, QUEUE_LA, or REFUSE_LA in your answer, since they do not seem affect queue runs. >I'm using RH 7.3 and I have a DSL line @ 256k upload - I havn't even >attempted to send messages to list anymore, because I can't even get the web >interface to come up, it times out. I adjusted the cf files manually to show >3000 addresses per page, and STILL the pages time out. I'm thinking of using >a diffrent application to send out my email. I know a lot of the addresses >are going to bounce, and that is REALLY going to mess up performance, it's >such a shame, we've spent FOUR years collecting these addreses, from 16 >diffrenct universities up and down England. The thing that worries me, is >the bouncing mail, I don't mind if my server takes three days to send all >the mail, it's a one way list, I just want to increase performance when it >comes to admin tasks. > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED]]On Behalf Of Dan Wilder >Sent: Thursday, September 19, 2002 6:17 PM >To: Mailman (E-mail) >Subject: Re: [Mailman-Users] Does mailman support a MySQL backend? > > >On Thu, Sep 19, 2002 at 05:35:19PM +0100, Angel Gabriel wrote: >> I was wondering if mailman supports a MySQL backend, because one of my >lists >> has hit over 100k addresses, and performance is REALLY bad. If mailman >> doesn't support a MySQL backend, does anyone know of any mailing list >> managers that do?? Any help would be appreciated. Thanks in adance. > >Do you know whether it's mailman, or your MUA that's the sticky >wicket? > >We have one list with 20,000 subscribers. It used to take several >days to get everybody out. Inspection revealed it was the MTA, >Postfix, which needed load tuning, and also the Linux kernel, >which needed some kernel parameters bumped up to allow Postfix >the elbow room to run 150 concurrent delivery processes. > >Now it takes about three hours for most of the good addresses >on the list to get delivered. The sticky wicket is the internet >connection, which also supports telecommuters, so we've had >to tune the mailserver to stop short of saturating the connection. > >-- >----------------------------------------------------------------- > Dan Wilder <[EMAIL PROTECTED]> Technical Manager > SSC, Inc. P.O. Box 55549 Phone: 206-782-8808 > Seattle, WA 98155-0549 URL http://www.linuxjournal.com/ >----------------------------------------------------------------- > >------------------------------------------------------ >Mailman-Users mailing list >[EMAIL PROTECTED] >http://mail.python.org/mailman/listinfo/mailman-users >Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py >Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/ -- Harold Paulson Sierra Web Design [EMAIL PROTECTED] http://www.sierraweb.com VOICE: 775.833.9500 FAX:�� 775-201-4458 ------------------------------------------------------ Mailman-Users mailing list [EMAIL PROTECTED] http://mail.python.org/mailman/listinfo/mailman-users Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/
