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!

MySQL excess size

Discussion in 'Database Discussion' started by psytanium, Oct 28, 2016.

Tags:
  1. psytanium

    psytanium Well-Known Member

    Joined:
    Jun 6, 2014
    Messages:
    103
    Likes Received:
    1
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Hello,

    I was checking the Disk Usage of 1 of my accounts on cPanel, I found 2 weird things
    1. the mysql size is 185.68 MB while it should be around 24 MB
    2. What is Files in hidden sub directories ?
    Image attached. Thanks :)
     

    Attached Files:

  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,803
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    Hidden subdirectories are directories within your account's home directory and below with a leading period in the name (e.g. /home/$username/public_html/.12345).

    Could you let us know what steps you are using to verify the MySQL disk space usage? You can check the MySQL disk space usage via a command such as:

    Code:
    du -sh /var/lib/mysql/database_name
    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. psytanium

    psytanium Well-Known Member

    Joined:
    Jun 6, 2014
    Messages:
    103
    Likes Received:
    1
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    From phpmyadmin, and databases. see the attached photo. Thank you.
     

    Attached Files:

  4. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,803
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    Does that size correspond with the output from the "du -sh /var/lib/mysql/database_name" command?

    Thanks.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. psytanium

    psytanium Well-Known Member

    Joined:
    Jun 6, 2014
    Messages:
    103
    Likes Received:
    1
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    14MB
     
  6. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,803
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Could you open a support ticket using the link in my signature so we can take a closer look? You can post the ticket number here so we can update this thread with the outcome.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. psytanium

    psytanium Well-Known Member

    Joined:
    Jun 6, 2014
    Messages:
    103
    Likes Received:
    1
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    I logged in to cPanel and find everything is normal, it was temporary. thanks anyway :)
     
  8. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,803
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    I'm happy to see the issue is now resolved. Note that MySQL disk space usage is updated via the following root cron job:

    Code:
    30 */4 * * * /usr/bin/test -x /usr/local/cpanel/scripts/update_db_cache && /usr/local/cpanel/scripts/update_db_cache
    It's likely you were viewing cached MySQL disk space usage and it was updated after this cron job ran.

    Thanks!
     
    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