List:General Discussion« Previous MessageNext Message »
From:Mark Goodge Date:October 14 2011 7:30am
Subject:Re: Databasename/Tablename is marked as crashed and should be repaired
View as plain text  
On 14/10/2011 08:07, James wrote:
> Hello,
>
> I have the following error on my mysql server log and managed to repaired
> the broken table. However, it keeps occurring by time to time. I am using
> MyISAM storage engine to all database and having some locking table which I
> know / aware about the disadvantage of MyISAM.
>
> './Databasename/Tablename' is marked as crashed and should be repaired
>
> Are there any ways to solved permanently? Any advise would be appreciated.

If it's happening repeatedly, and the MySQL server itself is running 
without any problems (ie, it isn't crashing and restarting) then you may 
have problems with the hardware - with the disk itself.

Mark
-- 
  Sent from my Babbage Difference Engine
  http://mark.goodge.co.uk
  http://www.ratemysupermarket.com
Thread
Databasename/Tablename is marked as crashed and should be repairedJames14 Oct
  • Re: Databasename/Tablename is marked as crashed and should be repairedMark Goodge14 Oct
    • Re: Databasename/Tablename is marked as crashed and should be repairedSuresh Kuna14 Oct
      • Re: Databasename/Tablename is marked as crashed and should be repairedJohan De Meersman14 Oct