List:General Discussion« Previous MessageNext Message »
From:Suresh Kuna Date:October 14 2011 8:22am
Subject:Re: Databasename/Tablename is marked as crashed and should be repaired
View as plain text  
Hi,

The permanent solution is to convert the table into Innodb engine.

Thanks
Suresh Kuna

On Fri, Oct 14, 2011 at 1:00 PM, Mark Goodge <mark@stripped> wrote:

> 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 <http://www.ratemysupermarket.com>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?**
> unsub=sureshkumarilu@stripped<http://lists.mysql.com/mysql?unsub=1
>
>


-- 
Thanks
Suresh Kuna
MySQL DBA

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