CentOS 3.5 (2.4.21)
MySQL 5.0.64 Enterprise Server (Commercial)
2 GB RAM, 1 CPU
We have an application which pumps in excess of 500 records/sec to MYISAM database and after 10 hrs or so, system silently crashes.After doing a power cycle, it is found the database has crashed and tables are corrupted.mysql> select * from xyz; ERROR 1194 (HY000): Table 'xyz' is marked as crashed and should be repaired
Also, we saw high iowait time (90%) for 1 min in every 3 min cycle.
Has anyone seen this problem before?