Mit den vorweggegriffenen Performance-Boosts aus Version 5.5 wird MariaDB 5.3 für Windows-Anwender erheblich schneller sein als noch Version 5.2 oder 5.1. Daher empfehlen die Verantwortlichen ausdrücklich das Update auf das jüngste, allgemein verfügbare (GA) Release. Die Verbesserungen sind wie folgt angegeben:
MariaDB 5.3 Enhancements:
- Subquery optimizations
- Semi-join subquery optimizations
- Non-semi-join optimizations
- Subquery Cache
- Subquery Optimizations Map
- Optimizations for derived tables and views
- Disk access optimization
- Join optimizations
- Index Merge improvements
- Optimizer control
- NoSQL-style interfaces
- Group commit for the binary log
- Replication and binary logging enhancements
- Microsecond support for NOW() and timestamp, time, and datetime columns
- Windows performance improvements
- And a number of other general improvements
MariaDB 5.3 Windows-Specific Performance improvements include:
- Backported Windows performance patches from MySQL 5.5
- Asynchronous IO in XtraDB is redesigned and is now faster, due to the use of IO completion ports
- Additional durability option for XtraDB : innodb_flush_method can now be O_DSYNC, like on Unixes. (The effect of using this option is that the log file is opened with FILE_FLAG_WRITETHROUGH, and FlushFileBuffers() is not done. This may improve speed in write-heavy scenarios.)
- A new Windows MSI installer
- Includes a GUI-tool, HeidiSQL
MariaDB 5.3 steht auf Askmonty.org zum Download bereit. Als Betriebssystem werden Windows, Solaris, Linux, CentOS und RHEL unterstützt und es gibt stets 64-Bit-Builds.
