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 Shutdown no reason

Discussion in 'Plesk 9.x for Linux Issues, Fixes, How-To' started by GreenDev, Jul 29, 2011.

  1. GreenDev

    GreenDev Guest

    0
     
    Mysql Shutdown no reason on night, big ibdata1 [resolved]

    Hello,

    i'm in plesk 9.5

    last few days, my mysql server has a problem every night at 3:15 to 3:20
    The mysqld is running, but not accessible ! (Database Error: Unable to connect to the database:Could not connect to MySQL)
    i must do /etc/init.d/mysqld restart, and is OK STOP, START is OK ...

    I search the reason, but I can not find.

    on crontab i see that at this time :
    /usr/local/psa/admin/bin/php /opt/plesk-billing/admin/sbin/runevents.php

    what is launch by runevents.php ? the plesk task ?
    and what else ?

    have you a list ???

    Thanks
     
    Last edited by a moderator: Aug 2, 2011
  2. lvalics

    lvalics Silver Pleskian Plesk Guru

    36
    43%
    Joined:
    Jun 20, 2003
    Messages:
    965
    Likes Received:
    32
    Location:
    Romania
    Could be MySQL backups or something what use MySQL too much and kill it. In some cases can die MySQL. Better check MySQL error log.
     
  3. GreenDev

    GreenDev Guest

    0
     
    Ok,I thought the same thing

    i've my ibdata1 file was up than 4G

    i've create a second mysql server on port 3307
    i've move big database on the second mysql server

    on the first mysql server, i've export all database
    i've rename mysql dir on mysql.old and create a new empty mysql dir.

    and import the bakup, and now, it's ok.
     
Loading...