Any way to minimize the number of sql statements that dovecot do?
(and I tried adding userdb prefetch { } but number of sql calls are still the same)
Am I doing something wrong or?
Regards,
BTJ
--
Bjørn T Johansen
btj@havleik.no
Someone wrote: "I understand that if you play a Windows CD backwards you hear strange Satanic messages" To which someone replied: "It's even worse than that; play it forwards and it installs Windows"
On 13.11.2007, at 13.21, Bjørn T Johansen wrote:
Any way to minimize the number of sql statements that dovecot do?
(and I tried adding userdb prefetch { } but number of sql calls are
still the same)
Did you add the userdb_* fields to passdb? Did you put prefetch
before userdb sql? Show dovecot -n output? Set auth_debug=yes to see
what SQL queries Dovecot actually sends.
For actual caching there's also auth_cache_size setting which is 0 by
default.
On Tue, 13 Nov 2007 15:17:48 +0200 Timo Sirainen tss@iki.fi wrote:
On 13.11.2007, at 13.21, Bjørn T Johansen wrote:
Any way to minimize the number of sql statements that dovecot do?
(and I tried adding userdb prefetch { } but number of sql calls are
still the same)Did you add the userdb_* fields to passdb?
Yes...
Did you put prefetchbefore userdb sql?
Nope... That might be the reason....?
Show dovecot -n output?
# 1.0.7: /etc/dovecot/dovecot.conf log_path: /lv1/logs/dovecot.log protocols: imap imaps pop3 pop3s listen: [*] disable_plaintext_auth: no login_dir: /usr/var/run/dovecot/login login_executable(default): /usr/libexec/dovecot/imap-login login_executable(imap): /usr/libexec/dovecot/imap-login login_executable(pop3): /usr/libexec/dovecot/pop3-login mail_location: maildir:/opt/vmail/%d/%n mail_executable(default): /usr/libexec/dovecot/imap mail_executable(imap): /usr/libexec/dovecot/imap mail_executable(pop3): /usr/libexec/dovecot/pop3 mail_plugin_dir(default): /usr/lib/dovecot/imap mail_plugin_dir(imap): /usr/lib/dovecot/imap mail_plugin_dir(pop3): /usr/lib/dovecot/pop3 pop3_uidl_format(default): pop3_uidl_format(imap): pop3_uidl_format(pop3): %08Xu%08Xv pop3_client_workarounds(default): pop3_client_workarounds(imap): pop3_client_workarounds(pop3): outlook-no-nuls auth default: mechanisms: plain login digest-md5 cram-md5 user: vmail passdb: driver: sql args: /etc/dovecot/dovecot-sql.conf userdb: driver: passwd userdb: driver: prefetch userdb: driver: sql args: /etc/dovecot/dovecot-sql.conf socket: type: listen client: path: /var/spool/postfix/private/auth mode: 432 user: postfix group: postfix master: path: /var/run/dovecot/auth-master mode: 384 user: vmai
Set auth_debug=yes to see
what SQL queries Dovecot actually sends.
For actual caching there's also auth_cache_size setting which is 0 by
default.
auth_cache_size is used for only authentication or all sql access?
BTJ
participants (2)
-
Bjørn T Johansen
-
Timo Sirainen