Re: Postfix and memcached

Oh, sorry, it's 5 million connections per day. But we have 700 header
check rules and 600 body check rules. We use mysql to handle the header
and body check instead of pcre or regexp, for we found mysql is much
faster than pcre and regexp.=20
There are about 600 messages/min which will get through the body/header
checks. If each message is 25k in size, it will query mysql 328 times.
So the total query number is about 3000/sec full table accesses.



=E5=9C=A8 2005-06-08=E4=B8=89=E7=9A=84 08:56 +0300=EF=BC=8CJussi Silvenno=
inen=E5=86=99=E9=81=93=EF=BC=9A
> > we have postfix installed on 7 machines, each of which handles 500
> > million connections everyday. Each connection will trigger about 3 ta=
ble
> > lookups. I'm wondering if we can put mysql as the central database to
> > service the lookups?=20
> >=20
> > > > There is a patch for postfix to use memcached.
> > > > http://www.aurore.net/projects/postfix_memcached/
> > > >=20
> > >=20
> > > Why is this necessary? I have not seen a sensibly configured MTA t=
hat
> > > is query constrained. The usual complaint is connection concurrency=
,
> > > and proxymap solves that.
>=20
> ~6000 per second? Are you sure you got the numbers right?
>=20