What are the differences between MariaDB 5.1 (aka MySQL-5.1-Maria) release and the normal MySQL-5.1 release?
• Maria is compiled in by default and required to be ‘in use’ when mysqld is started. • Internal on-disk tables are in Maria table format instead of MyISAM table format. This should speed up some GROUP BY and DISTINCT queries because Maria has better caching than MyISAM. New options to CREATE TABLE: • TRANSACTIONAL= 0 | 1 ; Transactional means crash-safe for Maria <> • PAGE_CHECKSUM= 0 | 1 ; If index and data should use page checksums for extra safety. • TABLE_CHECKSUM= 0 | 1 ; Same as CHECKSUM in MySQL 5.1 • ROW_FORMAT=PAGE ; The new cacheable row format for Maria tables. Default row format for Maria tables and only row format that can be used if TRANSACTIONAL=1. To emulate MyISAM, use ROW_FORMAT=FIXED or ROW_FORMAT=DYNAMIC • CHECKSUM TABLE now ignores values in NULL fields. This makes CHECKSUM TABLE faster and fixes some cases where same table definition could give different checksum values depending on row format. The disadvantage is that the value is now different compared to other
Related Questions
- I understand that the SafeBack license has changed with the release of version 3.0. What are the differences?
- What are the differences between MariaDB 5.1 (aka MySQL-5.1-Maria) release and the normal MySQL-5.1 release?
- What are some of the developmental differences between preterm and normal term infants?