On Tue, Dec 21, 1999 at 05:01:22PM +0800, Michael Boman wrote:
> The problem isnt either the database server, it's fine tuned to the maximum. The
> problem is that SMTP/POP3 is causing ALLOT of traffic to the database server.
>
> It wouldn't matter if we put Oracle or MS Sql instead, 'cause the traffic will still
> be there. What I am looking for is a way to slow down the queries, limit them some
>how,
> to the database server.
What do you mean by ALOT of traffic?
We've changed POP3 auth to a MySQL database (homegrown scripts etc.)
and had problems during prime times that the mysql server wasn't
responding fast enough thus up to 120 checkpassword scripts were "in the
queue" on the POP3 server waiting for connections and some of them dying
due to timeouts.
I set up a test environment and noticed that the mysql server was only
able to handle 3-4 requests a second. Inspecting the tables I found out
that we had defined an INDEX false. This had the effect that the INDEX
was unusable for the authent requests. Fixing this and stress testing in
the testing environment got us more than 400 successful requests per
second. We have about 15K userbase and now it runs smoothly without
problems.
Maybe this helps.
\Maex
--
SpaceNet GmbH | http://www.Space.Net/ | Stress is when you wake
Research & Development | mailto:[EMAIL PROTECTED] | up screaming and you
Joseph-Dollinger-Bogen 14 | Tel: +49 (89) 32356-0 | realize you haven't
D-80807 Muenchen | Fax: +49 (89) 32356-299 | fallen asleep yet.
