MySQL Disk Usage

[sparek-3]

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]

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:

mysql-db-count
mysql-db-usage
mysql-disk-usage

Then, run the following command:

/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.