Cutting down on sql connections

[Robert Moskowitz]

On 04/13/2017 07:33 PM, David Mehler wrote:
> Hello,
>
> I'm running dovecot 2.29 on a freebsd 10.3 system. I'm trying to cut
> down queries to my database and tried to do a userdb static and
> prefetch. I modified the password query to pull in userdb_quota and
> got an error that that was not valid. Is this behavior normal?
>
> Apr 13 17:22:15 hostname dovecot: master: Dovecot v2.2.29 (13ebc01)
> starting up for imap, sieve
> Apr 13 17:22:24 hostname dovecot: imap-login: Login:
> user=<username at example.com>, method=PLAIN, rip=127.0.0.1,
> lip=127.0.0.1, mpid=66452, secured, session=<TYjM6xJNnqp/AAAB>
> Apr 13 17:22:24 hostname dovecot: imap(username at example.com): Logged
> out in=102 out=3020
> Apr 13 17:22:24 hostname dovecot: imap-login: Login:
> user=<username at example.com>, method=PLAIN, rip=127.0.0.1,
> lip=127.0.0.1, mpid=68924, secured, session=<4xDQ6xJNht1/AAAB>
> Apr 13 17:22:24 hostname dovecot: imap(username

Change to use the mysql socket:

driver = mysql
connect = host=/var/lib/mysql/mysql.sock dbname=postfix user=postfix 
password=Postfix_Database_Password