how cPanel is calculating quotas with mysql

[httpwwf]

i create 400M
AS I KNOW it include website+mysql.
but i see

Disk usage 200 Megabytes
SQL Disk usage 200 Megabytes
Disk space available 200 Megabytes

it is no include mysql.
how can i make it include mysql

[httpwwf]

wrong?
wrong?
wrong?

[rjwesten]

MySQL databases are owned by root (or whatever use the MySQL daemon is running as).

That's why it's not counted in the user quota.

[I-Web]

is there anyway to fix this??

I mean all of the db are named username_dbname so surely it should be possible????

[cafrale]

I would also like to know if there is a way to include mysql usage on account usage. If there is no way to do it, is cpanel planning on do something like this on a near future ?

[Creazioni]

I would also like to know if there is a way to include mysql usage on account usage. If there is no way to do it, is cpanel planning on do something like this on a near future ?

very very very impostant find a solution

[jeremy_reliable]

Yes this is a problem.. Have a customer that has filled var because his db's are so huge, larger than his entire account is supposed to be.. but since this quota system still suffers this cpanel doesn't do anything about it.

[chirpy]

They have. They've given you the option of running /scripts/updatemysqlquota

[/bin/bash.org]

They have. They've given you the option of running /scripts/updatemysqlquota

Well, searching the forums was worthwhile.

Should we set this up in crontab? If so, how often is reasonable? Daily? Weekly? Just before the billing run?

[chirpy]

Personally, I run it daily to be sure that any new d/b's are chowned appropriately. If you ran it weekly or monthly users might get a nasty shock if they've rapidly filled a new d/b.

[fleksi]

They have. They've given you the option of running /scripts/updatemysqlquota

Just run /scripts/updatemysqlquota, but mysql still not count into quota.
How to put mysql space into quota?

[chirpy]

A couple of possibilities:

1. Did you wait for the disk cache to expire? (15 minutes, IIRC)

2. Do you have quotas enabled on the partition that contains /var

[cPanelBilly]

There is 1 large issue with having the user owning mysql databases. If the user hits disk quota, then mysql fails for the entire server.

This is why we do not have this enabled by default.

[chirpy]

Indeed. It was nicely illustrated in this thread recently:
http://forums.cpanel.net/showthread.php?t=46759

Shame that MySQL haven't considered quota'ing in a shared LAMP environment.

[spaceman]

There is 1 large issue with having the user owning mysql databases. If the user hits disk quota, then mysql fails for the entire server.

This is why we do not have this enabled by default.

Ouch! I've just run /scripts/updatemysqlquota - but now I've read the above, I think I want to 'undo' this. Can I?

Thanks.