add MySQL Disk Space in user quota space

[activa]

hello all

i want to make the MySQL Disk Space part of the user quota , for example if the disk space used is 100 mb and the mysql disk space is 200 mb and the package assigned to the use is 250 mb , it must show a over quota of this user .

to vote for this feature please go to

http://bugzilla.cpanel.net/show_bug.cgi?id=6119

thanks in advance

[SoftDux]

It should be doing that by default, MySQL & Email space is part of the account

[LoNgLY]

Yes. My friend its defaults cpanel.

[yapluka]

It should be doing that by default, MySQL & Email space is part of the account

Actually, it is not. Emails are part of the account but mysql is not. Mysql files are not owned by the user but by mysql...

Just an example :

Disk usage 103.02 / 500.00 MB
MySQL Disk usage 495.50 MB
Disk space available 396.98 MB

[activa]

Actually, it is not. Emails are part of the account but mysql is not. Mysql files are not owned by the user but by mysql...

Just an example :

Disk usage 103.02 / 500.00 MB
MySQL Disk usage 495.50 MB
Disk space available 396.98 MB

you're right .

how to get the mysql espace part of the user acccount ?

[yapluka]

The problem is that the mysql files are not owned by the username. There is not much that we can do from our side and your best option would be to contact directly cPanel support and/or add it to bugzilla.cpanel.net.

This would be a nice improvement

[cpanelkenneth]

The problem is that the mysql files are not owned by the username. There is not much that we can do from our side and your best option would be to contact directly cPanel support and/or add it to bugzilla.cpanel.net.

This would be a nice improvement

MySQL itself does not support filesystem quotas. There are various ways to coax (read: force) the system to use filesystem quotas with MySQL databases, but none work very well, and there are trivial ways to bypass the quotas with a default MySQL configuration.

[yapluka]

MySQL itself does not support filesystem quotas. There are various ways to coax (read: force) the system to use filesystem quotas with MySQL databases, but none work very well, and there are trivial ways to bypass the quotas with a default MySQL configuration.

So what ? Does this mean that the mysql space will never count under the user quota, even with cPanel 11 ?

[yapluka]

That's cool news ! Thank you Kenneth !

[cpanelkenneth]

Does this mean that the mysql space will never count under the user quota, even with cPanel 11 ?

NO. They will count toward quota

[jaizkris]

Hello friends,

The space used by mysql of an account will come under the quta of that account.

But we cant fix a particular quta to mysql.

The cpanel setting is llike that . mysql can use any amount of space available from an account.

[chirpy]

Well, you can use /scripts/updatemysqlquota which will then charge the space to the quota as it simply chowns the mysql table files. However, there are some major problems in doing this:

1. If any cPanel accounts runs out of quota, MySQL will break

2. You have to run the script on a regular basis as it will need to chown newly created MySQL databases/tables

[cpanelkenneth]

I think he means having a separate quota for databases, much as there are for email accounts. This *might* be possible with some of the methods we're investigating for database quota enforcement.

[activa]

I think he means having a separate quota for databases, much as there are for email accounts. This *might* be possible with some of the methods we're investigating for database quota enforcement.

yes, that is the idea .

account espace = email quota + mysql quota + espace quota .

exaple 1 :

account espace : 500 mg ;
email quota : 10 mg ;
mysql quota : 120 mg ;

Disk space available = (500 -10 - 120) = 370 mg .

exaple 2 :

account espace : 500 mg ;
email quota : 10 mg ;
mysql quota : 520 mg ;

Disk space available = (500 -10 - 520) = -30 mg . (quota exceced ).

[redham]

Why would you want to divide the quota up like that anyway? /just curious.