>>> In my postfix proxymap may not be working very well: >>> warning: virtual_mailbox_domains: proxy:mysql:/etc/postfix/map.sql: table >>> lookup problem >>> warning: memcache:/etc/postfix/memcache_recipient_whitelist_cache.cf: table >>> lookup problem >>> >>> because in mysql i see many hanging processes > > I have a 15489 domain - slow log is empty (via >3) > This is simply query like > query=SELECT domain FROM domain WHERE domain='%s'
Then there should be an INDEX on the domain column, but even without it would not decrease performance severely with just 15k rows as they are in mysql/innodb page cache when queried constantly. > Now I change memche map to proxy:mysql and probably problem solved > In db I have ~200 - all from postfix Just remember to put proxy:mysql: everywhere you use mysql lookups and add those to proxy_read_maps or you might still be running into mysql connection limit. Best regards Gerald
