KNOWNHOST WIKI

User Tools

Site Tools


control-panels:cpanel-whm:mysql-database-size-showing-000mb

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
control-panels:cpanel-whm:mysql-database-size-showing-000mb [2018/05/08 20:01]
cmiller
control-panels:cpanel-whm:mysql-database-size-showing-000mb [2019/10/10 20:23] (current)
Karson N.
Line 10: Line 10:
 Using WHM is definitely the easiest of the two methods for the novice user. Using WHM is definitely the easiest of the two methods for the novice user.
   - Once logged into WHM, proceed to the Tweak Settings link in the top of the navigation bar on the left hand side of the screen.   - Once logged into WHM, proceed to the Tweak Settings link in the top of the navigation bar on the left hand side of the screen.
-    * {{:​control-panels:​cpanel-whm:​tweaksettings2018whm.png?​direct&400|}}+    * {{:​control-panels:​cpanel-whm:​tweaksettings2018whm.png?​nolink&500|}}
   - Once on this page, type "​include database"​ into the search box in the top right hand corner of the page. This will bring you to the option to enable/​disable database usage in disk calculations. ​   - Once on this page, type "​include database"​ into the search box in the top right hand corner of the page. This will bring you to the option to enable/​disable database usage in disk calculations. ​
-    * {{:​control-panels:​cpanel-whm:​includedatabasesdiskspace.png?​direct&400|}}+    * {{:​control-panels:​cpanel-whm:​includedatabasesdiskspace.png?​nolink&800|}}
   - Select the option you desire, and click "​Save"​.   - Select the option you desire, and click "​Save"​.
   - Your change has now taken effect and the next time quotas are run on your system, database sizes will be calculated.   - Your change has now taken effect and the next time quotas are run on your system, database sizes will be calculated.
Line 21: Line 21:
   - Using your preferred command-line text editor, modify the ''/​var/​cpanel/​cpanel.config''​ file. For this tutorial I'll be using ''​vi''​.   - Using your preferred command-line text editor, modify the ''/​var/​cpanel/​cpanel.config''​ file. For this tutorial I'll be using ''​vi''​.
   - Locate the line starting with ''​disk_usage_include_sqldbs''​.   - Locate the line starting with ''​disk_usage_include_sqldbs''​.
-    * {{:​control-panels:​cpanel-whm:​cpanel-config-file-mysql-size.png?​direct&300|}}+    * {{:​control-panels:​cpanel-whm:​cpanel-config-file-mysql-size.png?​nolink&1500|}}
   - Change this value as you desire to achieve the needed result. A value of "​1"​ will enable the disk usage calculation for databases. A value of "​0"​ will disable the disk usage calculation for databases.   - Change this value as you desire to achieve the needed result. A value of "​1"​ will enable the disk usage calculation for databases. A value of "​0"​ will disable the disk usage calculation for databases.
   - After you've made your modification,​ save the file and exit the text editor. We now need to run a command to put the change into effect.   - After you've made your modification,​ save the file and exit the text editor. We now need to run a command to put the change into effect.
   - Run the command ''/​scripts/​update_db_cache''​ if you'd like to force a database size calculation immediately - otherwise it will be calculated with the system quotas at their next run.   - Run the command ''/​scripts/​update_db_cache''​ if you'd like to force a database size calculation immediately - otherwise it will be calculated with the system quotas at their next run.
   - We also need to run ''/​usr/​local/​cpanel/​whostmgr/​bin/​whostmgr2 --updatetweaksettings''​ to enact the new setting change we made.   - We also need to run ''/​usr/​local/​cpanel/​whostmgr/​bin/​whostmgr2 --updatetweaksettings''​ to enact the new setting change we made.
-    * {{:​control-panels:​cpanel-whm:​cpanel-disk-usage-include-mysql.png?​direct&300|}}+    * {{:​control-panels:​cpanel-whm:​cpanel-disk-usage-include-mysql.png?​nolink&800|}}
   - That's it, we're done.   - That's it, we're done.
control-panels/cpanel-whm/mysql-database-size-showing-000mb.1525809666.txt.gz · Last modified: 2018/05/08 20:01 by cmiller