HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (
-   General (
-   -   MySQL Storage Limit (

todx 30th November 2012 08: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 09: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 10:39

Maybe you could use this - although it is not integrated into ISPConfig it might fit your needs. Maybe.

cfoe 30th November 2012 14: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 15:56

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

All times are GMT +2. The time now is 11:23.

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