Showing entries 1 to 2
Displaying posts with tag: file system (reset)
Limiting table disk quota in MySQL

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 accepts the max_heap_table_size, which limits the size of a single table …

[Read more]
Sun still radiating open source

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 succinctly staking out its place and …

[Read more]
Showing entries 1 to 2