PHP&mysql causing Apache to hang

[danjohn1234]

Hello,

I have been banging my head all day trying to figure this problem out. I am running RedHat 8 with Apache 2.0.40, PHP 4.2.2 and mysql 3.23.52. My problem is this...

I have a session based site that pulls session variables out to query a database to display search results. On about every 5th or 6th reload od the search results Apache will hang and use up 100% of the CPU on the server (its a dual 1.6GHz Athlon box with a Gig of RAM). On the queries that don't hang it uses less than .1% of the CPU. Memory usage on the box is low at all times.

I've read that the Apache,PHP,mySQL combo I'm using isn't offically supported, but has anyone else experienced this problem or something similar?

Thanks,

[daynah]

I experienced the same problem when:

1) I forget to close my mysql connection
2) I have a infinite loop running somewhere

Be sure to check your script to see if there are any semantic errors.

Apache, PHP, and mySQL running on the same server should work fine.