Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 2

Displaying posts with tag: file system (reset)

Limiting table disk quota in MySQL
+1 Vote Up -0Vote Down

Question asked by a student: is there a way to limit a table’s quote on disk? Say, limit a table to 2GB, after which it will refuse to grow? Note that the requirement is that rows are never DELETEd. The table must simply refuse to be updated once it reaches a certain size.

There is no built-in way to limit a table’s quota on disk. First thing to observe is that MySQL has nothing to do with this. It is entirely up to the storage engine to provide with such functionality. The storage engine is the one to handle data storage: how table and keys are stored on disk. Just consider the difference between MyISAM’s .MYD & .MYI to InnoDB’s shared tablespace ibdata1 to InnoDB’s file-per table .ibd files.

The only engine I know of that has a quota is the MEMORY engine: it

  [Read more...]
Sun still radiating open source
+0 Vote Up -0Vote Down

Sun Microsystems always seems to be forced to defend itself, whether it is the company’s ongoing strategy amid dimmed revenue and earnings or its participation in open source. As one who recently considered the fate of a somewhat weakened Sun, I’d also like to highlight a recent series of promising technologies and efforts — dominated by open source — from the venerable technology giant.

Despite continued doubts, Sun continues to focus its strategy on open source software, which is finding its way into the company’s Solaris OS, storage technology with ZFS file system and MySQL database and elsewhere. The company recently launched a new Web site where it is figuratively letting its open source ponytail down and more

  [Read more...]
Showing entries 1 to 2

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

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.