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!

Dangerous behaviour of mysqldump when encoutring a crashed table

Discussion in 'Database Discussion' started by abdelhost77, Mar 28, 2013.

  1. abdelhost77

    abdelhost77 Well-Known Member

    Joined:
    Apr 25, 2012
    Messages:
    105
    Likes Received:
    2
    Trophy Points:
    68
    cPanel Access Level:
    Root Administrator
    Hello ,

    yesterday when runing daily backup through ( cpRemote ) we receive mail that /home partition is 100% full !! And CPU usage very high .

    after checking we found that mysqldump was hanging and try to dump a crashed table , and keep hanging and eating CPU with no timeouts , and we receive Cpanel alert mail that /home is full to 80% and then 100% !!! may be a dump temporary file was growing and growing indefinetly ..

    the issue was solved after REBOOTING the server .

    and The /home usage return to normal , ( temporary file has beeen deleted during reboot ? )

    Please Cpanel STAFF , try checking and testing mysqldump when there is a crashed table ,most of backups are runing during nights , and if pb occur may be it will be discovered late ( not good for disks ) ,and it could be real nightmare .

    PS : sorry fr my poor english :)
     
    #1 abdelhost77, Mar 28, 2013
    Last edited: Mar 28, 2013
Loading...

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.
    Dismiss Notice