Mysql Shutdown no reason

[GreenDev]

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

 

[lvalics]

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.

 

[GreenDev]

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.