On Mon, Jun 26, 2006 at 04:41:48PM +0200, Anders J wrote: > Could i ask how your login class (/etc/login.conf) for mysql looks like? > And maybe your [mysqld_safe] entry in/etc/my.cnf? > I already modified my kern.maxfiles in /etc/sysctl.conf to > kern.maxfiles=10000 and in my own /etc/login.conf class i have set the > follwing values: > mysql:\ > :datasize=infinity:\ > :maxproc=infinity:\ > :openfiles-cur=2048:\ > :openfiles-max=8192:\
Relevant parts of /etc/my.cnf [mysqld_safe] open-files=2000 Looking at the machines here, doesn't appear I've actually altered anything in /etc/login.conf in reguards to mysql. In /etc/sysctl.conf: kern.maxproc=1536 kern.maxfiles=8192 Mind you, this isn't meant to imply that this is "right" - just what has been working for me. I have to admit that the various numbers for the sysctl and open-files were pulled out of thin air and tried until problems stopped. If there's a magic formula for it, I am unaware of it. > TIA > Anders > > Trombley wrote: > > I've run postfix on OpenBSD using MySQL as the database for several > > years with +400 domains and +4k users; handling about 300K messages > > per day. Never gives me any problems. > > > > I had to bump the kern.maxproc and kern.maxfiles sysctl (man 8 sysctl) > > and add the following to /etc/my.cnf > > [mysqld_safe] > > open-files=2000 > > > > You may also want to alter the appropriate parts of /etc/login.conf > > (maxproc + openfiles) (man 5 login.conf) > > > > Hope it serves you as well as it has me.
