Hi Simon,
Basically we have a webmail service, which connects to 4 different IMAP
servers via perdition. As I said there is 13,000+ entries in popmap.re,
using this format: (.*)(a)domain.com: 123.123.123.123
We have a script which reloads perdition every hour as changes are made to
popmap.re frequently. The problem is when a user first attempts to login
they experience a delay in authenticating. Each time this happens the
perdition.imap4 process consumes 100% cpu for about 60 seconds, after about
30 seconds there are 3 perdition.imap4 processes all consuming cpu usage.
I suspect that because the contents of popmap.re is so large, perdition is
taking longer to process the request.
thanks,
Stephen
On Wed, Jan 21, 2009 at 11:04 AM, Simon Horman <horms(a)verge.net.au> wrote:
On Wed, Jan 21, 2009 at 10:28:13AM +1100, Stephen
Vaughan wrote:
Hi,
Is it possible to store regular expressions in a mysql database? We have
over 13,000 RE's in our popmap.re and understandably each time a user
authenticates its taking a long time to process the request.
Hi Stephen,
I'd need to understand a bit more about what you are doing in order to
suggest a solution to that problem. But to answer your question, no
perdition doesn't support storing regexes in MySQL directly. I suspect that
either adding a specialised popmap, or to write a daemon that returns
results to the daemon map.
--
Simon Horman
VA Linux Systems Japan K.K., Sydney, Australia Satellite Office
H:
www.vergenet.net/~horms/ <http://www.vergenet.net/%7Ehorms/>
W:
www.valinux.co.jp/en
--
Best Regards,
Stephen