From: Tim Gustafson
Date: May 21 2010 1:09am
Subject: Re: Database Quotas
List-Archive: http://lists.mysql.com/mysql/221630
Message-Id: <940729808.88801274404182689.JavaMail.root@mail-01.cse.ucsc.edu>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

> 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.

Yes, but mySQL could return a more friendly "you're out of space" message and not corrupt the data files if a given statement would cause the database to exceed its quota (and it could do so in a way that doesn't corrupt the database files)

Or it could work the opposite way: check the current usage against the quota before executing a statement, and if the database is already over quota, don't even attempt it.

Tim Gustafson
Baskin School of Engineering
UC Santa Cruz
tjg@stripped
831-459-5354