here is what htop looks like
CPU[||||||||||||||||| 23.7%] Tasks: 48, 29 thr; 2 running
Mem[||||||||||||||||||||||||||||||||||||||||||||||||||||||||623/994MB] Load average: 0.11 0.18 0.22
Swp[ 0/0MB] Uptime: 1 day, 22:10:39
Looks fine right? CPU usage uses sits around 1% and then spikes for a second or less. Memory seems to just sit around 600 MB constantly (I have 5 drupal sites and 1 wordpress site on this server). All sites except one get less than 100 unique views a month. They are just info sites with no traffic.
So why would mysql be crashing around once every few days?
Where can I find in the logs why mysql is crashing? Is there a log file I can check and search for some keyword to find why and when the crash happened? Is there a way to auto alert me from the server when mysql goes down...this would be very helpful for me to monitor things...anyone have a link to a tutorial on how to do this?
CPU[||||||||||||||||| 23.7%] Tasks: 48, 29 thr; 2 running
Mem[||||||||||||||||||||||||||||||||||||||||||||||||||||||||623/994MB] Load average: 0.11 0.18 0.22
Swp[ 0/0MB] Uptime: 1 day, 22:10:39
Looks fine right? CPU usage uses sits around 1% and then spikes for a second or less. Memory seems to just sit around 600 MB constantly (I have 5 drupal sites and 1 wordpress site on this server). All sites except one get less than 100 unique views a month. They are just info sites with no traffic.
So why would mysql be crashing around once every few days?
Where can I find in the logs why mysql is crashing? Is there a log file I can check and search for some keyword to find why and when the crash happened? Is there a way to auto alert me from the server when mysql goes down...this would be very helpful for me to monitor things...anyone have a link to a tutorial on how to do this?
