July 14, 2015

Disk Space for MySQL Databases in cPanel Show as 0MB

When you upgrade from cPanel 11.24 to 11.25, your users may notice that in cPanel, their MySQL databases show 0MB of disk space used, when they know their databases are much larger. This is due to an option in cPanel that you specifically have to enable. To enable MySQL disk usage tracking:
1) Edit /var/cpanel/cpanel.config
Change:
disk_usage_include_sqldbs=0
to
disk_usage_include_sqldbs=1
Then run the following:
/scripts/update_db_cache
This may take a few minutes if you have a ton of users with databases, but after this, you should see the database disk usage show up accurately in cPanel.

Related Posts:

  • 5 Ways to Get a User’s Disk Usage This may seem pretty simple, but I see a lot of questions about how to get a user’s disk space usage on a cPanel user. I put together a quick list of 5 simple ways for the average admin:  1) Good ole’ cPanel/WHM. You c… Read More
  • How to Clean Log Files Before You Enable Log Rotation Checking disk space usage and removing old log files cPanel & WHM create and maintain log files. These log files allow you to examine errors and other occurrences on the system. After an extended period of time, the sy… Read More
  • 11 Ways to Free Up Disk Space on a cPanel Server I’m sure that most of you have been to the point where one or more of your servers start to fill up as you get more customers. The server’s performing just fine, but there’s one problem…you’re out of disk space! Here are a f… Read More
  • How to Delete all logs in a cpanel server - SSH The command below will delete/empty all files in '/path/to/the/logdirectory' directory.for i in $(find /path/to/the/logdirectory -type f); do echo > $i; done You can empty the logs files via SSH as user root using the… Read More
  • Disk Space for MySQL Databases in cPanel Show as 0MB When you upgrade from cPanel 11.24 to 11.25, your users may notice that in cPanel, their MySQL databases show 0MB of disk space used, when they know their databases are much larger. This is due to an option in cPanel that yo… Read More

0 comments:

Post a Comment