I’ve got several tables getting corrupted at a regular basis.
These tables range from 1000+ rows to 5M rows. All the errors are corrupted indexes. I am not sure if it is hardware or mysql.
Can you give me any suggestions on what might be causing this?
Here are the specs:
OS Fedora Core 5 64-bit
DB MySQL 5.0.27 x64
37M total rows
4GB total data size
2.5GB total index size
NOTE: table corruption happens only on several tables which are very frequently accessed/updated. All are MyISAM. I converted one large table to innodb and it has stopped from being corrupted regularly. I am not sure with this solution as InnoDB wont be as fast as MyISAM, and I need the tables to be updated and viewed very quickly.
Athlon 64 X2 dual core processor 4200+
2 200GB SATA on RAID1 as main partitions
1 250GB IDE as backup partition
I do a daily check on the tables but sometimes they crash during operating hours and have to repair them.
These crashes never happened with mysql4.1. The hardware was recently upgraded.
Any suggestions would be appreciated.
Just tell me if anyone needs any additional info.
Thanks in advance.