@apinto: Thank you for the support. No, my CPU is usually sitting around 2-5% with spikes to around 20% every few seconds during busy times of the sites I guess. Regarding cpanel, I was referring to their auto check feature which would relaunch mysql if it failed or monitored that at least. It seems Sentora has no such checking feature.
And thanks for the two links. I am giving uptime robot a look right now. I have been using pingdom's free service but it only lets me add one website, but actually it's all I really need as all my sites are on this single server. But I will create an account with uptime robot to see if it's better than Pingdom. Also, thanks for the link regarding the memory pool issue. I will give that a look too!
@Me.B - Thanks for your response. The htop output pasted above shows I am on a 1GB ram virtual server...memory sits around 500-620 constantly with 400-500 MB of free ram. So I don't think it's that. I never see the ram go above the 620 MB mark, or really fluctuate for that matter. So i don't think that's it. I do see the CPU spike to 100% on occasion. I'll have to give that workbench a look if I can't figure things out here soon.
And yep, I am trying to find the cause. I actually created a script to check if mysql is up every 10 minutes (via cron) and if not, bring it back up and email me a notice as well as document the time of failure and send me details from the system log during that time.
@tgates: thanks for your support. Can you elaborate on this one...Also, 'truncate' once a week/month the x_logs database table. This table gets large very fast. Where is this database table? Or how can I truncate it?
And thanks for the two links. I am giving uptime robot a look right now. I have been using pingdom's free service but it only lets me add one website, but actually it's all I really need as all my sites are on this single server. But I will create an account with uptime robot to see if it's better than Pingdom. Also, thanks for the link regarding the memory pool issue. I will give that a look too!
@Me.B - Thanks for your response. The htop output pasted above shows I am on a 1GB ram virtual server...memory sits around 500-620 constantly with 400-500 MB of free ram. So I don't think it's that. I never see the ram go above the 620 MB mark, or really fluctuate for that matter. So i don't think that's it. I do see the CPU spike to 100% on occasion. I'll have to give that workbench a look if I can't figure things out here soon.
And yep, I am trying to find the cause. I actually created a script to check if mysql is up every 10 minutes (via cron) and if not, bring it back up and email me a notice as well as document the time of failure and send me details from the system log during that time.
@tgates: thanks for your support. Can you elaborate on this one...Also, 'truncate' once a week/month the x_logs database table. This table gets large very fast. Where is this database table? Or how can I truncate it?