On Thu, Jun 26, 2014 at 05:08:28PM +0200, rsmits-l wrote:
> >>virtual_alias_maps = hash:/home/postfix/namen,
> >> mysql:/home/postfix/forwardsqlconnect.cf
> >>
> >>Can anyone help with this error? Mysql database performance issue is not
> >>the case. After extensive monitoring we found that max connections and
> >>memory is fine.
Turns out that perhaps the monitoring was misleading, and perhaps
connection limits were exceeded.
> >In any case you really should consider:
> >
> > virtual_alias_maps = hash:/home/postfix/namen,
> > proxy:mysql:/home/postfix/forwardsqlconnect.cf
> >
> >However, the real reason for the problem is in related log lines you
> >have not reported.
>
> I will send some logfile entry's but for starters I have read the "proxymap"
> explanation and have tried it on the mailserver. This seems to work ! No
> more errors.
The most plausible solution to the rescue.
> I will read some more online, but if I understand correctly,
> this proxymap process will regulate the connections to mysql in a better way
With proxyman(8) multiple processes query the database via a single
proxy that uses a single connection to the database to make queries
on behalf of multiple clients (other Postfix services).
Database connection concurrency typically goes down by one to two
orders of magnitude.
--
Viktor.
