On 04.12.2020 16:11, Gerald Galster wrote: >> 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' Now I change memche map to proxy:mysql and probably problem solved In db I have ~200 - all from postfix > 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 > > --
