RT Apache memory leak. any examples of MPM settings?

My request tracker apache has been eating up memory. I think there is a
memory leak. Below is my prefork MPM and Worker MPM what setting do you
recommend?

prefork MPM

StartServers: number of server processes to start

MinSpareServers: minimum number of server processes which are kept

spare

MaxSpareServers: maximum number of server processes which are kept

spare

MaxClients: maximum number of server processes allowed to start

MaxRequestsPerChild: maximum number of requests a server process

serves

StartServers          2

MinSpareServers       2

MaxSpareServers       3

MaxClients           50

MaxRequestsPerChild  1000

worker MPM

StartServers: initial number of server processes to start

MaxClients: maximum number of simultaneous client connections

MinSpareThreads: minimum number of worker threads which are kept spare

MaxSpareThreads: maximum number of worker threads which are kept spare

ThreadsPerChild: constant number of worker threads in each server

process

MaxRequestsPerChild: maximum number of requests a server process

serves

StartServers 2

ThreadLimit          64

event MPM

StartServers: initial number of server processes to start

MaxClients: maximum number of simultaneous client connections

MinSpareThreads: minimum number of worker threads which are kept spare

MaxSpareThreads: maximum number of worker threads which are kept spare

ThreadsPerChild: constant number of worker threads in each server

process

MaxRequestsPerChild: maximum number of requests a server process

serves

StartServers          2

MaxClients           50

MinSpareThreads      25

MaxSpareThreads     100 

ThreadLimit          64

ThreadsPerChild      25

MaxRequestsPerChild  1500

Michael Neuschafer

PC Support Specialist

National Stores Inc.

(310) 436 - 2150

Never noticed issues with Apache. What version are you running?

Will

Apache version 2.2.12

Michael Neuschafer

PC Support Specialist

National Stores Inc.

(310) 436 - 2150

[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Will SaniSent: Friday, February 19, 2010 10:49 AM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT Apache memory leak. any examples of MPM
settings?

Never noticed issues with Apache. What version are you running?

Will

It is not a memory leak, memory does not get returned to the
system – ever. So a large query can bloat the memory usage
and it will not shrink. We use cron to do a “graceful” apache
restart once a day. No impact to users and it handles the
memory usage growth over time.

Regards,
KenOn Fri, Feb 19, 2010 at 10:31:53AM -0800, Michael Neuschafer wrote:

My request tracker apache has been eating up memory. I think there is a
memory leak. Below is my prefork MPM and Worker MPM what setting do you
recommend?

prefork MPM

StartServers: number of server processes to start

MinSpareServers: minimum number of server processes which are kept

spare

MaxSpareServers: maximum number of server processes which are kept

spare

MaxClients: maximum number of server processes allowed to start

MaxRequestsPerChild: maximum number of requests a server process

serves

StartServers          2

MinSpareServers       2

MaxSpareServers       3

MaxClients           50

MaxRequestsPerChild  1000

worker MPM

StartServers: initial number of server processes to start

MaxClients: maximum number of simultaneous client connections

MinSpareThreads: minimum number of worker threads which are kept spare

MaxSpareThreads: maximum number of worker threads which are kept spare

ThreadsPerChild: constant number of worker threads in each server

process

MaxRequestsPerChild: maximum number of requests a server process

serves

StartServers 2

ThreadLimit          64

event MPM

StartServers: initial number of server processes to start

MaxClients: maximum number of simultaneous client connections

MinSpareThreads: minimum number of worker threads which are kept spare

MaxSpareThreads: maximum number of worker threads which are kept spare

ThreadsPerChild: constant number of worker threads in each server

process

MaxRequestsPerChild: maximum number of requests a server process

serves

StartServers          2

MaxClients           50

MinSpareThreads      25

MaxSpareThreads     100 

ThreadLimit          64

ThreadsPerChild      25

MaxRequestsPerChild  1500

Michael Neuschafer

PC Support Specialist

National Stores Inc.

(310) 436 - 2150


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

2010 RT Training Sessions!
San Francisco, CA, USA - Feb 22 & 23
Dublin, Ireland - Mar 15 & 16
Boston, MA, USA - April 5 & 6
Washington DC, USA - Oct 25 & 26

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Highly doubt Apache is to blame, especially 2.2.x. What eluded you to think
it was Apache?

WillFrom: Michael Neuschafer [mailto:mneuschafer@nationalstoresinc.com]
Sent: Friday, February 19, 2010 10:51 AM
To: Will Sani; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] RT Apache memory leak. any examples of MPM settings?

Apache version 2.2.12

Michael Neuschafer

PC Support Specialist

National Stores Inc.

(310) 436 - 2150

From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Will Sani
Sent: Friday, February 19, 2010 10:49 AM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT Apache memory leak. any examples of MPM settings?

Never noticed issues with Apache. What version are you running?

Will

Well, when I restart apache my memory and swap drops down.

Michael Neuschafer

PC Support Specialist

National Stores Inc.

(310) 436 - 2150

[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Will SaniSent: Friday, February 19, 2010 11:18 AM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT Apache memory leak. any examples of MPM
settings?

Highly doubt Apache is to blame, especially 2.2.x. What eluded you to
think it was Apache?

Will

From: Michael Neuschafer [mailto:mneuschafer@nationalstoresinc.com]
Sent: Friday, February 19, 2010 10:51 AM
To: Will Sani; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] RT Apache memory leak. any examples of MPM
settings?

Apache version 2.2.12

Michael Neuschafer

PC Support Specialist

National Stores Inc.

(310) 436 - 2150

From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Will Sani
Sent: Friday, February 19, 2010 10:49 AM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT Apache memory leak. any examples of MPM
settings?

Never noticed issues with Apache. What version are you running?

Will

That’s a good start. You might want to also look into your MySQL schema.
There is a slight possibility that large DB queries are causing this issue.
I forgot to ask, what RT version are you running?

WillFrom: Michael Neuschafer [mailto:mneuschafer@nationalstoresinc.com]
Sent: Friday, February 19, 2010 11:21 AM
To: Will Sani; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] RT Apache memory leak. any examples of MPM settings?

Well, when I restart apache my memory and swap drops down.

Michael Neuschafer

PC Support Specialist

National Stores Inc.

(310) 436 - 2150

From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Will Sani
Sent: Friday, February 19, 2010 11:18 AM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT Apache memory leak. any examples of MPM settings?

Highly doubt Apache is to blame, especially 2.2.x. What eluded you to think
it was Apache?

Will

From: Michael Neuschafer [mailto:mneuschafer@nationalstoresinc.com]
Sent: Friday, February 19, 2010 10:51 AM
To: Will Sani; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] RT Apache memory leak. any examples of MPM settings?

Apache version 2.2.12

Michael Neuschafer

PC Support Specialist

National Stores Inc.

(310) 436 - 2150

From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Will Sani
Sent: Friday, February 19, 2010 10:49 AM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT Apache memory leak. any examples of MPM settings?

Never noticed issues with Apache. What version are you running?

Will

RT 3.8.6, I just thought it was the MPM Settings, with
maxrequestperchild or threadlimit.

Michael Neuschafer

PC Support Specialist

National Stores Inc.

(310) 436 - 2150

[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Will SaniSent: Friday, February 19, 2010 11:24 AM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT Apache memory leak. any examples of MPM
settings?

That’s a good start. You might want to also look into your MySQL schema.
There is a slight possibility that large DB queries are causing this
issue. I forgot to ask, what RT version are you running?

Will

From: Michael Neuschafer [mailto:mneuschafer@nationalstoresinc.com]
Sent: Friday, February 19, 2010 11:21 AM
To: Will Sani; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] RT Apache memory leak. any examples of MPM
settings?

Well, when I restart apache my memory and swap drops down.

Michael Neuschafer

PC Support Specialist

National Stores Inc.

(310) 436 - 2150

From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Will Sani
Sent: Friday, February 19, 2010 11:18 AM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT Apache memory leak. any examples of MPM
settings?

Highly doubt Apache is to blame, especially 2.2.x. What eluded you to
think it was Apache?

Will

From: Michael Neuschafer [mailto:mneuschafer@nationalstoresinc.com]
Sent: Friday, February 19, 2010 10:51 AM
To: Will Sani; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] RT Apache memory leak. any examples of MPM
settings?

Apache version 2.2.12

Michael Neuschafer

PC Support Specialist

National Stores Inc.

(310) 436 - 2150

From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Will Sani
Sent: Friday, February 19, 2010 10:49 AM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT Apache memory leak. any examples of MPM
settings?

Never noticed issues with Apache. What version are you running?

Will