Re: Issue with tables getting crashed

[Rick James]

> data gets corrupted/table gets crashed randomly

That rarely happens (in MyISAM) except when mysqld is killed (kill -9 or system crash). So, try to make sure mysqld shuts down gracefully.

> Does key_buffer_size leads to table crash?

No. The key_buffer holds _index_ blocks, not data blocks. So, add up the size of the .MYI files (or look at Index_length in SHOW TABLE STATUS), then make sure key_buffer_size is at least that big, but not more than 50M. (The 50M comes from your machine being so small.)

Apache has a setting, MaxClients. Suggest you set that to something low, like 5 or 10.

> open_files_limit=20000

That is excessive, but suspect it does no harm.

Use some CentOS tool to check for "swapping". Swapping will hurt performance of MySQL. If too much virtual memory is needed, that could cause the server to crash.