Ideas on Table Crashing Cause

I have a third party module in which a database table continues to crash on me.  I have contacted the developer but he could shed no light.  Now the table did not crash before the server upgrade but the server is running the exact same configuration except a larger hard drive.

Normally it is stated that the table being reported crashed

table xxxx is marked as crashed and last (automatic?) repair failed 


is caused by the indexes not matching due to mysql server going down.  However, mysql server is not going down and it is the same table time and time agian.

 

So I am looking for some of the mysql gurus that might can shed more light on why this one table would continue to crash over and over.


Geeks, making the world a better place
Quote · 23 Jun 2015

Table can be marked as crashed if server died unexpectedly. But usually after such things happen - it will self recover.

Also running out of free disk space could cause crashed tables as well.

So I would suggest to check:

- free disk space (the partition with mysql data and tmp partition)

- check mysql error log just after mysql crashed - for the particular error

Rules → http://www.boonex.com/terms
Quote · 23 Jun 2015

I agree with AlexT on this one.

In pretty much all cases where i have experienced the problem, it has always been due to hard drive space issues.

If the databases are kept within a directory that is a partition mount, does that partition have more than enough space for the databases?  Most servers are not configured with the database storage setup as a separate partition, so that is not likely the issue, but should still be checked.

The other thing that can cause it is lack of space in the tmp folder which on most servers is configured as it's own partition. If that partition the tmp folder uses does not have plenty of space for mysql to work with, it can cause this problem with the tables.

The error logs should provide a clue.

https://www.deanbassett.com
Quote · 23 Jun 2015

hm...try innodb for some time, and try keeping daily backups for few days.

Edit: check logs first.

so much to do....
Quote · 23 Jun 2015

Yes, the suggestions I know about but why problems with this one table and no other database issues?  If it is drive space shouldn't I see other tables having issues; like when someone writes a blog post?

Geeks, making the world a better place
Quote · 23 Jun 2015

Stop mysql. 

Go to your data folder and issue: myisamchk -r -v -f <table_name>

Restart mysql 

Quote · 2 Jul 2015
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.