Tag Archives: release
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. …
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:
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,…
…
Continue reading “10.9 preview feature: SHOW ANALYZE and EXPLAIN FOR CONNECTION support”
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
- Extend SHOW EXPLAIN to support SHOW ANALYZE [FORMAT=JSON] (MDEV-27021)
- Add EXPLAIN FOR CONNECTION syntax support to SHOW EXPLAIN (MDEV-10000)
JSON Range Notation
- Implement range notation for JSONPath (MDEV-27911)
- Support JSONPath negative index (MDEV-22224)
- JSON_OVERLAPS function (MDEV-27677)
Async redo log write
- Asynchronous redo log write (MDEV-26603)
Miscellaneous
- Implement the –do-domain-ids, –ignore-domain-ids, and –ignore-server-ids options for mysqlbinlog (MDEV-20119)
- information_schema.tables.table_type now shows TEMPORARY
for local temporary tables.
…
Continue reading “MariaDB 10.9 preview releases now available”
The MariaDB Foundation is pleased to announce the availability of MariaDB 10.8.2, a release candidate in the MariaDB 10.8 series, MariaDB 10.7.3, a Generally Available release in the MariaDB 10.7 series (maintained for one year), as well as MariaDB 10.6.7, MariaDB 10.5.15, MariaDB 10.4.24, MariaDB 10.3.34 and MariaDB 10.2.43, the latest stable releases in their respective series.
These primarily fix a problem in last week’s releases when manually running mariadb-upgrade. See MDEV-27789, and the release notes and changelogs for details. …
2022 is off to a flying start and there are seven new MariaDB Server releases to kick things off. The MariaDB Foundation is pleased to announce the availability of MariaDB 10.8.1, the first release candidate in the MariaDB 10.8 series, MariaDB 10.7.2, the first Generally Available release in the MariaDB 10.7 series (maintained for one year), as well as MariaDB 10.6.6, MariaDB 10.5.14, MariaDB 10.4.23, MariaDB 10.3.33 and MariaDB 10.2.42, the latest stable releases in their respective series. …
Following up on our announcement of the new release model, first used in 10.7.0, we are pleased to announce that the MariaDB Server 10.8.0 preview releases are now available.
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.8
The features available in the preview releases, and therefore under consideration for release in 10.8.1, are:
- MDEV-4989 mysqlbinlog GTID support
- MDEV-10654 Stored Procedures INOUT Parameters
- MDEV-11675 Lag free ALTER TABLE in replication
- MDEV-13756 Descending indexes
- MDEV-14425 InnoDB redo log improvements
- MDEV-17554 Auto create partition
- MDEV-26519 JSON Histograms
- MDEV-26713 Windows – Improved i18n support
- MDEV-27106 Spider Storage Engine Improvements
- MDEV-27265 Misc.
…
Continue reading “MariaDB 10.8.0 preview releases now available”
The MariaDB Foundation is pleased to announce the availability of MariaDB 10.7.1, the first release candidate in the MariaDB 10.7 series, as well as MariaDB 10.6.5, MariaDB 10.5.13, MariaDB 10.4.22, MariaDB 10.3.32 and MariaDB 10.2.41, the latest stable releases in their respective series.
See the release notes and changelogs for details.
Release Notes Changelog What is MariaDB 10.7?
Release Notes Changelog What is MariaDB 10.6?
…
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?
…