The permanent solution is to convert the table into Innodb engine.
On Fri, Oct 14, 2011 at 1:00 PM, Mark Goodge <mark@stripped> wrote:
> On 14/10/2011 08:07, James wrote:
>> 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
>> 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.
> Sent from my Babbage Difference Engine
> 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?**