What are the design goals in Maria?
• Multi-Version Concurrency Control (MVCC) and ACID storage engine. • Optionally non-transactional tables that should be ‘as fast and as compact’ as MyISAM tables. • Be able to use Maria for internal temporary tables in MySQL (instead of MyISAM). • All indexes should have equal speed (clustered index is not on our current road map). • Allow ‘any’ length transactions to work (Having long running transactions will cause more log space to be used). • Allow log shipping; Ie, you can do incremental backups of Maria tables just by copying the Maria logs. • Allow copying of Maria tables between different Maria servers (under some well-defined constraints). • Better blob handling (than is currently offered in MyISAM, at a minimum). • No memory copying or extra memory used for blobs on insert/update. • Blobs allocated in big sequential blocks – Less fragmentation over time. • Blobs are stored so that Maria can easily be extended to have access to any part of a blob with a single fetch in the fu
