Disk quota not calculated correctly by Cpanel ( Huge bug they should fix)

webhostuk

Well-Known Member
Sep 11, 2013
151
16
68
UK
cPanel Access Level
Website Owner
Twitter
We are using latest version of WHM cPanel (cPanel & WHM v104.0.4) on one of our servers.
We noticed a strange problem where a user is showing used disk space as 219MB and is allocated a disk 1GB.
We noticed that one of the databases under that particular user is showing disk usage of 11GB.
There is a table which is 9.9GB in size.The strange problem is the account is showing disk usage of 219MB whereas it should
have shown disk usage of 11+ GB considering the fact that mysql disk usage is counted under respective account.
We have also made sure that the option in Tweak settings -> SQL -> Include databases in disk usage calculations is enabled.
We raised a ticket with cPanel support and since last 24 hours we have received all kind of irrelevant answers from then,
none addressing our question as why mysql disk usage did not count against shown disk usage of that account on server.

First irrlevant answer was :"Due to the way quotas work, the files for the database do not count towards the disk space in the
"quota" output since the files are not owned by the user. "It does not make any sense when using cPanel on shared server
environment where we have already enabled their recommended option.
Second reply was they were trying to reproduce the problem by installing new instances of Wordpress and confirming they
did not receive any quota warning.
Again, our primary concern was neglected as "Why cPanel Quota is not calculating mysql
disk usage"
under that respective account. We never mentioned we had any problem with WP installations.
Then someone from their team is asking "Do you know when the account became over quota? ".
Come on man this is a shared hosting environment. We are supposed to keep a check on accounts based on the disk usage shown in WHM cPanel.
Do they expect us to go through each database every day to find if any user is using high mysql disk space?
And the most weird / funny reply we have recently received :"It is difficult to determine why the account exceeded the limit
without knowing when the user went over the limit. From what it looks like right now, the limit was set to a value lower
than the actual usage. The account needs to be lower than the limit prior to setting it if you want it to work correctly.
You may need to get the user to reduce their usage first, and then the quotas should take effect normally."

Lol, now how on earth are we supposed to work this way on shared hosting environment?Not to forget they have hiked their price
recently several hundred times and this is a sloppy support and illogical replies we get from them...Making sure their "Expensive"
software is capable of calculating all kind of disk quota usage, is something their arena..
Not something that we should have to contact customer to reduce his disk space..
Why wont a customer argue if his cPanel is not showing used disk space.. he will always say he is within allowed disk quota limit..

Cpanel needs to seriously think about the basic disk quota problem ..as such problem can cause heavy loss to many companies. ( Are we suppose
to do all this manual work on hundreds of server?)
Not to forget with all the over usage NO warning to us or customer and his site is working with disk quota warning.
 
Last edited by a moderator:

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
11,133
1,755
363
cPanel Access Level
Root Administrator
Hey there! Can you let me know the ticket number you have opened? I'd like to review that.

In general, once the Tweak Settings option is enabled, it should be properly added. We have this information on the Tweak Settings page:

"Using INFORMATION_SCHEMA ensures that disk usage by MySQL tables is included in totals. However, enabling this option may cause a significant drop in performance as MySQL may become unresponsive until data collection is complete. Disabling this option causes the system to query the filesystem directly, potentially excluding disk space used by some database tables. Note: If you use a remote MySQL server, you must turn this setting On in order to calculate MySQL disk usage."