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
Next revision Both sides next revision
control-panels:cpanel-whm:mysql-database-size-showing-000mb [2018/05/08 15:01]
cmiller
control-panels:cpanel-whm:mysql-database-size-showing-000mb [2019/10/10 15:23]
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&800|}}
   - 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.txt · Last modified: 2020/06/02 11:57 by Karson N.