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
