• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

mySQL keeps hanging up after several days

T

Toepes

Guest
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 ?
 
:(

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
 
You can see MySQL log files at SWsoft\Plesk\Databases\MySQL\Data.
 
Sure but I didn't find the file which I can increase innodb log size.

Regards
 
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.
 
Back
Top