1. Please take a little time for this simple survey! Thank you for participating!
    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...