I have some questions if anybody has the time or patience to answer them. Firstly I would like more than anything a good website for noobs on managing their own servers. More specifically I would like to find good websites for noobs on using putty and SSH commands, Cpanel and MYSQL.
If you dont know any good websites but can offer advice on the following I'd appreciate it
1 - Using WHM, how would I go about changing the time of my daily backups? If its not possible through WHM how would I do it with SSH?
2 - Every day at 1:00 am my server craps out. I can load my sites most of the time but anything MYSQL dependant is shot and unusable. During this time when I use top through Putty to monitor the goings on I see pdflush often and then later a lot of rebuild.cgi (I have a few mysql databases on my server). My very ignorant theory is my server can't handle backups and run my mysql processes at the same time. I made it so backups were weekly at one point and didnt have the daily problem I have now. Also, I have always had this nightly problem, but it used to only last 20-30 minutes and now takes 1-2 hours to complete. (log files have grown? would deleting them be a good band-aid fix?)
3 - I have no idea what top is telling me and would love to decipher it. Does anybody know a good website detailing the following?
top - 02:10:35 up 23 days, 23:30, 1 user, load average: 576.89, 531.96, 395.87
Tasks: 2173 total, 1 running, 2161 sleeping, 1 stopped, 10 zombie
Cpu(s): 13.0% us, 12.2% sy, 0.0% ni, 0.0% id, 74.7% wa, 0.2% hi, 0.0% si
Mem: 1034440k total, 907944k used, 126496k free, 9532k buffers
Swap: 1052248k total, 142236k used, 910012k free, 62704k cached
EDIT - Here is a look at it when its running fine...
and another look, load seems better...top - 21:09:29 up 24 days, 18:29, 1 user, load average: 1.47, 2.12, 2.43
Tasks: 131 total, 1 running, 129 sleeping, 0 stopped, 1 zombie
Cpu(s): 2.0% us, 1.4% sy, 0.2% ni, 68.5% id, 27.8% wa, 0.0% hi, 0.0% si
Mem: 1034440k total, 240784k used, 793656k free, 10816k buffers
Swap: 1052248k total, 129888k used, 922360k free, 68864k cached
top - 21:13:42 up 24 days, 18:33, 1 user, load average: 0.70, 1.45, 2.09
Tasks: 138 total, 1 running, 136 sleeping, 0 stopped, 1 zombie
Cpu(s): 2.3% us, 1.5% sy, 0.0% ni, 46.9% id, 49.2% wa, 0.0% hi, 0.0% si
Mem: 1034440k total, 248080k used, 786360k free, 12608k buffers
Swap: 1052248k total, 129888k used, 922360k free, 72116k cached
4 - I have disabled server stats except for 'latest visitors'. How do I delete all the logs on my server of the different cpanel stats programs? I may wish to turn them back on again and dont want them bogging me down when they update or do whatever it is that can kill a server.
5 - How do I check to be sure Cpanel is properly backing up my server? I had switched to weekly backups a while back and one day I deleted a mysql database. Unfortunately as my admin discovered, the last backup was my monthly and was almost 4 weeks old. The weekly backups were not saving properly. I want to ensure this will not happen again.
6 - Are these SSH commands to stop and restart mysql safe to use?
# killall mysqld