10.7 feature preview: Miscellaneous features
The “Misc features” preview includes all the other features that did not make it into a separate dedicated preview binary.
MariaDB Server 10.7 includes the JSON_EQUALS function, which compares inputs as JSON objects, regardless of whitespace, key order, or number format. …
Continue reading “10.7 feature preview: Miscellaneous features”
10.7 preview feature: Password Reuse Check plugin
By default, MariaDB does not check if a user reuses a password. Some security policies require users to choose a new password each time, and the Password Reuse Check plugin, available in a MariaDB 10.7.0 preview, enables this functionality. …
Continue reading “10.7 preview feature: Password Reuse Check plugin”
10.7 preview feature: CONVERT PARTITION
If you are using table partitioning, you have likely heard of the ALTER TABLE … EXCHANGE PARTITION … WITH TABLE … command. It existed in MariaDB since forever. …
10.7 preview feature: Python-like string formatting
Sometimes there is a need to combine data from different columns into one string. For example,
This doesn’t look too bad, but can quickly get out of hand, if you need to do something more complex than that. …
Continue reading “10.7 preview feature: Python-like string formatting”
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. …
By Percona, 2021-10-06
By Percona, 2021-10-06
By Sergey Petrunia, 2021-10-05
By Percona, 2021-10-05
By Percona, 2021-10-05
By Percona, 2021-10-05