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 <m...@good-stuff.co.uk> 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=sureshkumar...@gmail.com<http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com> > > -- Thanks Suresh Kuna MySQL DBA