Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 30th November 2012, 07:06
todx todx is offline
Member
 
Join Date: Apr 2012
Posts: 77
Thanks: 33
Thanked 6 Times in 5 Posts
Default MySQL Storage Limit

Does ISPC3 offer a way to limit the size of MySQL databases or does every database have unlimited ammount of space it can use?
Reply With Quote
Sponsored Links
  #2  
Old 30th November 2012, 08:56
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,717
Thanks: 820
Thanked 5,322 Times in 4,175 Posts
Default

There are no mysql quota limits as mysql does not offer to limit the site of a database and linux filesystem quote does not work for this purpose as well as all databases use the same linux user "mysql", so you would be able to limit only the size of all mysql databases but not a specific mysql database.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
todx (30th November 2012)
  #3  
Old 30th November 2012, 09:39
Croydon Croydon is offline
ISPConfig Developer
 
Join Date: Jul 2007
Location: Koblenz, Germany
Posts: 922
Thanks: 16
Thanked 259 Times in 206 Posts
Default

Maybe you could use this - although it is not integrated into ISPConfig it might fit your needs. Maybe.
http://lrem.net/software/mysql-quota-daemon.xhtml
__________________
Marius Cramer

pixcept KG
Reply With Quote
The Following User Says Thank You to Croydon For This Useful Post:
todx (30th November 2012)
  #4  
Old 30th November 2012, 13:12
cfoe cfoe is offline
ISPConfig Developer
 
Join Date: Oct 2011
Location: NRW, Germany
Posts: 233
Thanks: 27
Thanked 57 Times in 32 Posts
Send a message via Skype™ to cfoe
Default

Wouldnt it be possible to add some kind of soft-limit?
It might not be possible to limit the size of dbs but the size can be calculated.
This value could be compared to the "limit" for the user. If the size is greater than the limit new dbs could be denied.
A notification could be added as soon as notifications are implemented into ISPConfig.
__________________
Christian Foellmann

OpenSource-Projects - GitHub-Projects - SVN-Mirrors on GitHub - Foe Services
Reply With Quote
  #5  
Old 30th November 2012, 14:56
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,717
Thanks: 820
Thanked 5,322 Times in 4,175 Posts
 
Default

We are working on such a function already, please see ispconfig roadmap.
__________________
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
ISPConfig 3 system installation script Mark_NL Tips/Tricks/Mods 12 7th March 2014 06:30
mysql and mail problem viritech General 3 16th October 2012 12:54
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 13:58
Attacks on MTA dclardy Installation/Configuration 4 29th September 2009 16:50
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11


All times are GMT +2. The time now is 20:27.


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