List:General Discussion« Previous MessageNext Message »
From:Chris Knipe Date:November 30 2010 12:43pm
Subject:Re: Possible causes of table crashing
View as plain text  
No idea on the cause, but sitting with the exact same issue on 1 specific
MyISAM table on mysql-5.1.50

Since the table was created it never had any change in data structure, the
table is almost exclusively INSERTs and it is quite big in my instance
however.  Table crashes on average every 2 to 3 days for no apparent reason
what so ever, and everytime it repairs successfully...

--
Chris.



On Tue, Nov 30, 2010 at 1:20 PM, Mark Goodge <mark@stripped> wrote:

> Hi,
>
> I have a very strange problem whereby one particular table in our database
> is repeatedly (on average, every couple of days) generating errors stating
> that the table is crashed and needs to be repaired. Running a repair fixes
> it.
>
> What makes it strange (and something that I've never encountered before) is
> the following:
>
> 1. There is one particular table which it happens to a lot, and a few other
> tables where it happens occasionally. Everything else is fine.
>
> 2. None of the tables where it happens are among the most heavily used or
> commonly updated.
>
> 3. There is no shortage of disk space.
>
> 4. The disk system reports no errors.
>
> 5. We have multiple databases with an identical structure but different
> content (we are an online retailer and each database is a separate
> storefront), but the problem occurs in all the databases - but the same
> tables in each database. It doesn't always happen to each database at the
> same time - it seems to be random.
>
> 6. (This is the really strange one) We have two separate servers with
> identical copies of the databases, one for production use and one for
> development use, and it happens independently on both of them - but still
> the same tables (and, specifically, the same table that it happens to more
> often than any other).
>
> 7. And, of course, the obvious statement: we haven't changed the structure
> of this database recently (it hasn't changed for months, if not years).
>
> We are running MySQL 5.0.77 on Centos. All the databases use MyISAM
> exclusively.
>
> Given the above, can anyone suggest any possible causes?
>
> Thanks
>
> Mark
> --
> http://mark.goodge.co.uk
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>


-- 

Regards,
Chris Knipe

Thread
Possible causes of table crashingMark Goodge30 Nov
  • Re: Possible causes of table crashingChris Knipe30 Nov