# MySQL crashes system

**URL:** <https://forums.percona.com/t/mysql-crashes-system/994>\
**Category:** Other MySQL® Questions\
**Created:** [November 10, 2008, 1:52pm UTC](https://forums.percona.com/t/mysql-crashes-system/994 "2008-11-10T13:52:51Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mani](https://avatars.discourse-cdn.com/v4/letter/m/b4bc9f/32.png) [@mani](https://forums.percona.com/u/mani)\
**Post date:** [November 10, 2008, 1:52pm UTC](https://forums.percona.com/t/mysql-crashes-system/994/1 "2008-11-10T13:52:51Z")

</div>

Hi,

Environment:

CentOS 3.5 (2.4.21)  
MySQL 5.0.64 Enterprise Server (Commercial)  
2 GB RAM, 1 CPU

System variables:

bulk\_insert\_buffer\_size 8388608  
key\_buffer\_size 268435456  
myisam\_data\_pointer\_size 6  
myisam\_max\_sort\_file\_size 2146435072  
myisam\_sort\_buffer\_size 67108864

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?

Thanks,  
Mani.

---

<div class="post-metadata">

**Author:** ![mwallace](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@mwallace](https://forums.percona.com/u/mwallace)\
**Post date:** [December 14, 2008, 9:50pm UTC](https://forums.percona.com/t/mysql-crashes-system/994/2 "2008-12-14T21:50:29Z")

</div>

I realize this is horrendously late and the problem has probably been solved by now, but:  
We used to see myisam crashes and table corruption under load. A switch to innodb solved that completely. Subsequent performance issues were resolved by flipping transaction commit frequency to per-second rather than per-write. Innodb is faster and far more stable for us than myisam ever was. In 2.5 years, we haven’t had a single outage apart from the time that I accidentally uninstalled the binaries out from under the running server.
