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, Ken On 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 > > <IfModule mpm_prefork_module> > > StartServers 2 > > MinSpareServers 2 > > MaxSpareServers 3 > > MaxClients 50 > > MaxRequestsPerChild 1000 > > </IfModule> > > > > # 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 > > <IfModule mpm_worker_module> > > StartServers 2 > > ThreadLimit 64 > > </IfModule> > > > > # 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 > > <IfModule mpm_event_module> > > StartServers 2 > > MaxClients 50 > > MinSpareThreads 25 > > MaxSpareThreads 100 > > ThreadLimit 64 > > ThreadsPerChild 25 > > MaxRequestsPerChild 1500 > > </IfModule> > > > > 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: [email protected] > > 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 _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] 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
