apache mod_php memory leak, need help.

From: Date: Mon, 23 Jun 2003 21:58:16 +0000
Subject: apache mod_php memory leak, need help.
Groups: php.general 
Request: Send a blank email to php-general+get-152544@lists.php.net to get a copy of this message
Hello, I hope someone can help me or point me in a good direction. I have a database driven website, all ODBC to postgresql, that little by little eats up resources on apache. The child processes will start off at 30Mb of virtual memory and run up around 230Mb each child. (see below ps output) before they start dying. It does not even take 700 accesses per child to max out memory. I then start getting funny errors like access denied to file or could not open socket, or file not found. I read all to documentation and as far as I know, php should release any defined query resources once the script executes. I already code with odbc_close($conn); on all my pages. It is not feasible to use odbc_free_result() on every query, due to the complexity of scripts, but the documentation for odbc_free_result says you shouldn't have to. That is the only thing that I can think of that could be draining this much resources. Is there any good way to find out what is eating up the memory. Anyone else run into this. I'm running apache 1.3.27 with php 4.3.2 (happened in version 4.3.1 also) on mac OSX SERVER 10.2.4 Thanks in advance, Ray A. PS OUTPUT ---------------------------------------------------------------------------
root       468   0.0  0.3    30992   2152  ??  Ss    4Jun03   1:30.04 /usr/sbin/httpd
www       1743   0.0  1.2   222600  10032  ??  S     8:00AM   2:16.31 /usr/sbin/httpd
www       1767   0.0  1.1   220560   9592  ??  S     8:01AM   1:58.56 /usr/sbin/httpd
www       1806   0.0  1.1   215800   9588  ??  S     8:13AM   1:46.92 /usr/sbin/httpd
www       1876   0.0  1.1   210360   9532  ??  S     8:44AM   1:56.10 /usr/sbin/httpd
www       1878   0.0  1.3   224304  10904  ??  S     8:44AM   2:13.93 /usr/sbin/httpd
www       1879   0.0  1.2   219880   9912  ??  S     8:44AM   2:10.85 /usr/sbin/httpd


« previous php.general (#152544) next »