The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Mysqldump command is increasing my Physical Memory

Discussion in 'Database Discussions' 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:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    To clarify, are you saying the memory usage is never released after the database backup completes?

    Thank you.
     
  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:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  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:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    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.
     
Loading...

Share This Page