MySQL Forums
Forum List  »  Full-Text Search

Re: Mysql is frequently getting restarted
Posted by: neonle lee
Date: June 19, 2009 10:15PM

There are many types of MyISAM corruption based on their cause. First there are ones which come from MySQL bugs themselves, not crashes. Similar could be further corruption based on previous corruption or MySQL format changes with version upgrade.

If you get corruption and this is reason of the crash this could be MySQL problem or hardware/OS problem. Bad memory is quite frequent cause of corruption for example.

Now if it is MySQL problem you may get problems which correspond to particular query (good as easy to track and fix) or general memory corruption case when you can see random queries crashing.

Anyway looking at your logs as well as on output of check table command for currupted table is good way to start.

"Text to speech"
"Text to Speech (TTS) API"

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Mysql is frequently getting restarted
2911
June 19, 2009 10:15PM


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.