> i guess my thinking is more along the lines of implementing
> a lustre interface
I'm sure that I'm vastly over-simplifying this, but I was thinking something along the
lines of:
1. Assemble the data being written, calculate its length
2. Check for any free pages in the database file, and use them if there's enough
3. If there aren't enough free pages, check the file system's available space and make
sure it exceeds the size of the write being performed
4. If there's enough free disk space, write the record. Otherwise, return an error
I'm thinking that this would be implemented at the storage engine level, and probably just
for MyISAM tables.
Just my $0.02. Based on the reply from Johnny Withers, I'm thinking that just using ZFS
file system quotas will work for me, but it does seem that this would be a handy feature
to have built in to mySQL for people who don't have ZFS, or who can't use it for some
reason.
Tim Gustafson
Baskin School of Engineering
UC Santa Cruz
tjg@stripped
831-459-5354

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.