1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

mySQL keeps hanging up after several days

Discussion in 'Plesk for Windows - 8.x and Older' started by Toepes, Oct 4, 2005.

  1. Toepes

    Toepes Guest

    0
     
    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 ?
     
  2. Frozen_penguin@

    Frozen_penguin@ Guest

    0
     
    :(

    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
     
  3. Gris@

    Gris@ Guest

    0
     
    You can see MySQL log files at SWsoft\Plesk\Databases\MySQL\Data.
     
  4. Frozen_penguin@

    Frozen_penguin@ Guest

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

    Regards
     
  5. Toepes

    Toepes Guest

    0
     
    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.
     
Loading...