#1  
Old 23rd July 2011, 12:17
Giuseppe Giuseppe is offline
Junior Member
 
Join Date: Jul 2011
Posts: 21
Thanks: 0
Thanked 1 Time in 1 Post
Default database quota

Hi,
i need to know how database quota is calculated.
I have ispconfig 3.0.3.3 on i386 debian 6.
Thank you.

Giuseppe
Reply With Quote
Sponsored Links
  #2  
Old 25th July 2011, 13:39
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,421
Thanks: 812
Thanked 5,205 Times in 4,081 Posts
Default

There is no database quota available in ispconfig 3 yet, as mysql does not has quota support for databases.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 25th July 2011, 13:43
Giuseppe Giuseppe is offline
Junior Member
 
Join Date: Jul 2011
Posts: 21
Thanks: 0
Thanked 1 Time in 1 Post
Default database quote

Hi,
so the database can have illimited size space?
or it use the web site space?
Thank you.
Reply With Quote
  #4  
Old 25th July 2011, 14:27
erosbk erosbk is offline
Senior Member
 
Join Date: Mar 2011
Posts: 337
Thanks: 49
Thanked 36 Times in 30 Posts
Default

If databases were saved in a specific path per each user, could be possible to check for size of every file in each user folder.

Maybe a cron could check with a db_quota table, and, if size >= db_quota, remove INSERT / UPDATE permissions for users. If size < db_quota, then grant permissions back.

Could this approach work? is not the best but, I think that this could help a lot.
Reply With Quote
  #5  
Old 25th July 2011, 22:15
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,421
Thanks: 812
Thanked 5,205 Times in 4,081 Posts
 
Default

Mysql stores all databases in it main database path and if innodb is used, even all databases are in the same file. So the only way to get the size is to query mysql for the table sizes and then build some kind of quota function around that.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Horde Groupware Webmail Edition ByteMe Networking Tips/Tricks/Mods 17 20th December 2012 10:12
Cron issue in Debian 6 Nolan Installation/Configuration 6 18th April 2011 16:36
Amavis/ClamAv problem MattJo. General 7 20th October 2010 17:18
Problems with SpamSnake ClamAV (Sanesecurity Signatures) tmaleshafske HOWTO-Related Questions 0 21st September 2010 01:59
chgrp error new user DKA General 15 28th July 2008 17:45


All times are GMT +2. The time now is 02:12.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.