Tim Gustafson wrote:
> 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).
> I've found various other schemes about using ZFS and other disk partitioning systems
> to just 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.
> So, is this a feature that seems useful to other people? It would certainly be
> useful to me.
> Thanks for a great product!
> Tim Gustafson
> Baskin School of Engineering
> UC Santa Cruz
We encourage you to add your comments to the existing feature request:
Also, you can configure the common InnoDB tablespace to have a fixed
maximum size. But that is not for a single table or database but for the
total of all data stored within InnoDB.
While it is similar in concept to what you proposed, it fails to meet
your needs by being global rather than specific.
MySQL Principle Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN