On Wed, Nov 22, 2023 at 02:59:06PM -0300, Rafael Azevedo via Postfix-users
wrote:
> We're using Postfix + Mysql and we're getting this mysql connection
> lost issue very often.
>
> Nov 22 14:38:28 smtp2 smtp2/smtpd[15858]: warning:
> mysql:/etc/postfix/mysql_virtual_alias_maps.cf: query failed: Lost
> connection to MySQL server during query
Somehow you never got the message that you should be using:
proxy:mysql:/path/to/table.cf
rather than
mysql:/path/to/table.cf
Your server will be much happier when you pool MySQL connections via the
proxyread(8) service.
See also the documentation of proxy_read_maps (which you don't need to
change in the most cases, just helpful context).
--
Viktor.
_______________________________________________
Postfix-users mailing list -- postfix-users@postfix.org
To unsubscribe send an email to postfix-users-le...@postfix.org
