Jump to content
bluehash

Server help needed

Recommended Posts

Hi All,

Anyone here is a good server admin?

 

I may need a few hours of your time. Every two days or so, sql crashes. The server logs say out of memory. I just want to make sure if that is the issue before buying more memory.

 

OS is CentOs on linode.

 

Email me at gerry.box  on gm 

 

Thank you.

Share this post


Link to post
Share on other sites

Just a thought; maybe some other service is slowly eating memory and your SQL service is too nice in freeing memory back to the system. For example, some CGI binary may leak memory and thus slowly eat memory away that cannot be used anymore for executing SQL queries...

Share this post


Link to post
Share on other sites

Nagios is indeed a good suggestion. "out of memory" could mean a memory leak (as also suggested by roadrunner84), make sure you have at least the latest supported version of each software. I'm not sure if it's normal to buy more memory just because you get this error once a week or so, because it looks more like a bug/memleak. A forum/DB may run slower with less memory but a they shouldn't stop running altogether.

Share this post


Link to post
Share on other sites

×