Jeff Garvas wrote:
>
> Hello,
>
> I installed my first qmail box about two months ago with all of the
> googdies from inter7.com. One of the most popular is the qmailadmin
> feature.
>
> I'm using mysql based authentication and letting domain holders edit all
> of the specifics in their domain via qmailadmin.
>
> Recently we've noticed the system load has become rather high. I'm only
> hosting about 10 virtual domains, but at times I'll find tcprules and a
> mysqld process running anywhere between 3 and 75 processes each.
>
> I believe qmailadmin is somehow to blame for this, if not a
> misconfiguration by myself.
Proof of what can cause it? I know that an active SMTP/POP3 feed will be
able to kill your MySQL database (been there, done that). With just one
domain and about 60 staff we manage to kill a dual-CPU PIII 500MHz w/
256 Mb RAM MySQL server.
What killed it was the number of open-check-close connections, one per
user-session (one for each recipient for local delivery of mail and one
per pop3 session).
There was some code given to Ken quite a while back that creates a
caching layer between vpopmail and the mySQL database. What happend with
that ode I don't know, but Ken and the author of the code said that the
code needs more work before it can be included in the distrobution of
vpopmail. Ken, could you please update us what happend on this issue?
> Does anyone know if qmailadmin runs tcprules and/or mysql each time
> someone logs into it and manages their domain?
>
> Unfortunately what ever it is that is spawning tcprules so frequently is
> also spawning mysqld and causing my machine to come to a halt practically.
>
> Any help would be appreciated, I'm a bit unsure of how to debug this
> issue.
>
> -Jeff
Best regards
Michael Boman
