Thanks,
Ray A.
Just another note,
it seems that for every page access, there is exactly 680k of memory that accumulates.
Any php developer know of any odbc function that takes up 680k of overhead that might not be getting cleaned up?
Thanks,
Ray A.
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
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
