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: (.*)@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 10:28:13AM +1100, Stephen Vaughan wrote:Hi Stephen,
> 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.
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/ W: www.valinux.co.jp/en