MySQL Forums
Forum List  »  MySQL Administrator

need help from expert: mysql keeps crashing!!!
Posted by: khalid touati
Date: November 02, 2009 08:45AM

Hi All,
after shuting down Mysqld improperly, it's crashing now every 3 hours (when under use by apps running mysql, in weekend no PB) and i have to restart it to continue using it.
i tried to repair all tables after shuting down properly the server (as it said in "Mysql keeps crashing" in the reference manual") using these two commands:
mysqladmin shutdown;
myisamchk --silent --force */*.MYI ;
i was watching the processes launched for a long time i noticed that a lot of process not related to any database are running using root as user.
i have the processlist and the debug info while it was not working (crashed), but unfortunately i don't see here a way to attach this (and i don't want to make my message more long).
so for the kind expert person who is willing to help me :) (i hope somebdy will!), i'll email it to him and thanks for you all!

Options: ReplyQuote


Subject
Written By
Posted
need help from expert: mysql keeps crashing!!!
November 02, 2009 08:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.