Tuesday, 3 June 2014

Disk space for MySQL databases is shown as 0MB


Often, when logging into cPanel, databases are shown with zero sizes. To fix this issue, ssh to your server and open cPanel config:

# vi /var/cpanel/cpanel.config

Find and change this variable from 0 to 1:

# disk_usage_include_sqldbs=1

Restart cPanel:

# /etc/init.d/cpanel restart

Now, databases are included in the used disk size calculations and the correct numbers will be shown in cPanel. This directive is disabled by default to decrease server load, as such calculations may consume great amount of CPU.

Also, if there are still any problems with your statistics, try running the script:

# /scripts/update_db_cache

No comments:

Post a Comment