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!

Mysqldump command is increasing my Physical Memory

Discussion in 'Database Discussion' started by Leonardo Reis, Nov 19, 2014.

  1. Leonardo Reis

    Leonardo Reis Registered

    Joined:
    Nov 19, 2014
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Ribeirão Preto, Brazil
    cPanel Access Level:
    Reseller Owner
    It's no big deal, but every time I run a mysqldump command by a cron job, my Physical Memory increases something around 12MB (which is my database size).

    My cron job command is:
    Code:
    /usr/bin/mysqldump -u USER -pPASS DBNAME > /home/USER/backups/$( date +"\%Y_\%m_\%d_\%H_\%M_\%S" )_BACKUP.sql
    I also tried to use the mysqldump with the "--quick" option, like this:
    Code:
    /usr/bin/mysqldump --quick -u USER -pPASS DBNAME > /home/USER/backups/$( date +"\%Y_\%m_\%d_\%H_\%M_\%S" )_BACKUP.sql
    Both codes didn't work out.

    The main problem is that after a few days, I reach the Physical Memory limit and it never gets down again.

    What can I do to solve this issue?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,367
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    To clarify, are you saying the memory usage is never released after the database backup completes?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Leonardo Reis

    Leonardo Reis Registered

    Joined:
    Nov 19, 2014
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Ribeirão Preto, Brazil
    cPanel Access Level:
    Reseller Owner
    Exactly :(
     
  4. Leonardo Reis

    Leonardo Reis Registered

    Joined:
    Nov 19, 2014
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Ribeirão Preto, Brazil
    cPanel Access Level:
    Reseller Owner
    Wel... maybe "never" is too much, I think that the memory is only released a day after or a little bit mure.. Im not sure yet.
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,367
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Is the "mysqldump" process ending after it finishes? For instance, do you notice it hangs or takes a long time to complete?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. Leonardo Reis

    Leonardo Reis Registered

    Joined:
    Nov 19, 2014
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Ribeirão Preto, Brazil
    cPanel Access Level:
    Reseller Owner
    As I have a reseller account I dont know how to check if the mysqldump process is ending. But looks that it takes just a second to finish the backup procedure.

    After a few week, as I run the backup only 2 times per day, it's not affecting my account resources, so I wont worry about it.

    Thank you anyways.
     
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,367
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    You will need to consult with your web hosting provider if you think there might be an issue with the mysqldump process hanging. It's not something you can really investigate without root access to the system.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
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