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.330992 2152 ?? Ss4Jun03
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
