> 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
Does the query from /etc/postfix/map.sql hang when you try it manually in mysql monitor? If that table is long, is there an index on the columns you search for? Do those queries hit mysql slow log? You could enable mysql general log and see what query postfix sends and try that manually (EXPLAIN SELECT ...). How many entries does "show processlist" in mysql show? Are these all from postfix? What state are they in? How high is your configured mysql connection limit? Best regards Gerald
