Tag: MariaDB 10.9
-
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:
There is also the ANALYZE FORMAT=JSON variant which provides much more information: it produces EXPLAIN FORMAT=JSON output, amended with observed runtime statistics. The statistics fields start with “r_”:
- “r_loops” shows how many times each query plan element was executed
- “r_rows” shows how many rows it has produced, on average
- “r_total_time_ms” shows how much time each query plan element took
-
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, […]
-
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 […]