MySQL database usage in cPanel
Are all of the databases in your cPanel accounts showing 0 ? Its an easy fix by following
the steps below:
In Tweak settings in the WHM find this option under SQL:
Calculate the disk usage of account MySQL and PostgreSQL databases.
Once you enable the option go ahead and save; the WHM should report:
Tweak Settings
Your changes have been saved.
Restarting cPanel daemons ... Done
Updating your system to reflect any changes ...
Updating "disk_usage_include_sqldbs" from "0" to "1".
"disk_usage_include_sqldbs" was updated.
Done.
Alternatively you could do this from the command line such as the following:
[~]vi /var/cpanel/cpanel.config
Search for the line “disk_usage_include_sqldbs” and enable by changing the 0 to a 1.
From
disk_usage_include_sqldbs=0
to
disk_usage_include_sqldbs=1
To run a check you can run the following script as root from the terminal:
/scripts/update_db_cache