Performance Problems

[SurgeProto]

I was wondering if anyone using MySQL and PHP have experienced performance problems on their server? I use

// close connection
mysql_free_result($queryname);
mysql_close($connection);

after every connection and query to free up the resources. I was wondering if I needed to do anything. I want to make sure that once the page loads, all possible resources are being freed up. The server memory seems to slowly fill up and crash every 2 weeks. ANy ideas what would cause that?

[weekender]

what OS is on the server? Unix? Win? other? what version? it's unlikely to be php or mysql (unless it is your code, but that seems doubtful).

[SurgeProto]

It's a typical linux webserver. Apache, MySQL, etc. I didn't think it was the code either but I couldn't figure it out.

[LordShryku]

Have you been running top to see what process is eating all of the memory? You could have some defunct processes out there that need to be killed. And this may not even be MySQL or Apache doing it. How much traffic do you take on? And what kind of pages are you running(Flash animation under heavy loads can eat away at resources)