MySQL Databases Showing as 0MB in Size in cPanel

You may have noticed at times that your databases are shown as 0MB in size when logging in to cPanel. There’s a rather simple fix to this issue, unless your databases are actually empty.

• SSH into your server. Open the cPanel configuration file using this command:

vi /var/cpanel/cpanel.config

• Locate the following variable and modify its value from 0 to 1:

disk_usage_include_sqldbs=1

• Restart cPanel

/etc/init.d/cpanel restart

From this point onwards, disk size calculations will include database sizes and the correct numbers will be reflected in cPanel.

The reason the above directive is disabled by default is to decrease server load due to the potential for such calculations to consume CPU power if you have numerous databases with a lot of tables.

In the event that you still see zero sizes of MySQL databases, run this script:

/scripts/update_db_cache

Doing this will rebuild the cache comprising numbers with database size.