does mysql database space inluded in webspace

[shann]

Hi,

Does mysql database also count with clinet's Disk space or it
is counted seprately?

thanks
shan

 

[FijianTribe]

Its included. Check the cpanel view, it'll show the customer how much space the database is using.

 

[Mindlash]

Has anyone written a hack for measuring this?

Is this something that is being worked on now, on the dev side?

I have a potential client with 3 MySQL DB's over 150MB each and was currious as to the space and bandwidth quotas (obviously space doesn't count, but does quota?)

Thanks!

cPanel.net Support Ticket Number:

 

[Jeff75]

I also have clients who have MySQL databases over 100 MBs with a lot of space taken up on their account.

Please make it so MySQL databases will be counted in the overall disk space amount.

cPanel.net Support Ticket Number:

 

[rs-freddo]

Just chown the database to the group of the user - then it's counted.
chown mysql.username database -R

cPanel.net Support Ticket Number:

 

[Mindlash]

With this not create an issue with mysql writing to the tables?

If this works, that's great! ... and simple! .. however having this automated would obviously be the next step

cPanel.net Support Ticket Number:

 

[casey]

Originally posted by rs-freddo
Just chown the database to the group of the user - then it's counted.
chown mysql.username database -R

cPanel.net Support Ticket Number:

I think you also have to run
/scripts/updatemysqlquota
every once in a while, too.

cPanel.net Support Ticket Number:

 

[rs-freddo]

Originally posted by Mindlash
With this not create an issue with mysql writing to the tables?

If this works, that's great! ... and simple! .. however having this automated would obviously be the next step

cPanel.net Support Ticket Number:

Since mysql is the owner, it won't affect writing to the tables - you're just changing the group ownership. I have done this on an ensim server and it worked fine - I'm not doing it on cPanel cause i own all the databases.

cPanel.net Support Ticket Number:

 

[Jeff75]

I think these are great suggestions on how to get around it, but I think cPanel should integrate this so it will automatically calculate MySQL into the overall disk space usage. I'm sure this is something that most cPanel users would like to have.

cPanel.net Support Ticket Number:

 

[Juanra]

Originally posted by rs-freddo
Since mysql is the owner, it won't affect writing to the tables - you're just changing the group ownership. I have done this on an ensim server and it worked fine - I'm not doing it on cPanel cause i own all the databases.

Cpanel uses user quotas, not group quotas, so you need to chown them user.mysql and give proper permissions. As mentioned by Casey, /scripts/updatemysqlquota gets it right. You can add it to root's crontab if you wish.

cPanel.net Support Ticket Number: