HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   General (http://www.howtoforge.com/forums/forumdisplay.php?f=25)
-   -   MySQL Storage Limit (http://www.howtoforge.com/forums/showthread.php?t=59747)

todx 30th November 2012 07:06

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?

till 30th November 2012 08:56

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.

Croydon 30th November 2012 09:39

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

cfoe 30th November 2012 13:12

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.

till 30th November 2012 14:56

We are working on such a function already, please see ispconfig roadmap.


All times are GMT +2. The time now is 14:32.

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