Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Daily Backups Schedule Time / MYSQL Overload

Discussion in 'Data Protection' started by Doug E, Sep 5, 2006.

  1. Doug E

    Doug E Well-Known Member

    Joined:
    Aug 17, 2005
    Messages:
    58
    Likes Received:
    0
    Trophy Points:
    156
    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?


    EDIT - Here is a look at it when its running fine...
    and another look, load seems better...

    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?

     
    #1 Doug E, Sep 5, 2006
    Last edited: Sep 5, 2006
  2. MMarko

    MMarko Well-Known Member

    Joined:
    Apr 18, 2005
    Messages:
    316
    Likes Received:
    0
    Trophy Points:
    166
    Your server has serious problems and find somebody to take a look and setup it properly.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 MMarko, Sep 5, 2006
  3. rapidfire911

    rapidfire911 Active Member

    Joined:
    Jul 5, 2005
    Messages:
    42
    Likes Received:
    0
    Trophy Points:
    156
    Average load on a server is between 0 and 2. The load on your server is 576.89, 531.96 (10 minute avg), 395.87(15 min avg) That is ridiculous. IS this your server of you have this through a hosting company?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 rapidfire911, Sep 5, 2006
  4. Messiah

    Messiah Member
    PartnerNOC

    Joined:
    Jul 5, 2006
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    151
    1) Login to your server via ssh as root and run 'crontab -e'. Look for /scripts/cpbackup. It's probably scheduled for 1:00am (0 1 * * *). cPanel will reset this cron entry when it runs upcp, so you might want to change the timezone of your server instead, so that 1:00am coincides with the time you want backups to run.

    2) The larger your sites, the longer backups will take. Also daily, weekly, and monthly backups run separately, so backups will last longer when a weekly and/or monthly is taken in addition to the daily.

    3) Looks like your server has the infamous iowait problem in recent kernels (74.7% wa). You'll want to make sure you're booted to the latest available kernel. The iowait issue causes a high load when accessing the disk, such as with backups and mysql. I'd bet my sister that you're running an old kernel.

    4) Stats are compiled against the domlogs in /usr/local/apache/domlogs/. The stats records are stored in /home/USERNAME/tmp/.

    5) Investigate the contents of /backup/cpbackup/. This may be a different path, depending on your "Backup Destination" in WHM under "Configure Backup".

    6) Assuming there's nothing inherently wrong with your mysql install, you should be able to start/stop/restart mysql as you please. You can kill it as well. The worst this will do is corrupt your databases, which isn't a huge deal 'cause they can always be repaired.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 Messiah, Sep 5, 2006
(You must log in or sign up to post here.)
Loading...
Similar Threads - Daily Backups Schedule
  1. jimhermann

    Why are Weekly and Monthly backups smaller than Daily Backups?

    jimhermann, Nov 4, 2017, in forum: Data Protection
    Replies:
    3
    Views:
    282
    cPanelMichael
    Nov 7, 2017
  2. elkram

    SOLVED [CPANEL-22053] WHM >> Daily Process Log is excluding common processes

    elkram, Aug 4, 2018, in forum: General Discussion
    Replies:
    2
    Views:
    106
    cPanelMichael
    Aug 6, 2018
  3. rangka_kacang

    SOLVED Anacron job 'cron.daily' on <snipped>

    rangka_kacang, Jul 6, 2018, in forum: General Discussion
    Replies:
    2
    Views:
    93
    rangka_kacang
    Jul 6, 2018
  4. Sunlander

    MySQL Error in WHM Service Status Daily Process Log

    Sunlander, Jun 28, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    126
    cPanelMichael
    Jun 29, 2018
  5. postcd

    SOLVED Anacron job 'cron.daily' on host.name.tld

    postcd, May 29, 2018, in forum: General Discussion
    Replies:
    2
    Views:
    87
    cPanelMichael
    May 29, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice