10.7 preview feature JSON Histograms

MariaDB has had support for histograms as part of Engine Independent Table Statistics since 10.0. As part of Google Summer of Code (MDEV-21130), Michael Okoko, together with his mentor Sergey Petrunia, have implemented a new format (using JSON) for histograms that significantly improves the accuracy and flexibility of histograms. For those just interested in the feature details, you can skip to the “New format”, however if one is unfamiliar with the purpose of histograms, read on.

Why statistics are needed

Histograms are important for queries where the WHERE clause uses columns that are not indexed.

10.7 preview feature: Compression Provider Plugins

MariaDB has been using a pluggable storage engine architecture for a long time and whilst this means great flexibility in choosing and managing the right storage engines for specific use cases, it also means they are easier to develop and therefore there’s an expectation that more engines will be created.

More storage engines means the MariaDB Server itself needs to be as flexible as possible to accommodate all sorts of functionalities that storage engines may need. One area where the MariaDB Server proved to be not that welcoming was in making available all the compression libraries needed by storage engines.

10.7 preview feature: Natural sort

Natural sort order is the ordering of strings in alphabetical order, while numbers are treated as numbers. This understanding of sorting is closer to human comprehension than to a machine. You can find an example of this feature in the Windows file manager. There the files are sorted in natural order. Try to create four folders “b1”, “a11”, “a2”, “a1”.

There are several programming languages which have natural sort. In PHP it is built-in function natsort, while as an third-party module in Python it is natsort, in Perl it is Sort::Naturally and in Matlab it is sort_nat.

10.7 preview feature: UUID Data Type

Universally unique identifiers (UUIDs) have a common place in computing already. A 128-bit value with a text representational value and the prescription of a number of version types to ensure a uniqueness makes it an ideal data type.

After many years of the UUID datatype existing only as a feature request in MDEV-4958, slowly accumulating votes and watchers, we are pleased to announce a preview of the UUID data type. Like the INET6 data type, this uses the datatype plugin API from MariaDB 10.5.

What does the UUID data type look like?

10.7.0 Comes As Preview Releases

Now is the time to try out the new candidate features of MariaDB Server 10.7, the next release series of MariaDB! This blog describes how the new preview releases work, and where we need your help as a MariaDB user.

The challenge: Making MariaDB mature quicker

Remember the challenges and visions I described two weeks ago? To address them we launch an experiment with several parallel preview releases of MariaDB Server 10.7 features.

This should solve two challenges mentioned in the blog: giving users early access to new functionality and making releases mature more rapidly through intensive internal testing.

Join our Server Fest 21-22 Sep 2021!

Update: MariaDB Server Fest 2021 will be held on the 5th and 6th of October 2021. You can find more information in this blog post.

It is time to feast! More specifically, it is time for the next full MariaDB Server Fest two weeks from now, 21-22.9.2021. Register for it! Plan for attending individual talks! And warm yourself up by watching our cool video – “forget everything you know!”. 

We used to do UnConferences for contributors

You may recall that we at the MariaDB Foundation did our first MariaDB Server Fest in September 2020.

MariaDB 10.6.4, 10.5.12, 10.4.21, 10.3.31 and 10.2.40 now available

The MariaDB Foundation is pleased to announce the availability of MariaDB 10.6.4, MariaDB 10.5.12, MariaDB 10.4.21, MariaDB 10.3.31 and MariaDB 10.2.40, the latest stable releases in their respective series.

See the release notes and changelogs for details.

Download MariaDB 10.6.4

Release Notes Changelog What is MariaDB 10.6?

Download MariaDB 10.5.12

Release Notes Changelog What is MariaDB 10.5?

Download MariaDB 10.4.21

Release Notes Changelog What is MariaDB 10.4?

MariaDB 10.6.3 GA now available

The MariaDB Foundation is pleased to announce the availability of MariaDB 10.6.3, the first stable (GA) release in the MariaDB 10.6 series.

See the release notes and changelogs for details.

Download MariaDB 10.6.3

Release Notes Changelog What is MariaDB 10.6?

MariaDB APT and YUM Repository Configuration Generator

Contributors to MariaDB 10.6.3

Alexey Botchkov (MariaDB Corporation)
Alexey Bychko (MariaDB Corporation)
Alice Sherepa (MariaDB Corporation)
Andrei Elkin (MariaDB Corporation)
Anel Husakovic (MariaDB Foundation)
Brad Smith
Daniel Bartholomew (MariaDB Corporation)
Daniel Black (MariaDB Foundation)
Elena Stepanova (MariaDB Corporation)
Eugene Kosov (MariaDB Corporation)
Igor Babaev (MariaDB Corporation)
Jan Lindström (MariaDB Corporation)
Jean Weisbuch
Jiang Xing-zhi
Jordy Zomer
Julius Goryavsky (MariaDB Corporation)
Marko Mäkelä (MariaDB Corporation)
Michael Widenius (MariaDB Corporation and MariaDB Foundation)
Otto Kekäläinen
Sergei Golubchik (MariaDB Corporation)
Sergei Petrunia (MariaDB Corporation)
Thirunarayanan Balathandayuthapani (MariaDB Corporation)
Vicențiu Ciorbaru (MariaDB Foundation)
Vladislav Vaintroub (MariaDB Corporation)
24 Contributors

Thanks, and enjoy MariaDB! …