sparek-3

Well-Known Member
Aug 10, 2002
2,183
285
388
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,270
463
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.