Now one begs to ask the question, what stops someone from creating a massive DB and using tons of disk space? Since mysql db's are not accounted for in allocated disk space for a user, they could actually be using a ton more space then given.

We periodically go to the mysql area and look at the sizes of Databases, if we find any that are way out there in terms of disk space we question the owner.

Regards,
David

Stop hovering to collapse...Click to collapse...Hover to expand...Click to expand...

[quote:c728edbca8][i:c728edbca8]Originally posted by Radio_Head[/i:c728edbca8]on my box cpanel is able to report mysql usage correctly , I can assure it .[/quote:c728edbca8]
Yes, it can report it to the byte, but cannot enforce any limits, that's the problem.

[quote:13def36ce3][i:13def36ce3]Originally posted by Radio_Head[/i:13def36ce3]on my box cpanel is able to report mysql usage correctly , I can assure it .[/quote:13def36ce3]
Yes, it can report it to the byte, but cannot enforce any limits, that's the problem.

# man quota[/quote:13def36ce3]

Yes , it cannot enforce limits , but since on the tag
&amp;cpanel Quota=&amp;showquotaused()&amp;&amp; is included the mysql usage (MB) , if a client goes over I should receive an email advice , I think ...

If in fact it does calculate the total including MySQL, how does it enforce the quota on the MySQL databases for that customer? Since all MySQL data is in a single file in the WHM/CP implementation, I see no possible way of controlling the quota on the DB.

As far as I can tell, if a customer has 125M disk quota, then only those files owned by that customer's UID would be enforced. If the customer has 5 DBs at their disposal, they could easily have all 5 DBs growing in size to multiple gigabytes.