[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