[rt-users] SOS:: many mysql processes are killing RAM, why?
Craig Ringer
craig at 2ndquadrant.com
Mon Jul 22 22:14:39 EDT 2013
On 07/19/2013 11:42 PM, Alex Decalli wrote:
>
> I have RT 3.8 on mysql 5.1 on ubuntu 11.04. Why do I have many mysql
> processes they are bringing down RAM.
Quite likely you have too many Apache workers with mod_perl, or too many
fcgi workers if you're using fcgi.
You will need to limit the number of concurrent RT workers - assuming
that the MySQL workers are even being used by RT, which we don't know
based on the information you have provided.
Alternately, you can put a *connection pool* in place between RT and the
database. If you were using PostgreSQL I would advise you to use
PgBouncer in transaction pooling mode, but I cannot offer much advice
for MySQL. I'm sure there's a similar pooling proxy.
This sort of question is probably better suited to Serverfault.com than
the RT list. BTW, text output is usually way more useful than
screenshots; eg "top -b -n 1".
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
More information about the rt-users
mailing list