Post Syndicated from Michael "Monty" Widenius original http://monty-says.blogspot.com/2017/05/mariadb-102-ga-released-with-several.html
The most noteworthy ones are:
- Windows Functions gives you the ability to do advanced calculation over a sliding window.
- Common table expressions allows you to do more complex SQL statements without having to do explicit temporary tables.
- We finally have a DEFAULT clause that can take expressions and also CHECK CONSTRAINT.
- Multiple triggers for the same event. This is important for anyone trying to use tools, like pt-online-schema-change, which requires multiple triggers for the same table.
- A new storage engine, MyRocks, that gives you high compression of your data without sacrificing speed. It has been developed in cooperation with Facebook and MariaDB to allow you to handle more data with less resources.
- flashback, a feature that can rollback instances/databases/tables to an old snapshot. The version in MariaDB 10.2 is DML only. In MariaDB 10.3 we will also allow rollback over DML (like DROP TABLE).
- Compression of events in the binary log.
- JSON functions added. In 10.2.7 we will also add support for CREATE TABLE … (a JSON).
A few smaller but still noteworthy new features:
- Connection setup was made faster by moving creation of THD to a new thread. This, in addition with better thread caching, can give a connection speedup for up to 85 % in some cases.
- Table cache can automatically partition itself as needed to reduce the contention.
- NO PAD collations, which means that end space are significant in comparisons.
- InnoDB is now the default storage engine. Until MariaDB 10.1, MariaDB used the XtraDB storage engine as default. XtraDB in 10.2 is not up to date with the latest features of InnoDB and cannot be used. The main reason for this change is that most of the important features of XtraDB are nowadays implemented in InnoDB . As the MariaDB team is doing a lot more InnoDB development than ever before, we can’t anymore manage updating two almost identical engines. The InnoDB version in MariaDB contains the best features of MySQL InnoDB and XtraDB and a lot more. As the InnoDB on disk format is identical to XtraDB’s this will not cause any problems when upgrading to MariaDB 10.2
- The old GPL client library is gone; now MariaDB Server comes with the LGPL Connector/C client library.
There are a lot of other new features, performance enhancements and variables in MariaDB 10.2 for you to explore!
I am happy to see that a lot of the new features have come from the MariadB community! (Note to myself; This list doesn’t include all contributors to MariadB 10.2, needs to be update.)
Thanks a lot to everyone that has contributed to MariaDB!