The MariaDB Foundation has released a preview of MariaDB 12.1, which marks the beginning of a new rolling release series. This update features significant performance enhancements, including:
- Delayed Logging for Audit Plugin: This improvement allows for more efficient data handling.
- Parallel Replication for Galera Replicas: This feature enhances replication speed and efficiency.
- Segmented Key Cache for Aria: This optimization allows better memory management for Aria storage engine.
- Improved MDL Scalability: This enhancement supports larger workloads more effectively.
- Faster Vector Distance Calculations: Through extrapolation, these computations are now quicker, benefitting applications that require complex calculations.
In addition to performance upgrades, MariaDB 12.1 introduces several compatibility and functional features:
- Caching_sha2_password Plugin: Enhances security by improving password hashing mechanisms.
- Associative Arrays: This feature allows for more complex data structures in SQL.
- Optimizer Hints: New hints like [NO_]JOIN_INDEX and others provide developers with more control over query execution plans.
- Wildcard Support in MariaDB-Dump: This functionality enhances backup and restore capabilities.
- Support for Functional Indexes: This addition allows users to create indexes on expressions, improving query performance.
Other notable features include the ability to retry applying write sets on Galera nodes, per-table unique FOREIGN KEY constraint names, and the removal of depth limits from JSON functions. Furthermore, definitions of tables and views can now be included in the optimizer trace, aiding in debugging and performance tuning.
Overall, the preview of MariaDB 12.1 showcases a commitment to enhancing performance, compatibility, and usability, setting the stage for future developments in the database management system. As this is a rolling release, users can expect continuous improvements and updates as the version matures
- Delayed Logging for Audit Plugin: This improvement allows for more efficient data handling.
- Parallel Replication for Galera Replicas: This feature enhances replication speed and efficiency.
- Segmented Key Cache for Aria: This optimization allows better memory management for Aria storage engine.
- Improved MDL Scalability: This enhancement supports larger workloads more effectively.
- Faster Vector Distance Calculations: Through extrapolation, these computations are now quicker, benefitting applications that require complex calculations.
In addition to performance upgrades, MariaDB 12.1 introduces several compatibility and functional features:
- Caching_sha2_password Plugin: Enhances security by improving password hashing mechanisms.
- Associative Arrays: This feature allows for more complex data structures in SQL.
- Optimizer Hints: New hints like [NO_]JOIN_INDEX and others provide developers with more control over query execution plans.
- Wildcard Support in MariaDB-Dump: This functionality enhances backup and restore capabilities.
- Support for Functional Indexes: This addition allows users to create indexes on expressions, improving query performance.
Other notable features include the ability to retry applying write sets on Galera nodes, per-table unique FOREIGN KEY constraint names, and the removal of depth limits from JSON functions. Furthermore, definitions of tables and views can now be included in the optimizer trace, aiding in debugging and performance tuning.
Overall, the preview of MariaDB 12.1 showcases a commitment to enhancing performance, compatibility, and usability, setting the stage for future developments in the database management system. As this is a rolling release, users can expect continuous improvements and updates as the version matures
MariaDB 12.1 Preview released
A preview of MariaDB 12.1, a rolling release, has been made available by the MariaDB Foundation. Performance enhancements in the update include delayed logging for the audit plugin, parallel replication for Galera replicas, segmented key cache for Aria, improved MDL scalability, and quicker vector distance computations through extrapolation. Compatibility features like the caching_sha2_password plugin, associative arrays, optimizer hints, and other features like functional index support, wildcard support, and retrying write sets on Galera nodes are also included.
