MySQL Forums
Forum List  »  MyISAM

Re: Issue with tables getting crashed
Posted by: Rick James
Date: June 25, 2013 09:58PM

> 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.

Options: ReplyQuote

Written By
Re: Issue with tables getting crashed
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.