MySQL Disk Usage Tracking

132 views
asked May 18, 2012 in Database by Donald (2,780 points)
Hello
I’ve run an update for cPanel 11.24, and now I noticed that MySQL databases are showing up with 0MB of disk space in use, even though the database sizes are much larger. How can I enable MySQL disk usage tracking? Can anyone please help
Thanks and regards

1 Answer

0 like 0 dislike
answered May 18, 2012 by expert (14,380 points)
By making the following change, you will be able to enable this feature and retain your MySQL disk usage tracking.
1.Log into your cPanel server by SSH.
2.You will need to edit /var/cpanel/cpanel.config file with a text editor.
oReplace "disk_usage_include_sqldbs=0" with "dis_usage_include_sqldbs=1"
3.Once you have made the change, you will need to run the following:
o/scripts/update_db_cache
Once the script completes you will be able to see the correct MySQL database sizes again
...