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