Very Computer

Quote:>While I was testing my web pages, I actually ran out of memory and the only
>thing I could do was to walk over to the server and give the three fingered
>salute.  It was as if the memory wasn't being released properly.  I
>installed Apache 1.2b8 and that seemed to help a little bit, the memory
>used doesn't seem to climb as quickly.  

Are you running PHP as an apache module?  If so, try running "strip" on
your httpd binary as it will contain a lot of debugging symbols by default
when you build it.  THat will reduce the size of the executable by a good
amount.

What version of flex are your running?  PHP has been known to have some
problems with versions of flex prior to 2.5.4 (but not the type of probs
that you seem to be having).

Id suggest killing of MySQL for a while and see if you still have the same
troubles.  Try to see if you have any runaway processes next time the
machine starts to bog down (use top).

Hope this helps...

Regards,
Mike

--
Hal 9000 - "Put down those Windows disks Dave....  Dave?  DAVE!!"

I recently got the following packages running together:

Apache 1.2b7
PHP 2.0b10
MySQL 3.20.17-beta
on
Linux altair.ces.fau.edu 2.0.27 #1 Sat Dec 21 23:44:11 EST 1996 i586

Lot of beta there.

I have noticed  what may be a problem with memory usage growing and
eventually crashing my server.  By crash I mean that if I am logged in, I
stay logged in but I can't run any new programs.  I tried to su root and
got libc loading errors.  At the same time my web pages returned errors
saying that PHP couldn't connect to the MySQL database.

When I first start the server, this is what free shows me:

             total       used       free     shared    buffers     cached
Mem:         14648       9360       5288       8004        708       5160
-/+ buffers:             3492      11156
Swap:        17132          0      17132

After viewing some PHP-parsed Web pages which made connections to the MySQL
database, memory usage goes up and never comes down again.  This output is
from about 6 hours after I last accessed the server.  Shouldn't some of the
memory be freed up?  

             total       used       free     shared    buffers     cached
Mem:         14648      14316        332       8004       4904       5200
-/+ buffers:             4212      10436
Swap:        17132         12      17120  

While I was testing my web pages, I actually ran out of memory and the only
thing I could do was to walk over to the server and give the three fingered
salute.  It was as if the memory wasn't being released properly.  I
installed Apache 1.2b8 and that seemed to help a little bit, the memory
used doesn't seem to climb as quickly.  

I've only run out of memory the one time so I don't know if I really have a
problem or not.  
How might I go about troubleshooting the problem?  I suppose I could remove
the MySQL support, add mSQL support in PHP, and see if I have the same type
of problem.

I guess I'm just looking for clues.  I don't know if the problem is Apache,
PHP or MySQL.  Or me.

Here is the URL of the database access page, if you try it and get an error
message from PHP about being unable to connect to the database, you will
know the server has crashed.
http://altair.ces.fau.edu/ces_public/glades/

Thanks for your comments.

--dennis

Solution: You have to do an explicit mysql_close after you're finished.
Alternatively, you can get the latest PHP snapshot, which contains the
fix already.

---/dev/il