mySQL keeps hanging up after several days

[Toepes]

Every 3 - 4 days mySQL stops working. Websites using mySQL databases work 100% okee but after several days mySQL quits working and restarting the service doesn't work. Only thing that helps is a reboot.

The only entries in the windows logfile is that the programm is terminated because the connection to the mysql database has a time-out.

* Is there a way to see a log regarding Mysql actions ?
* anyone an idea what this problem causes ?

 

[Frozen_penguin@]

hi

it is occuring plesk 7.5.3 and 7.5.4 but I think it is not a problem about plesk. it seems a bug about mysql .

I am getting same problem. but if you can upgrade innodb log size it will solve for a time like 1 week or more or less then. I am not sure about time but I am sure about it is doing it for innodb log. I didn't find how can I upgrade innodb log files .

if some body knows it . please tell us.

Regards

 

[Gris@]

You can see MySQL log files at SWsoft\Plesk\Databases\MySQL\Data.

 

[Frozen_penguin@]

Sure but I didn't find the file which I can increase innodb log size.

Regards

 

[Toepes]

I received a tip to change my PHP.ini
It seems that some PHP programms don't close connections after use.


This line is added to close the connections after use:


; Allow or prevent persistent links.
mysql.allow_persistent=Off

I'll let you know if this is the solution.