Re: Issue with tables getting crashed
> 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.
Subject
Views
Written By
Posted
3511
June 23, 2013 01:28PM
1841
June 23, 2013 09:50PM
1756
June 24, 2013 07:38PM
1851
June 24, 2013 07:51PM
1810
June 25, 2013 09:37AM
Re: Issue with tables getting crashed
1815
June 25, 2013 09:58PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.