I guess these are from max_connections in my.cnf right? I set the limit to 1000, but I'm wondering why it crashed so soon already. There are not many mailboxes right now, just about 200 (and around 1000 more to import from the old server...). Should I check something?

Also, googling around, I saw "proxymap" might be a solution to this. Would it work with iRedOS?

Re: Too many connections

Re: Too many connections

There is nothing in mysqld.log, besides the usual things. Mysqld was running at below 5% CPU usage, memory usage below 10%. But the maillog filled with 4 MB of log data in only 15 minutes, all with the same errors. All tables in vmail are ok (I checked integrity).

After setting the parameters like above, everything was fine again in 1-2 minutes, no more errors. But that "rush-hour thing" was realy strange.

Do you think proxymap could be a future solution if this happens again?My.cnf is right now like this, do you think it's ok?:

o To consolidate the number of open lookup tables by sharing one open table among multiple processes. For example, making mysql connections from every Postfix daemon process results in "too many connec- tions" errors. The solution:

virtual_alias_maps = proxy:mysql:/etc/postfix/virtual_alias.cf

The total number of connections is limited by the number of proxymap server processes.

Maybe we should change all LDAP/MYSQL lookup into proxymap to avoid similar issues.

Re: Too many connections

I also think it would be a better idea to use PostgreSQL instead of MySQL. It's a lot more stable and resilient. I saw web servers with mysql locking with low load, while postgresql can withstand 1000 times more...

Are these safe for current iRedOS? Did you test them to see if they work ok? And if they do, where should I put them, master.cf or main.cf? I'm asking that because the page above says they should be in main.cf, but I see some of them in master.cf in iRedOS.