On May 20, 2010 08:32:56 pm Noel Butler wrote: > On Thu, 2010-05-20 at 16:27 -0700, Tim Gustafson wrote: > > Hi, > > > > I'm not sure if this is already an open issue or not - a Google search > > resulted in various discussions but I didn't find any open > > support/feature request. > > > > It would be really handy if during the "create database" statement, one > > could specify something like: > > > > CREATE DATABASE foo QUOTA=10G; > > > > to limit the entire database being created to no more than 10GB (in this > > example). > > Yes it would be nice. But the best current way is to assign a user to > the database and use system quotas. > > > limit available space in the mySQL database folders, but I've read > > commentary about how that can corrupt the database if the disk becomes > > full. > > Ummm, you're going to have the same problem either way when the limit is > reached, be it a MySQL quota or system quota, if its full, its full.
Use postgres, you can assign tablespaces to a partition of the size you want. When it gets full, writes are refused. I'm not sure how nicely that is handled ( in terms of error output ) but the advantage is that Pg is ACID compliant, so you won't lose data. Colin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
