On Tuesday 06 July 2004 04:41 pm, Charles Sprickman wrote:
> On Mon, 5 Jul 2004, Jeremy Kitchen wrote:
> > Also, on top of that, I would consider disabling auth logging as it
> > performs an insert/update upon every authentication which, no matter what
> > will go back to your central mysql server, and if you have mysql being
> > replicated, will be replicated to the front machines, which will almost
> > nearly negate any performance increases you may (and very likely will)
> > see by switching to a replicated mysql configuration.
> Interesting... Refresh my memory on this, is it a compile-time switch?
> How does vpopmail behave if that table does not exist?
yes, it's a compile time switch. If you have auth logging enabled and the
table doesn't exist, vpopmail will attempt to create it. beyond that, I
don't know (ie, if you restricted the permission so it couldn't create the
> > Also! (last one, I promise!) if you're using vpopmail's roaming users
> > support, stop now. completely disable roaming users in your vpopmail
> > configuration and set up Bruce Guenter's relay-ctrl package
> > (http://untroubled.org/relay-ctrl). No funky cronjob to run, no patches
> > required to ucspi-tcp (there's a patch out there to make it talk to
> > mysql, eek) no central cdb file to rebuild upon connection attempts, AND
> > it's safe to mount the spool directory on NFS (I've done it) as it
> > doesn't require locking or anything.
> Hmmm... Good suggestion, is there anything similar that will deal with
> Courier's pop3d?
as far as I know
> Do you have a rough feel for at what point trying to decrease updates will
> help things along? 2000 users? 10,000 users?
depends on a lot of factors. I find, personally, that last auth information
isn't overall very useful unless you're troubleshooting something (but there
are other ways you can log authentications), so I probably wouldn't ever use
it myself, but I'd say that upwards of 10k users you'd want to disable it,
especially in a cluster environment.
Jeremy Kitchen ++ Systems Administrator ++ Inter7 Internet Technologies, Inc.
[EMAIL PROTECTED] ++ www.inter7.com ++ 866.528.3530 ++ 847.492.0470 int'l
kitchen @ #qmail #gentoo on EFnet ++ scriptkitchen.com/qmail