Mysql frequently down with Event Scheduler: Loaded 0 events

[gopkris2005]

One of our server mysql keep down frequently with the following errors.

130507 5:14:06 InnoDB: Started; log sequence number 119 391265068
130507 5:14:06 [Note] Event Scheduler: Loaded 0 event

Repaired all the database and configured values very well in my.cnf.

how to fix it?

 

[Veeble-Adam]

It seems like the InnoDB has been crashed.

The only way to recover innodb is to start mysql with various levels of innodb_force_recovery (starting from 4) and try to dump the databases. This would be the only possible way- attempt to dump all databases, drop all databases, stop mysql, remove innodb_force_recovery from my.cnf, kill innodb files, start mysql and restore all databases.

 

[gopkris2005]

Thanks... I have used innodb_force_recovery=4 and restart mysql server. Repaired all the innodb databases...

It seems like the InnoDB has been crashed.

The only way to recover innodb is to start mysql with various levels of innodb_force_recovery (starting from 4) and try to dump the databases. This would be the only possible way- attempt to dump all databases, drop all databases, stop mysql, remove innodb_force_recovery from my.cnf, kill innodb files, start mysql and restore all databases.

 

[Veeble-Adam]

Glad to hear it helped!