On 11/22/2012 09:14 PM, pw@themail.co.uk wrote:
I think that eXist-db takes the latter approach - the database becomes read-only when the disk is limited in space
BTW: What do relational DBSs do? Seems even MySQL for instance doesn't prevent something like this (well at least it seems the data isn't commited such that the database isn't in an inconsistent state?)?
http://www.nixgurus.com/mysql/how-to-change-mysql-data-directory/
I guess the only thing which really works and is reliable in _all_ cases is a rollback if not enough space is provided. Ok, just found something in a german reference doc -- the default maximum size is 4gb, otherwise if a transaction requires more space a rollback is issued. I guess it is also first checked (perhaps once a transaction is started) if this or another minimum size of space is still available.
kind regards, Johannes