I think I may have found my problem

I wasn't releasing my result sets from my queries. like you saw in the warnings above. Im not sure why this would make mysql crash but it did. I thought the result sets automatically closed upon exit of the query or the page? Or even time out after a while.

Here was the solution

<?php

mysql_free_result("QUERY VARIABLE HERE");

?>

Problem is back! even with all my pages releasing the results. I also tried closing the mysql connection but that didnt seem to help either. I have not done this to all my pages though. Is it advisable to close my connection on every page? I do multiple quieries to the same database.

Have you ran mysqlcheck (or whatever it's called) on all your tables?

Just a thought...

-Chris

No actualy I havent I will try that and get back to you.

2 clients are using or haven't closed the table properly
this is all I get but its on acouple of tables...

did it a couple of times more and evretrything checks out ok

This might give us a clue.
I have max media manager installed after getting errors so I know its not because of this and I get this whenever I try to see statistics.


Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 35 bytes) in /var/www/localhost/htdocs/xyz/max-v0.3.21-alpha/lib/pear/HTML/Template/Flexy/Tokenizer.php on line 1197

seems that is a different error I just upped the memory to 16M instead of the default 8 and I got rid of the problem above.

Havent had mysql crash today yet but I dont think the two problems were related.

Server still crashing randomly no Idea what to try next. The code seems to work great on the development machine without a problem.
Development machine has same setup gentoo os and mysql versions are identical.

I just unmerged removed all traces of mysql nd reinstalled mysql 5.0... still seems to have the same problem.


is this a bad setup for a production server?


Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode On On


mysql.trace_mode I just turned this off

host 45 reboot this morning might have solved my problem.

I can't pinpoint it though because I un-merged mysql removed all databases and re-emerged mysql then restored my databases.

everything was running until host 45 just stopped responding at around 7:12 EST.