2.3K

Sometimes administrators may notice that MySQL databases display 0MB disk usage in cPanel even though the databases contain data. This usually happens due to incorrect disk usage calculation settings in the cPanel configuration.

This issue can be easily resolved by updating the cPanel configuration and rebuilding the database cache.

Why Does MySQL Show 0MB Disk Usage?

cPanel calculates account disk usage based on specific configuration parameters.
If MySQL database disk usage tracking is disabled, cPanel will not include database size in the disk usage report, resulting in databases appearing as 0MB.

Steps to Fix the Issue

Follow the steps below to correct the database disk usage display:

1. Edit the cPanel Configuration File

Access your server via SSH and open the configuration file:

vi /var/cpanel/cpanel.config

2. Locate the Required Parameter

Search for the following entry:

disk_usage_include_sqldbs

3. Update the Value

Change the value from:

0

to:

1

This enables MySQL database disk usage calculation.

4. Update the Database Cache

Run the following command to rebuild the database usage cache:

/scripts/update_db_cache

Final Result

Once the cache update completes, cPanel will recalculate disk usage, and MySQL databases will correctly display their actual storage size instead of 0MB.

If you require help, contact SupportPRO Server Admin