[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [cobalt-users] MYSQL server gone down overnight - newbie requires help

Hi Marcus,


I arrived at work this morning to find some of our web pages not working,
after checking that there was not a problem with the php scripts I soon
determined that there was a problem with the mysql database.


Did you check via shell access? ("ps ax |grep mysql")


We have been receiving error messages for the last few days stating that the
cobalt box is low on memory at about 5.30 in the morning when some backup
scripts are run, I have checked the messages this morning and they appear to
be somewhat worse.
How much memory is in this machine? IMHO, anything below 128Mb is potential suicide for the box. 


Snippets as follows:

The SMTP (mail) server appears to be down.  The mail server may shut itself
down temporarily under extreme load, so you should also check the CPU load
on the server. - MAIL IS OK NOW!


Not good. Could be anything: low on memory, high CPU load, filelimit reached...


subject of other messages:
RE: THE COBALT SERVER IS LOW ON MEMORY


Bad.


RE: THE COBALT SERVER IS VERY LOW ON MEMORY
Even worse. Put more memory in this box, is my advice. You can't have enough RAM. 


RE: THE CPU IS HEAVILY LOADED


Hmmm... again: anything could cause this.
Do you have many sites on this box? Many users? Many database driven stuff? Users using a lot of CGI? 

Perhaps it could be advisable to get another box and try to balance the load.


Apologies for the long message, but I am fairly new to all of this and my
boss is not in this morning so i am slightly panicking!


I hope you don't mind me snipping...

Good luck... Nico