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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL excess size

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

Tags:
  1. psytanium

    psytanium Well-Known Member

    Joined:
    Jun 6, 2014
    Messages:
    88
    Likes Received:
    1
    Trophy Points:
    8
    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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,425
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
  3. psytanium

    psytanium Well-Known Member

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

    Attached Files:

  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,425
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

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

    Thanks.
     
  5. psytanium

    psytanium Well-Known Member

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

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,425
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
  7. psytanium

    psytanium Well-Known Member

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

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,425
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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!
     
Loading...

Share This Page