Cpanel Database Soft Quotas
The file used to cache the number of databases owned by an account moved from /home/user/.cpanel/datastore/mysql-db-count to /var/cpanel/datastore/user/mysql-db-count. Likewise the PostgreSQL cache file is now /var/cpanel/datastore/user/postgres-db-count.
To keep the cache file current, a cron job executes the following command periodically: /scripts/update_db_cache.
cPanel™ 11.25 provides support for including the disk space consumed by an account’s MySQL and PostgreSQL database in the disk usage for the account. To enable this feature toggle the following Tweak Settings: When displaying disk usage in cPanel/WHM include Postgresql and MySQL® disk usage.
Initial Set Up for Quotas on Cpanel
This is the final stage of the Initial Setup process. You will need to select whether you would like to track disk usage on your server. This is generally a good idea if you plan to lease server space to individual users. However, if you do not plan to host individual accounts on your server, you may not need to enable quotas.
To set up quotas:
Select Use file system quotas.
This is a good idea if you plan to host individual accounts on your server.
To disable quotas:
Select Do not use file system quotas.
This is not a good idea if you plan to host individual accounts on your server.
Once you have finished, click the Finish Setup Wizard button. You will then be taken to the WHM homepage.
How to fix MySQL quotas showing 0MB
If your MySQL databases are all showing 0.00MB usage, you probably don’t have the following checked in Tweak Settings:
Calculate the disk usage of account MySQL and PostgreSQL databases.
For some reason, the default setting is “disabled”, or unchecked.
Enabling quotas for a filesystem in Webmin
If the main page of the module shows User Quotas Active (or *Group Quotas Active*) under the Status column for the filesystem, then quotas have already been enabled. If not, to configure and turn on quotas for an ext2 or ext3 filesystem, follow these steps :
If the filesystem already appears in the list on the main page of the module, quotas have already been configured and you can skip to step 5.
Go to the Disk and Network Filesystems module and click on the filesystem you want to enable quotas on.
Change the Use Quotas? option to either User only, Group only or User and Group depending on which kinds of quota you want to enforce.
Click the Save button.
If an error saying that the filesystem is already in use appears, just click the
Apply to Permanent List button. Quotas can still be enabled without needing to reboot, and will be automatically re-enabled when the system is next rebooted.
Back in the Disk Quotas module, your filesystem should now be visible. Click on the Enable Quotas link to activate quotas now.
Assuming all goes well, after a short delay the browser will return to the list of quotas and the Status column will have changed to User Quotas Active.
more at .. http://doxfer.com/Webmin/
