Bill Wichers wrote: >> If I increase the connection limit in qmail to 100, when the limit >> hits about 60 I get the following : >> >> 2005-01-25 01:01:34.011714500 vmysql: error creating table >> 'dir_control': MySQL server has gone away >> 2005-01-25 01:01:34.011775500 vmysql: sql error[b]: MySQL server has >> gone away >> >> Any idea how to fix this problem? > > You probably need to up the max number of connections allowed by > MySQL. If I am remembering correctly, it defaults to 100 simultaneous > connections. Remember that with a MySQL backend, vpopmail will be > doing a *lot* of db activity that MySQL is going to be involved in. > > -Bill >
I had horrible load problems when logging to MySQL. I started logging to syslog and everything ran much more smoothly. Then again...I take in about 3-7 pop connections a second and don't have a beefy MySQL server. Unless you have a specific reason to log to MySQL, I would recommend that you log to syslog and be done with it. If you must log to MySQL, I'm sure that max connections are the problem. -jw-