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 
table, etc)

> > 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

Reply via email to