Possible causes of table crashing

2010-11-30 Thread Mark Goodge
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

Re: Possible causes of table crashing

2010-11-30 Thread Chris Knipe
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