MySQL needs restarting every couple of months

[Lcousins]

Hi all,

as the title suggests Im experiencing the problem that I have to restart mysql ever couple of months (approximately). Its actually a works server containing an two websites, one acting as an intranet that uses php and mysql quite heavily and as such we have limited support from the company we rent the server off.

Unfortunately all the advice theyre willing to give me is

Normally if MYSQL crashes every couple of months then you have some script/application that uses this and it is not closing the process properly. Please check any scripts/applications you may be using.

which given my limited knowledge means tiddlyzip to me. could someone please point me in the direction of the sort of thing I should be looking for??

thanks

Lcousins

[iNFERiON]

Well, all scripts should close their connection to your database with the following code.

/* Closing connection */
mysql_close($link);

Where $link is mentioned earlier in your code with something that looks like this:

$link = mysql_connect("mysql_host", "mysql_user", "mysql_password")
   or die("Could not connect : " . mysql_error());