MariaDB 10.9.3, 10.8.5, 10.7.6 and 10.6.10 now available

The MariaDB Foundation is pleased to announce the availability of MariaDB 10.9.3, MariaDB 10.8.5 and MariaDB 10.7.6, the latest Generally Available releases in their respective short-term support series (maintained for one year from their first GA release dates), as well as MariaDB 10.6.10 the latest stable release in the 10.6 long-term support series (maintained for five years).

These releases fix critical regressions found in the previous releases. See the release notes and changelogs for details.


Download MariaDB 10.9.3

Release Notes Changelog What is MariaDB 10.9?

MariaDB 10.10.1 RC and 10.9.2 GA now available

The MariaDB Foundation is pleased to announce the availability of MariaDB 10.10.1, the first release candidate in the MariaDB 10.10 series, and MariaDB 10.9.2 the first generally available release in the MariaDB 10.9 series. These are both short-term support series, maintained for one year after GA.

See the release notes and changelogs for details.


Download MariaDB 10.10.1

Release Notes Changelog What is MariaDB 10.10?


Download MariaDB 10.9.2

Release Notes Changelog What is MariaDB 10.9?

MariaDB 10.8.4, 10.7.5, 10.6.9, 10.5.17, 10.4.26 and 10.3.36 now available

The MariaDB Foundation is pleased to announce the availability of MariaDB 10.8.4 and MariaDB 10.7.5, the latest Generally Available releases in their respective short-term support series (maintained for one year from their first GA release dates), as well as MariaDB 10.6.9, MariaDB 10.5.17, MariaDB 10.4.26, MariaDB 10.3.36 the latest stable releases in their respective long-term support series (maintained for five years).

See the release notes and changelogs for details. Note that repo mirrors may take some time to sync.


Download MariaDB 10.8.4

Release Notes Changelog What is MariaDB 10.8?

MariaDB 10.9.1, 10.8.3, 10.7.4, 10.6.8, 10.5.16, 10.4.25, 10.3.35 and 10.2.44 now available

The MariaDB Foundation is pleased to announce the availability of MariaDB 10.9.1, the first Release Candidate (RC) in the MariaDB 10.9 series, MariaDB 10.8.3, the first Generally Available (GA) release in the MariaDB 10.8 series, MariaDB 10.7.4, the second Generally Available release in the MariaDB 10.7 series (all maintained for one year from their first GA release dates), as well as MariaDB 10.6.8, MariaDB 10.5.16, MariaDB 10.4.25, MariaDB 10.3.35 and MariaDB 10.2.44, the latest stable releases in their respective series. …

10.9 preview feature: SHOW ANALYZE and EXPLAIN FOR CONNECTION support

SHOW ANALYZE

If you ever had to do query performance troubleshooting with MariaDB, you should be
familiar with MariaDB’s ANALYZE for statements feature. It does what EXPLAIN ANALYZE does in some other database systems: ANALYZE query runs the query and produces EXPLAIN output, amended with the data from the query execution:

ANALYZE SELECT *
FROM orders, customer
WHERE
customer.c_custkey = orders.o_custkey AND
customer.c_acctbal < 0 AND
orders.o_totalprice > 200*1000
+—-+————-+———-+——+—————+————-+———+——————–+——–+——–+———-+————+————-+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | r_rows | filtered | r_filtered | Extra |
+—-+————-+———-+——+—————+————-+———+——————–+——–+——–+———-+————+————-+
| 1 | SIMPLE | customer | ALL | PRIMARY,…

10.9 preview feature: JSON path expression and JSON_OVERLAPS()

The MariaDB 10.9 preview releases introduce a MySQL compatibility syntax extension, range notation. The ‘last’ keyword was added in JSON path expression, as requested in MDEV-22224 and MDEV-27911. Additionally, negative indexes are now also supported. Range notation, implemented using the ‘to’ keyword, and the ‘last’ keyword, is basically an array element selector.

Syntax:

Range notation:
[M to N] selects a range of elements starting from index M to N.
Last keyword:
[last-N] / [last] selects the Nth from last element, and last element, respectively.

MariaDB 10.9 preview releases now available

We are pleased to announce the third MariaDB series release under the new release model, MariaDB 10.9.0.

Maturing MariaDB more quickly

One of the purposes of the new model is to get features into the hands of users more quickly, in a form which supports stability by allowing the new feature to be more easily tested, separate from other new features being developed at the same time.

Candidate features for MariaDB 10.9

There are four separate preview releases, containing the following features under consideration for release in 10.9.1:

SHOW ANALYZE FORMAT=JSON

  1. Extend SHOW EXPLAIN to support SHOW ANALYZE [FORMAT=JSON] (MDEV-27021)
  2. Add EXPLAIN FOR CONNECTION syntax support to SHOW EXPLAIN (MDEV-10000)

JSON Range Notation

  1. Implement range notation for JSONPath (MDEV-27911)
  2. Support JSONPath negative index (MDEV-22224)
  3. JSON_OVERLAPS function (MDEV-27677)

Async redo log write

  1. Asynchronous redo log write (MDEV-26603)

Miscellaneous

  1. Implement the –do-domain-ids, –ignore-domain-ids, and –ignore-server-ids options for mysqlbinlog (MDEV-20119)
  2. information_schema.tables.table_type now shows TEMPORARY
    for local temporary tables.