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 Disk Usage

Discussion in 'General Discussion' started by sparek-3, Jan 29, 2012.

  1. sparek-3

    sparek-3 Well-Known Member

    Joined:
    Aug 10, 2002
    Messages:
    1,743
    Likes Received:
    110
    Trophy Points:
    343
    cPanel Access Level:
    Root Administrator
    How is MySQL Disk Usage calculated in the user's cPanel?

    I have a cPanel user that has no MySQL databases, but they show a MySQL disk usage. I don't know where cPanel is getting the MySQL Disk Usage in it's calculations.
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

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

    There is an internal case open (# 49515) that deals with the inability of "/usr/local/cpanel/scripts/update_db_cache" to properly clear the datastore for MySQL databases after a user removes all of the databases from an account. This is resolved as of cPanel version 11.32, per the following change log:

    11.32 Change Log

    In the meantime, try removing the following files from the "/var/cpanel/datastore/username/" directory:

    Code:
    mysql-db-count
    mysql-db-usage
    mysql-disk-usage
    Then, run the following command:

    Code:
    /usr/local/cpanel/scripts/update_db_cache
    These steps should only be taken on versions prior to 11.32 when the account has no databases.

    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