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

G

GreenDev

Guest
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:
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.
 
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.
 
Back
Top