Archive for the ‘Basic Usage’ Category

MySQL database usage in cPanel

No Comments »

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