On 5/2/2017 6:33 PM, David Mehler wrote: > Hi, > > I'm not sure what to send. I've temporarily solved the problem by > increasing the mysql max_connections setting from 256 to 300 and > started working. Something is using up mysql processes when the lmtp > socket is used. > > Dave.
Postfix makes lots of mysql connections. This is normal and expected. As Viktor already suggested, the solution is to use the postfix proxymap service to consolidate the mysql connections. This will greatly reduce the number of connections postfix makes to mysql and usually improve performance too. Documentation for proxymap is here: http://www.postfix.org/proxymap.8.html http://www.postfix.org/postconf.5.html#proxy_read_maps Using the proxymap service is really easy. Generally, everywhere in main.cf you have mysql:... you replace with proxy:mysql:... In some cases you may need to alter the default value of proxy_read_maps. There will be warnings in the log to guide you if this is needed. -- Noel Jones --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
