Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
MariaDB 10.2 was a short-term maintenance series of MariaDB maintained until November 2023
The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now
Download 10.2.34 | Release Notes | Changelog | Overview of 10.2
Release date: 7 Oct 2020
MariaDB 10.2 is a previous stable series of MariaDB. It is an evolution of MariaDB 10.1 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
MariaDB 10.2.34 is a Stable (GA) release.
For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.
Thanks, and enjoy MariaDB!
Fixes for the following :
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended for all users due to bug which caused serious stability issues with earlier versions. See the bug issue page for more information. When upgrading from or earlier to or higher, running is required due to changes introduced in .
For a complete list of changes made in with links to detailed information on each push, see the .
For a full list of contributors to , see the .
The most recent release of is: Stable (GA)
| | |
Release date: 8 Nov 2021
is a previous stable series of MariaDB. It is an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release.
For an overview of see the page.
Thanks, and enjoy MariaDB!
Fix for WSREP: invalid state ROLLED_BACK (FATAL) (MDEV-25114)
ALTER TABLE…IMPORT TABLESPACE fixes (MDEV-20931, MDEV-26131)
innodb_undo_log_truncate fixes (MDEV-26450, MDEV-26864)
Memory hogging on slave by ROW event applier is eliminated (MDEV-26712)
mysql --binary-mode now properly handles \\0 in data (MDEV-25444)
Missed statement rollback in case transaction drops or create temporary table is corrected (MDEV-26833)
Session tracking flag in OK_PACKET (MDEV-26868)
Some views force server (and mysqldump) to generate invalid SQL for their definitions (MDEV-26299)
Fixes for the following :
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended for all Galera users due to bug MDEV-12837 which caused serious stability issues with earlier versions. See the bug issue page for more information. When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher, running is required due to changes introduced in MDEV-14637.
For a complete list of changes made in MariaDB 10.2.41 with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.2.41, see the MariaDB Foundation release announcement.
The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now
Download | Release Notes | Changelog | Overview of 10.2
Release date: 12 May 2020
MariaDB 10.2 is a previous stable series of MariaDB. It is an evolution of MariaDB 10.1 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
MariaDB 10.2.32 is a Stable (GA) release.
For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.
Thanks, and enjoy MariaDB!
Fixed issue that, from , disabled all created by a server with a different server_id. Note that the fix does not re-enable affected events. ()
updated to 11.0 ()
mariadb-backup does not honor ignore_db_dirs from server config ()
mariadb-backup --ftwrl-wait-timeout never times out on explicit lock ()
FULLTEXT INDEX, Assertion ``!table->fts->in_queue
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended for all users due to bug which caused serious stability issues with earlier versions. See the bug issue page for more information. When upgrading from or earlier to or higher, running is required due to changes introduced in .
For a complete list of changes made in with links to detailed information on each push, see the .
For a full list of contributors to , see the . Thanks, and enjoy MariaDB!
The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now
Download 10.2.40 | Release Notes | Changelog | Overview of 10.2
Release date: 6 Aug 2021
Warning: This version can cause InnoDB file corruption on FreeBSD and on AIX. Stick to an earlier release, or upgrade to a more recent release, if you are running either of these environments. See MDEV-26537.
MariaDB 10.2 is a previous stable series of MariaDB. It is an evolution of MariaDB 10.1 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
MariaDB 10.2.40 is a Stable (GA) release.
For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.
Thanks, and enjoy MariaDB!
InnoDB no longer acquires advisory file locks by default ()
Encryption: Automatically disable key rotation checks for file_key_management plugin ()
Some fixes from MySQL 5.7.35 ()
A query that uses ORDER BY .. LIMIT clause and "Range checked for each record optimization" could produce incorrect results under some circumstances ()
Queries that have more than 32 equality conditions comparing columns of different tables ("tableX.colX=tableY.colY) could cause a stack overrun in the query optimizer (, )
"Condition pushdown into derived table" optimization cannot be applied if the expression being pushed refers to a derived table column which is computed from expression that has a stored function call, @session variable reference, or other similar construct. The fix for makes it so that only the problematic part of the condition is not pushed. The rest of the condition is now pushed. ()
updated to 25.3.34
Fixes for the following :
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended for all users due to bug which caused serious stability issues with earlier versions. See the bug issue page for more information. When upgrading from or earlier to or higher, running is required due to changes introduced in .
For a complete list of changes made in with links to detailed information on each push, see the .
For a full list of contributors to , see the .
The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now
Download 10.2.39 | Release Notes | Changelog | Overview of 10.2
Release date: 23 Jun 2021
MariaDB 10.2 is a previous stable series of MariaDB. It is an evolution of MariaDB 10.1 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
MariaDB 10.2.39 is a Stable (GA) release.
For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.
Thanks, and enjoy MariaDB!
This version of MariaDB is being released now to fix the following two regressions:
Table alias from previous statement interferes later commands ()
Join using derived with aggregation returns incorrect results ()
In addition to the above, this release also contains the following fixes:
Change buffer entries are lost on InnoDB restart ()
InnoDB spatial indexes miss large geometry fields after ()
Double free of transaction during truncate operation ()
Double free of table when inplace alter FTS add index fails ()
Do not replicate killed multi-table OPTIMIZE TABLE when the signal arrives before any table has been processed ()
Fix optistic parallel applier to not deadlock on admin commands OPTIMIZE, REPAIR, and ANALYZE ()
Backport parallel slave server shutdown hang ()
Fixes for the following :
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended
for all users due to bug which caused serious stability
issues with earlier versions. See the bug issue page for more information.
When upgrading from or earlier to or higher,
running is required due to changes introduced in .
MongoDB protocol support files for the engine are missing in this release.
If you want to use engine with MongoDB, you need to download or and put a path to this file into the connect_class_path in the my.cnf.
For a complete list of changes made in with links to detailed information on each push, see the .
For a full list of contributors to , see the .
The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now
Download 10.2.36 | Release Notes | Changelog | Overview of 10.2
Release date: 11 Nov 2020
MariaDB 10.2 is a previous stable series of MariaDB. It is an evolution of MariaDB 10.1 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
MariaDB 10.2.36 is a Stable (GA) release.
For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.
Thanks, and enjoy MariaDB!
Out-of-cycle release to fix regressions in
Follow up to to alter protocol checks to support the following implementations (which add garbage to the end of some packets):
PHP PDO (all versions) ()
mysqlnd (from PHP < 7.3) ()
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended for all users due to bug which caused serious stability issues with earlier versions. See the bug issue page for more information. When upgrading from or earlier to or higher, running is required due to changes introduced in .
For a complete list of changes made in with links to detailed information on each push, see the .
For a full list of contributors to , see the .
The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now
Download 10.2.43 | Release Notes | Changelog | Overview of 10.2
Release date: 12 Feb 2022
MariaDB 10.2 is a previous stable series of MariaDB. It is an evolution of MariaDB 10.1 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
MariaDB 10.2.43 is a Stable (GA) release.
For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.
Thanks, and enjoy MariaDB!
This release fixes a blocking problem with the release when manually running . ()
See for other changes since the previous release.
Fixes for the following :
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended for all users due to bug which caused serious stability issues with earlier versions. See the bug issue page for more information. When upgrading from or earlier to or higher, running is required due to changes introduced in .
For a complete list of changes made in with links to detailed information on each push, see the .
For a full list of contributors to , see the .
' failed inWrong estimate of affected BLOB columns in update of PRIMARY KEY (MDEV-22384)
Duplicate key value is silently truncated to 64 characters in print_keydup_error (MDEV-20604)
Session tracking returns incorrectly long tracking data (MDEV-22504)
Add pam_user_map.so file to binary tarball package (MDEV-21913)
Running out of file descriptors and eventual crash (MDEV-18027)
mysql_upgrade is made aware of the upstream slave tables to issue warnings when that takes place (MDEV-10047)
Corruption for SET GLOBAL innodb_ string variables (MDEV-22393)
wsrep performance optimization (MDEV-7962)
parameter, --ignore-table-data, added (MDEV-22037)
Server can fail while replicating conditional comments (Bug#28388217)
Galera wsrep library updated to 25.3.29
Added the xml-report option to (MDEV-22176)
As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.2 for Debian 8 "Jessie"
Fixes for the following :
A query with window function on the left side of the subquery could cause a crash. (MDEV-25630)
Wrong result selecting from simple view with LIMIT and ORDER BY Queries with views/derived table/CTEs that have this form: "(SELECT ... LIMIT ) ORDER BY ...>" could produce wrong results (MDEV-25679)
Potential hang in purge for virtual columns (MDEV-25664)
Change buffer entries for secondary indexes are lost on InnoDB restart (MDEV-25869)
mysql-connector-python (all versions) (MDEV-24134)
and mysql-connector-java (all versions)
The query optimizer consumed a lot of memory when handling construct in form of key_column [NOT] IN (large-list-of constants) (MDEV-24117)
Fixes for the following :
CVE--``#
The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now
Download 10.2.37 | Release Notes | Changelog | Overview of 10.2
Release date: 22 Feb 2021
Last month long-time MariaDB VP of Engineering, Rasmus Johansson, passed due to complications from cancer. His loss has been felt keenly by the whole MariaDB team. Our thoughts are with his family during this difficult time and this release is dedicated to his memory.
MariaDB 10.2 is a previous stable series of MariaDB. It is an evolution of MariaDB 10.1 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
MariaDB 10.2.37 is a Stable (GA) release.
For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.
Thanks, and enjoy MariaDB!
- Hang in buf_page_create() after reusing a previously freed page
- analyze forces full scan forcing lock crash
- Corruption of system tablespace or last recovered page
updated to 25.3.32
- Server hang due to Galera lock conflict resolution
- BF-BF Conflict issue because of UK GAP locks
- Plugin system variables and activation options can break
- relay-log is corrected to rotate past 999999
- fixed slave applier for row-based events with FK constraints on virtual columns
- Relay_Log_Space of Show-Slave-Status is made thread-safe
- anomalies in mysql.user tables on previously 5.7 MySQL versions corrected
- option
Fixes for the following :
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended for all users due to bug which caused serious stability issues with earlier versions. See the bug issue page for more information. When upgrading from or earlier to or higher, running is required due to changes introduced in .
For a complete list of changes made in with links to detailed information on each push, see the .
For a full list of contributors to , see the .
The most recent release of is: Stable (GA)
| | |
Release date: 9 Feb 2022
This release is no longer available for download after a problem was noticed when manually running mariadb-upgrade. See for more details.Please use a later release.
is a previous stable series of MariaDB. It is an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release.
For an overview of see the page.
The most recent release of is: Stable (GA)
| | |
Release date: 10 Aug 2020
is a previous stable series of MariaDB. It is an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release.
For an overview of see the page.
Thanks, and enjoy MariaDB!
The most recent release of is: Stable (GA)
| | |
Release date: 7 May 2021
is a previous stable series of MariaDB. It is an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release.
For an overview of see the page.
Thanks, and enjoy MariaDB!
The most recent release of is: Stable (GA)
| | |
Release date: 2 Jan 2019
is the previous stable series of MariaDB. It is an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release.
For an overview of see the page.
Upgrading from earlier 10.2.x versions is highly recommended for all Galera users due to bug which caused serious stability issues with earlier versions. See the bug issue page for more information.
The most recent release of is: Stable (GA)
| | |
Release date: 11 Sep 2019
is a previous stable series of MariaDB. It is an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release.
For an overview of see the page.
Thanks, and enjoy MariaDB!
MDEV-25179 - and system variables are now read-only
does not disallow .isl file creation (MDEV-26870)
Galera updated to 25.3.35
Galera SST scripts should use ssl_capath (not ssl_ca) for CA directory (MDEV-27181)
Seconds behind master corrected from artificial spikes at relay-log rotation (MDEV-16091)
Statement rollback in binlog when transaction creates or drop temporary table is set right (MDEV-26833)
prohibition running two upgrades in parallel (MDEV-27068, MDEV-27107, MDEV-27279)
script updated to version 2022-02-08, with the following fixes and enhancements:
Default location of the script has been moved to: mariadb_repo_setup (old location is deprecated, but still works)
The GPG keyring file, used with Debian and Ubuntu repositories, has moved to: and the checksum for the file can be found at:
Support for RHEL and SLES aarch64 repositories added
New function added to verify that the MariaDB Server version, if specified on the command line, follows the correct naming and that a corresponding repository actually exists.
Fixed repository pinning for Ubuntu and Debian repositories
MariaDB Server 10.7 is now the default server version
Faster initialization by disabling binary logging during initialization (MDEV-27074)
mysql_upgrade can be run if needed using the environment variable MARIADB_AUTO_UPGRADE=1 (MDEV-25670)
A healthcheck script /usr/local/bin/healthcheck.sh is installed in the container with various checking options (MDEV-25434)
mysql@localhost user is created with the environment variable MARIADB_MYSQL_LOCALHOST_USER=1 and additional grants (beyond USAGE) with MARIADB_MYSQL_LOCALHOST_GRANTS={global grant list} ()
skip innodb buffer pool loads/dumps on temporary startup/shutdown for faster startup/initialization, and accurate "healthcheck.sh --innodb_buffer_pool_loaded"
change group ownership on datadir/socket dir ()
log note about note on Securing system users, mysql_secure_installation not required ()
Fixes for the following :
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended for all Galera users due to bug MDEV-12837 which caused serious stability issues with earlier versions. See the bug issue page for more information. When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher, running is required due to changes introduced in MDEV-14637.
For a complete list of changes made in MariaDB 10.2.42 with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.2.42, see the MariaDB Foundation release announcement.
Limit to 255 (MDEV-22258).
Minimum value of raised to 8 (previously 4) so fixed size like and are not truncated for lower values of max_sort_length (MDEV-22715).
updated to 5.7.29
Fixed corruption in delete buffering (MDEV-22497)
Fixed a deadlock in FLUSH TABLES…FOR EXPORT (MDEV-22890)
InnoDB data file extension is not crash-safe (MDEV-23190)
Minor fixes related to encryption and FULLTEXT INDEX
Dropping the adaptive hash index may cause DDL to lock up InnoDB ()
innodb_log_optimize_ddl=OFF is not crash safe ()
Mariadb service won't shutdown when it's running and the OS datetime updated backwards ()
Doublewrite recovery can corrupt data pages ()
Fixed race conditions related to buffer pool resizing
Crash recovery fixes (, , )
Make the binlog dump thread to log into errorlog a requested GTID position (MDEV-20428)
Fix stop of the optimistic parallel slave at requested START-SLAVE-UNTIL position (MDEV-15152)
Properly handle RESET MASTER TO value, when the value exceeds the max allowed 2147483647 (MDEV-22451)
Correct 'relay-log.info' updating by concurrent parallel workers ()
Eliminate deadlock involving parallel workers, STOP SLAVE and FLUSH TABLES WITH READ LOCK ()
Correct master-slave automatic reconnection by slave to always pass through all steps of the initial connect. Specifically, do not skip master notification about slave binlog checksum awareness ()
ALTER TABLE ... ANALYZE PARTITION ... with EITS reads and locks all rows ... (MDEV-21472)
Print ranges in the optimizer trace created for non-indexed columns when optimizer_use_condition_selectivity >2 Now the optimizer trace shows the ranges constructed while getting estimates from EITS (MDEV-22665)
LATERAL DERIVED is not clearly visible in EXPLAIN FORMAT=JSON, make LATERAL DERIVED tables visible in EXPLAIN FORMAT=JSON output ()
Crash on WITH RECURSIVE large query ()
Crash with Prepared Statement with a '?' parameter inside a re-used CTE ()
is now taken into account for all intermediate calculations. Previously results could be unpredictable. Note that this means results will have a lower precision in some cases - see (MDEV-19232)
MariaDB could crash after changing the query_cache size (MDEV-5924)
Errors and SIGSEGV on CREATE TABLE w/ various charsets (MDEV-22111)
Crash in CREATE TABLE AS SELECT when the precision of returning type = 0 ()
XA: Reject DDL operations between PREPARE and COMMIT ()
Stop mariadb-backup --prepare on errors during innodb redo log applying ()
Server crashes in mysql_alter_table upon adding a non-null date column under NO_ZERO_DATE with ALGORITHM=INPLACE ()
Can't uninstall plugin if the library file doesn't exist ()
Fixes for the following :
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended for all Galera users due to bug MDEV-12837 which caused serious stability issues with earlier versions. See the bug issue page for more information. When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher, running is required due to changes introduced in MDEV-14637.
For a complete list of changes made in MariaDB 10.2.33 with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.2.33, see the MariaDB Foundation release announcement.
for calculating the spherical distance between two geometries (point or multipoint) on a sphere (MDEV-13467)
Crash with invalid multi-table update of view in 2nd execution of SP (MDEV-24823)
Incorrect name resolution for subqueries in ON expressions (MDEV-25362)
Complex query in Store procedure corrupts results (MDEV-25182)
RENAME TABLE causes "Ignoring data file" messages (MDEV-25568)
MVCC read from index on CHAR or VARCHAR wrongly omits rows (MDEV-25459)
Race conditions in persistent statistics (MDEV-10682, MDEV-18802, MDEV-25051)
Galera updated to 25.3.33
SET PASSWORD command fail with wsrep api (MDEV-25258)
Long BF log wait turns on InnoDB Monitor output without telling, never turns it off (MDEV-25319)
Replication Heartbeat event was uncapable to cary 4GB+ offsets (MDEV-16146)
FLUSH LOGS race against Binlog checkpoint event creation (MDEV-24526)
The QUERY_DDL setting now logs CREATE/DROP [PROCEDURE / FUNCTION / USER] statements. See . (MDEV-23457)
As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.2 for Ubuntu 16.04 Xenial
Fixes for the following :
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended
for all Galera users due to bug MDEV-12837 which caused serious stability
issues with earlier versions. See the bug issue page for more information.
When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher,
running is required due to changes introduced in MDEV-14637.
MongoDB protocol support files for the engine are missing in this release.
If you want to use engine with MongoDB, you need to download Mongo2.jar or Mongo3.jar and put a path to this file into the connect_class_path in the my.cnf.
For a complete list of changes made in MariaDB 10.2.38 with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.2.38, see the MariaDB Foundation release announcement.
MDEV-17589 - Stack-buffer-overflow with indexed varchar (utf8) field
MDEV-16987 - possible in read-only mode (forbid ALTER DATABASE in read_only)
MDEV-17720 - does not handle
MDEV-6453 - Assertion `inited==NONE || (inited==RND && scan)' failed in handler::ha_rnd_init(bool) with InnoDB, joins, AND/OR conditions
- fails to copy encrypted InnoDB system tablespace if LSN>4G
- Database corruption after renaming a prefix-indexed column
- Orphan temporary files after interrupted cause InnoDB: Operating system error number 17 and eventual fatal error 71
Fixes for the following :
CVE-`-```
When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher, running is required due to changes introduced inMDEV-14637.
For a complete list of changes made in MariaDB 10.2.21 with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.2.21, see the MariaDB Foundation release announcement.
updated to Connect 1.06.0010
MDEV-15326: A race condition in InnoDB transaction commit that affects record locking was fixed
MDEV-17187: Table doesn't exist in engine after ALTER of FOREIGN KEY
MDEV-20301: InnoDB's MVCC has O(N^2) behaviors
: Simplify .ibd file creation
: Failing assertion: srv_log_file_size <= 512ULL << 30 while preparing backup
: Replication hangs with "preparing" and never starts
: Remove unnecessary locking for INSERT...ON DUPLICATE KEY UPDATE
Fixes for the following :
CVE-`-```
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended for all Galera users due to bug MDEV-12837 which caused serious stability issues with earlier versions. See the bug issue page for more information. When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher, running is required due to changes introduced in MDEV-14637.
For a complete list of changes made in MariaDB 10.2.27 with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.2.27, see the MariaDB Foundation release announcement.
Download | Release Notes | Changelog | Overview of 10.2
Release date: 20 May 2022
MariaDB 10.2 is a previous stable series of MariaDB. It is an evolution of MariaDB 10.1 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
MariaDB 10.2.44 is a Stable (GA) release.
For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.
Thanks, and enjoy MariaDB!
As per the , this will be the final release of
Automatically generated Gtid_log_list_event is made to recognize within replication event group as a formal member ()
using two or more unique key values at a time with is corrected ()
stops issuing unnecessary "Unsafe statement" with ()
Incorrect binlogs after Galera SST using rsync and ()
does not detect multi-source replication slave ()
Useless warning "InnoDB: Allocated tablespace ID for , old maximum was 0" during backup stage ()
prepare fails for incrementals if a new schema is created after full backup is taken ()
Subquery in an UPDATE query uses full scan instead of range ()
Assertion `item1->type() == Item::FIELD_ITEM ... ()
Server crashes in Expression_cache_tracker::fetch_current_stats ()
MariaDB server crash at Item_subselect::init_expr_cache_tracker (, )
Fixes for the following :
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended for all users due to bug which caused serious stability issues with earlier versions. See the bug issue page for more information. When upgrading from or earlier to or higher, running is required due to changes introduced in .
For a complete list of changes made in with links to detailed information on each push, see the .
For a full list of contributors to , see the .
The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now
Download | Release Notes | Changelog | Overview of 10.2
Release date: 18 Aug 2017
MariaDB 10.2 is the current stable series of MariaDB. It is an evolution of MariaDB 10.1 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
MariaDB 10.2.8 is a Stable (GA) release.
For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.
Thanks, and enjoy MariaDB!
updated to 5.7.19
updated to 5.6.36-82.1
engine updated to 1.06.0001
Beta support for added
For a complete list of changes made in , with links to detailed information on each push, see the .
The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now
Download | Release Notes | Changelog | Overview of 10.2
Release date: 27 Sep 2017
MariaDB 10.2 is the current stable series of MariaDB. It is an evolution of MariaDB 10.1 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
MariaDB 10.2.9 is a Stable (GA) release.
For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.
Thanks, and enjoy MariaDB!
updated to 5.6.37-82.2
: IMPORT TABLESPACE may corrupt ROW_FORMAT=REDUNDANT tables
: Allow ALTER TABLE…ADD SPATIAL INDEX…ALGORITHM=INPLACE
: DELETE with CASCADE takes a long time when Galera is enabled
: CREATE FULLTEXT INDEX on encrypted table fails
--export option implemented for ()
Temporary files created by merge sort and row log are encrypted if is set to 1, regardless of whether the table encrypted or not ().
The following variables have been deprecated, and will be removed in a future release ():
Fixes for the following :
CVE-`-```
For a complete list of changes made in , with links to detailed information on each push, see the .
The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now
Note that this version contains an issue that disabled all events created by a server with a different server_id. See MDEV-21758 for details.
Download | Release Notes | Changelog | Overview of 10.2
Release date: 11 Dec 2019
MariaDB 10.2 is a previous stable series of MariaDB. It is an evolution of MariaDB 10.1 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
MariaDB 10.2.30 is a Stable (GA) release.
For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.
Thanks, and enjoy MariaDB!
: SEC_E_INVALID_TOKEN when server sends large message during SSL handshake
: Aria engine: Undo phase failed from incremental backup
: Stop issuing 'row size' error on DML
: Don't print "row size too large" warnings in error log if innodb_strict_mode=OFF and log_warnings<=2
: Remove redundant writes to the redo log
: Wrong result when using a smaller size for sort buffer
: Repl_semi_sync_master::commit_trx assertion failure
Fixes for the following :
CVE-`-```
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended for all users due to bug which caused serious stability issues with earlier versions. See the bug issue page for more information. When upgrading from or earlier to or higher, running is required due to changes introduced in .
For a complete list of changes made in with links to detailed information on each push, see the .
For a full list of contributors to , see the .
The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now
Download | Release Notes | Changelog | Overview of 10.2
Release date: 5 Apr 2017
MariaDB 10.2 is the current development series of MariaDB. It is an evolution of MariaDB 10.1 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
MariaDB 10.2.5 is a Release Candidate (RC) release.
For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.
Thanks, and enjoy MariaDB!
updated to 5.6.35-80.0
updated to 8.40
:
: Fix a 10.1.21 regression with failed INSERT, BEFORE INSERT triggers, and columns with no default value
For a complete list of changes made in , with links to detailed information on each push, see the .
The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now
Download | Release Notes | Changelog | Overview of 10.2
Release date: 26 Jun 2018
MariaDB 10.2 is the previous stable series of MariaDB. It is an evolution of MariaDB 10.1 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
MariaDB 10.2.16 is a Stable (GA) release.
For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.
Upgrading from earlier 10.2.x versions is highly recommended for all Galera users due to bug MDEV-12837 which caused serious stability issues with earlier versions. See the bug issue page for more information.
Thanks, and enjoy MariaDB!
is now
: now supports MyRocks
- InnoDB fails to shut down purge workers, causing hang
- Wrong INFORMATION_SCHEMA.INNODB_BUFFER_PAGE.TABLE_NAME
For a complete list of changes made in with links to detailed information on each push, see the .
For a full list of contributors to , see the .
The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now
After an upgrade MariaDB Server can crash if InnoDB tables exist with a FULLTEXT INDEX and a FOREIGN KEY constraint attached to them. We got reports that the crash already will be encountered on startup, but a crash is also possible at a later stage. See MDEV-20987 for more details.Do not download or use this release.
Download | Release Notes | Changelog | Overview of 10.2
Alternate download from mariadb.org
Release date: 5 Nov 2019
MariaDB 10.2 is a previous stable series of MariaDB. It is an evolution of MariaDB 10.1 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release.
For an overview of see the page.
Thanks, and enjoy MariaDB!
: Debug-only option for dumping the contents of the InnoDB change buffer to the server error log at startup.
mariadb-backup:
: mbstream recreates xtrabackup_info on same directory as backup file
: mariadb-backup creates binlog files in server binlog directory on --prepare --export step
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended for all users due to bug which caused serious stability issues with earlier versions. See the bug issue page for more information. When upgrading from or earlier to or higher, running is required due to changes introduced in .
For a complete list of changes made in with links to detailed information on each push, see the .
For a full list of contributors to , see the .
The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now
Download | Release Notes | Changelog | Overview of 10.2
Release date: 11 Feb 2019
MariaDB 10.2 is the previous stable series of MariaDB. It is an evolution of MariaDB 10.1 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
MariaDB 10.2.22 will be a Stable (GA) release.
For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.
Upgrading from earlier 10.2.x versions is highly recommended for all Galera users due to bug MDEV-12837 which caused serious stability issues with earlier versions. See the bug issue page for more information.
Thanks, and enjoy MariaDB!
updated to 9.5
Backport .
: Maximum value of is now 2097152.
InnoDB ALTER TABLE fixes:, , ,
When upgrading from or earlier to or higher, running is required due to changes introduced in.
For a complete list of changes made in with links to detailed information on each push, see the .
For a full list of contributors to , see the .
The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now
Download | Release Notes | Changelog | Overview of 10.2
Release date: 28 Nov 2017
MariaDB 10.2 is the current stable series of MariaDB. It is an evolution of MariaDB 10.1 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
MariaDB 10.2.11 is a Stable (GA) release.
For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.
Thanks, and enjoy MariaDB!
INSERT ON DUPLICATE KEY UPDATE foreign key fail
Support CRC32 SSE2 implementation under Windows
/ Corruption during online table-rebuilding ALTER when VIRTUAL columns exist
ALTER TABLE…DISCARD TABLESPACE takes a lot of time
mariadb-backup 10.2 fails to back up a multi-file InnoDB system tablespace
mariadb-backup incremental incorrectly extends system tablespace for multi-file innodb_data_file_path
Copy all innodb undo tablespaces from the backup directory to destination
updated to 7.07.
As per the , this will be the last release of for RHEL 7.2 and CentOS 7.2. Starting with the next 10.2 release we will be building MariaDB for CentOS 7 and RHEL 7 on version 7.3.
for Ubuntu 17.10 Artful added
Fixes for the following :
CVE-`-```
For a complete list of changes made in , with links to detailed information on each push, see the .
The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now
Download | Release Notes | Changelog | Overview of 10.2
Release date: 31 Oct 2017
MariaDB 10.2 is the current stable series of MariaDB. It is an evolution of MariaDB 10.1 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
MariaDB 10.2.10 is a Stable (GA) release.
For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.
Thanks, and enjoy MariaDB!
updated to 5.7.20
updated to 1.6.0005
now Stable (GA)
: 'Undo log record is too big.' error occurring in very narrow range of string lengths
For a complete list of changes made in , with links to detailed information on each push, see the .
The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now
Download | Release Notes | Changelog | Overview of 10.2
Release date: 27 Mar 2018
MariaDB 10.2 is the current stable series of MariaDB. It is an evolution of MariaDB 10.1 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
MariaDB 10.2.14 is a Stable (GA) release.
For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.
Upgrading from earlier 10.2.x versions is highly recommended for all Galera users due to bug MDEV-12837 which caused serious stability issues with earlier versions. See the bug issue page for more information.
Thanks, and enjoy MariaDB!
is now
- Added the , for monitoring disk space
- does not work properly when used with DATA DIRECTORY.
- MariaDB (still) slow start
For a complete list of changes made in with links to detailed information on each push, see the .
For a full list of contributors to , see the .
The most recent release of is: Stable (GA)
| | |
Release date: 3 Nov 2020
is a previous stable series of MariaDB. It is an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release.
For an overview of see the page.
Thanks, and enjoy MariaDB!
The most recent release of is: Stable (GA)
| | |
Release date: 24 Dec 2018
is the previous stable series of MariaDB. It is an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
will be a release.
For an overview of see the page.
Upgrading from earlier 10.2.x versions is highly recommended for all Galera users due to bug which caused serious stability issues with earlier versions. See the bug issue page for more information.
The most recent release of is: Stable (GA)
| | |
Release date: 25 Sep 2018
is the previous stable series of MariaDB. It is an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release.
For an overview of see the page.
Upgrading from earlier 10.2.x versions earlier than 10.2.17 is highly recommended for all Galera users due to bug which caused serious stability issues with earlier versions. See the bug issue page for more information.
The most recent release of is: Stable (GA)
| | |
Release date: 14 Aug 2018
is the previous stable series of MariaDB. It is an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release.
For an overview of see the page.
Upgrading from earlier 10.2.x versions is highly recommended for all Galera users due to bug which caused serious stability issues with earlier versions. See the bug issue page for more information.
The most recent release of is: Stable (GA)
Note that this version contains an issue that disabled all events created by a server with a different server_id. See for details.
| | |
Release date: 28 Jan 2020
is a previous stable series of MariaDB. It is an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release.
For an overview of see the page.
Thanks, and enjoy MariaDB!
The most recent release of is: Stable (GA)
| | |
Release date: 17 Jun 2019
is the previous stable series of MariaDB. It is an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release.
For an overview of see the page.
Upgrading from earlier 10.2.x versions is highly recommended for allGalera users due to bug which caused serious stability issues with earlier versions. See the bug issue page for more information.
The most recent release of is: Stable (GA)
| | |
Release date: 24 Dec 2016
is the current development series of MariaDB. It is an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release.
Do not use beta releases on production systems!
For an overview of see the page.
Thanks, and enjoy MariaDB!
now flushes the result file to disk after each processed event so the file can be listed with the actual bytes (MDEV-14608)
Crash with union of my_decimal type in ORDER BY clause (MDEV-25994)
SIGSEGV in st_join_table::cleanup (MDEV-24560)
Assertion `!eliminated' failed in Item_subselect::exec (MDEV-28437)
Fix (MDEV-12181)
Fix (MDEV-12180)
Fixed bug that permitted columns being dropped which would result in an additional constraint being added to the table. See the example in (MDEV-11114).
Nonsensical combinations of SIGNED, UNSIGNED and ZEROFILL are no longer permitted - see (MDEV-8659).
mariadb-backup now included for Debian and Ubuntu (in MariaDB 10.2.7 it was released only for Red Hat, CentOS, and Fedora)
Fedora 26 repositories have been added in this release.
As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.2 for Fedora 24.
Fixes for the following :
MDEV-13318: Crash recovery failure after the server is killed during innodb_encrypt_log startup
MDEV-13488: InnoDB writes CRYPT_INFO even though encryption is not enabled (fixes upgrades from 5.5 to 10.1)
MDEV-13437: InnoDB fails to return error for XA COMMIT or XA ROLLBACK in read-only mode
MDEV-13637: InnoDB change buffer housekeeping can cause redo log overrun and possibly deadlocks
MDEV-13534: InnoDB STATS_PERSISTENT fails to ignore garbage delete-mark flag on node pointer pages (caused by MDEV-12698)
MDEV-13606: XA PREPARE transactions should survive innodb_force_recovery=1 or 2
MDEV-13167: InnoDB key rotation is not skipping unused pages
MDEV-12988: mariadb-backup fails if innodb_undo_tablespaces>0
MDEV-13471: Test failure on innodb.log_file_size,4k (fixes Galera when using innodb_page_size=4k)
MDEV-13684: InnoDB race condition between fil_crypt_thread and btr_scrub_init
MDEV-21069: Crash on DROP TABLE if the data file is corrupted
some cleanup of AIO code, to better report errors
MDEV-12075: Fix a 10.1.21 regression in the InnoDB data file extension code
MDEV-11027: better InnoDB crash recovery progress reporting
MDEV-11520: improvements to how InnoDB data files are extended
Improvements to InnoDB startup/shutdown to make it more robust
MDEV-9734: compatible bintar files now available
MDEV-9658: alpha storage engine added
This is an alpha version of this storage engine with limited functionality at this time
Currently, zlib and snappy compression is supported (only zlib on Windows)
MyRocks is not available for 32-bit platforms
added for Windows, CentOS, RHEL, and Fedora packages
MDEV-12091: Shutdown fails to wait for rollback of recovered transactions to finish
MDEV-12219: Discard temporary undo logs at transaction commit
MDEV-12289: compatibility fix for upgrading from 5.5 or 10.x
MDEV-9255: Two new columns added to the table, providing information about columns.
Fixes for the following :
MDEV-13834 - Upgrade failure from 10.1 innodb_encrypt_log
MDEV-16283 - ALTER TABLE...DISCARD TABLESPACE still takes long on a large buffer pool
MDEV-16376 - ASAN: heap-use-after-free in gcol.innodb_virtual_debug
MDEV-15824 - innodb_defragment=ON trumps innodb_optimize_fulltext_only=ON in OPTIMIZE TABLE
MDEV-16124 - fil_rename_tablespace() times out and crashes server during table-rebuilding ALTER TABLE
MDEV-16416 - Crash on IMPORT TABLESPACE of a ROW_FORMAT=COMPRESSED table
MDEV-16456 - InnoDB error "returned OS error 71" complains about wrong path
MDEV-13103 - Deal with page_compressed page corruption
MDEV-16496 - mariadb-backup: Implement --verbose option to instrument InnoDB log apply
MDEV-16087 - Inconsistent SELECT results when query cache is enabled
MDEV-15114 - ASAN heap-use-after-free in mem_heap_dup or dfield_data_is_binary_equal (fix for indexed virtual columns)
As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.2 for Ubuntu 17.10 Artful
Fixes for the following :
CVE-`-```
FULLTEXT INDEX:
MDEV-19647: Server hangs after dropping full text indexes and restart
MDEV-19529: InnoDB hang on DROP FULLTEXT INDEX
MDEV-19073: FTS row mismatch after crash recovery
: FULLTEXT INDEX activity causes InnoDB hang
MDEV-20927: Duplicate key with auto increment
ALTER TABLE:
MDEV-20799: DROP Virtual Column crash
MDEV-20852: BtrBulk is unnecessarily holding dict_index_t::lock
Galera wsrep library updated to 25.3.28
Fixes for the following :
mariadb-backup fixes: MDEV-18185, MDEV-18201, MDEV-18194
Galera crash recovery fix: MDEV-15740
Encryption fixes: MDEV-18129, MDEV-18183, MDEV-18279
Fixes for the following :
MDEV-14140 IMPORT TABLESPACE must not go beyond FSP_FREE_LIMIT
MDEV-14244 MariaDB 10.2.10 fails to run on Debian Stretch with ext3 and O_DIRECT
MDEV-14219 Allow online table rebuild when encryption or compression parameters change
MDEV-13918: Race condition between and //
MDEV-13838: Wrong result after altering a partitioned table
fixed bugs in InnoDB
MDEV-12676: InnoDB FTS duplicate key error
MDEV-13051: InnoDB crash after failed ADD INDEX and table_definition_cache eviction
MDEV-13446: fts_create_doc_id() unnecessarily allocates 8 bytes for every inserted row
MDEV-13941 Fix high NTFS fragmentation
MDEV-13512 Fix corruption of SPATIAL INDEX in tables
MDEV-14023 10.1 InnoDB tables with virtual columns cannot be accessed in 10.2
MDEV-11336 was enabled
Fixes for the following :
MDEV-12255 - Wrong result with
MDEV-12396 - cleanup
MDEV-14648 - Restore fix for MySQL BUG#39053 - does not allow the storage engine to cleanup open connections
MDEV-15249 - IMPORT fixes
MDEV-14988 - tries to modify files if transactions were recovered in COMMITTED state
MDEV-14773 - hangs for InnoDB table with (fixing a recent regression from upstream)
MDEV-15529 - IMPORT TABLESPACE unnecessarily uses the doublewrite buffer
MDEV-15554 - InnoDB page_cleaner shutdown sometimes hangs
MDEV-14545 - mariadb-backup - Backup fails due to MLOG_INDEX_LOAD record
Fixes for the following :
CVE-`-```
Set the default value of to OFF by default (MDEV-23720)
maximum index size increased from 1000 to 3500 bytes (MDEV-24017)
issue (MDEV-23702)
Temporary tables can no longer overwrite existing files. Instead an error is returned should a conflict occur ()
Binlog checksum verification at recovery time ()
Verbose print-out of by ()
from validates when binlog checksummed ()
Freeing memory of ()
Corrected verbose output for multi-record Rows-log-event ()
no longer causes crash ()
that were running an index condition pushdown in InnoDB will now return an error ()
Wrong direxec param data caused crash; Numerous fixes about Mac builds (by Dmitri Shulga) ()
now logs proxy users ()
Crash on SELECT on a table with indexed virtual columns ()
updated to 5.7.32 ()
Bug fixes related to adaptive hash index (, )
Fixed a bug in the recovery of encrypted tables ()
Fixed a race condition in MVCC reads ()
fixes (, , , )
Fixed a crash with the function ()
Computing certain on a server started with could cause a wrong query result or crash ()
A query with a certain form of WHERE clause over a table with multiple indexes could pick a less efficient range plan ()
Galera wsrep library updated to 25.3.31
Fixed galera got stuck after flush tables (MDEV-22707)
IPv6 SST handling improved (MDEV-21770, MDEV-23576, MDEV-23580, MDEV-23581, MDEV-23574)
Fixed SIGSEGV in lock_rec_unlock (MDEV-23101)
Fixed replication of timezone if only 1 timezone is loaded ()
Fixed replication of ()
Fixed SST FLUSH TABLES WITH READ LOCK timeout ()
As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.2 for CentOS/RHEL 6
Fixes for the following :
()
()
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended for all Galera users due to bug MDEV-12837 which caused serious stability issues with earlier versions. See the bug issue page for more information. When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher, running is required due to changes introduced in MDEV-14637.
For a complete list of changes made in MariaDB 10.2.35 with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.2.35, see the MariaDB Foundation release announcement.
Data type validation:
MDEV-17833: ALTER TABLE is not enforcing prefix index size limit
MDEV-17989: InnoDB: Failing assertion: dict_tf2_is_valid(flags, flags2)
MDEV-17765: Locking bug fix for SPATIAL INDEX
, , : Fixes for FULLTEXT INDEX
Fixes for regressions introduced in MariaDB Server 10.2.19 by the backup-safe TRUNCATE TABLE (, innodb_safe_truncate=ON) and innodb_undo_log_truncate:
, , , ,
Several improvements to MariaDB Server and backup for dealing with encrypted or page_compressed pages:
: corruption in encrypted table may be overlooked
: On little-endian systems, remove bug-compatible variant of innodb_checksum_algorithm=crc32
: Make innodb_checksum_algorithm stricter for strict_* values
The in the repositories has been updated to version 25.3.25
Fixes for the following :
CVE-`-```
When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher, running is required due to changes introduced inMDEV-14637.
For a complete list of changes made in MariaDB 10.2.20 with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.2.20, see the MariaDB Foundation release announcement.
MDEV-15511 - if available, stunnel can be used during
MDEV-15088 - Remove debuginfo files from Windows .zip files and put in optional supplemental .zip file
MDEV-16791 - mariadb-backup: Support DDL commands during backup
MDEV-13564 - Refuse MLOG_TRUNCATE in mariadb-backup
- add new system variable to speed up queries that new long nested IN lists. The default value, for backward compatibility, is 0 meaning "unlimited"./25.
The in the repositories has been updated to version 25.3.24.
MDEV-13333 - errors on InnoDB lock conflict
Report all InnoDB redo log corruption
MDEV-17043 - Purge of indexed virtual columns may cause hang on table-rebuilding DDL
MDEV-16868 - corruption of InnoDB temporary tables
- Invalid (old?) table or database name or hang in ha_innobase::delete_table and log semaphore wait upon concurrent DDL with foreign keys
- Assertion srv_undo_sources || ... failed on slow shutdown
- wsrep_sst_rsync does not support innodb_data_home_dir
MDEV-16557 - Remove INNOBASE_SHARE
MDEV-16136 - Simplify trx_lock_t memory management
Fixes for the following :
When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher, running is required due to changes introduced inMDEV-14637.
For a complete list of changes made in MariaDB 10.2.18 with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.2.18, see the MariaDB Foundation release announcement.
New variable for avoiding delay due to page flushing and allowing concurrent backup
New variable, for specifying whether to write a core file on crash.
updated to 5.7.23
ALTER TABLE fixes:
- Fix hang due to DDL with FOREIGN KEY or persistent statistics
- Alter InnoDB Partitioned Table Moves Files (which were originally not in the datadir) to the datadir
- InnoDB: Failing assertion: ++retries < 10000 in file dict0dict.cc line 2737
- Allow full redo logging for ALTER TABLE
Temporary tables: - InnoDB hang with repeating log entry
- Windows - redo log does not work on native 4K sector disks
indexed virtual columns: - Deadlock between purge thread and DDL statement
locking: - Change the default to innodb_lock_schedule_algorithm=fcfs
Galera: - WSREP: BF lock wait long for trx
Packages and a repository for openSUSE 15 have been added with this release, visit the for instructions on adding the repository
Fixes for the following :
When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher, running is required due to changes introduced inMDEV-14637.
For a complete list of changes made in MariaDB 10.2.17 with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.2.17, see the MariaDB Foundation release announcement.
MDEV-21337: fix aligned_malloc()
MDEV-21343: Threadpool/Unix- wait_begin() function does not wake/create threa ds, when it should
MDEV-21255: Deadlock of parallel slave and mariadb-backup (with failed log copy thread)
MDEV-20950: Reduce size of record offsets
MDEV-19176: Reduce the memory usage during recovery
MDEV-21429: TRUNCATE and OPTIMIZE are being refused due to "row size too large"
MDEV-21500: Server hang when using simulated AIO
: Possible hang during purge of history, or rollback
: Wrong estimate of affected BLOB columns in update
: InnoDB may hang due to SPATIAL INDEX
: Avoid some crashes in ALTER TABLE...IMPORT TABLESPACE
MDEV-14183: aria_pack segfaults in compress_maria_file
MDEV-21318: Wrong results with window functions and implicit grouping
MDEV-16579: Wrong result of query using DISTINCT COUNT() OVER ()
MDEV-18046: Crashes caused by random values to the offset option of SHOW BINLOG EVENT offset command
MDEV-19376: Semisync Master could crash when it executed RESET MASTER and a replica reconnects using GTID protocol
Fixes for the following :
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended for all Galera users due to bug MDEV-12837 which caused serious stability issues with earlier versions. See the bug issue page for more information. When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher, running is required due to changes introduced in MDEV-14637.
For a complete list of changes made in MariaDB 10.2.31 with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.2.31, see the MariaDB Foundation release announcement.
MDEV-13992: and
MDEV-19490: show tables fails when selecting the information_schema database
MDEV-19491: multi-update with triggers and stored routines
MDEV-19509: InnoDB skips the tablespace in rotation list
: SET GLOBAL innodb_ deadlock due to LOCK_global_system_variables
: Malicious SUPER user can possibly change audit log configuration without leaving traces
: Wrong results from query, using left join
: RIGHT JOIN hangs in MariaDB
ALTER TABLE fixes: ,
FULLTEXT INDEX fixes: ,
Virtual columns: , ,
Crash recovery fixes: , , ,
: Fixed row-based event applying with an error anymore when the events aim at the blackhole engine and row annotation is enabled
: Fixed slave_parallel_mode=optimistic did not always properly order replication events on temporary tables in some case to attempt execution before a parent event has been already processed
: Fixed duplicated entries in binlog occurred in combination of LOCK TABLES and binlog_format=MIXED when a being locked table was under replication unsafe operation
As per the , this will be the last release of for OpenSUSE 42.3
Fixes for the following :
CVE-`-```
When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher, running is required due to changes introduced inMDEV-14637.
For a complete list of changes made in MariaDB 10.2.25 with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.2.25, see the MariaDB Foundation release announcement.
This is the second beta release in the MariaDB 10.2 series.
updated to 9.4
Galera wsrep library updated to 25.3.19
Packages for Debian 9 "stretch" amd64 and x86 and Debian 8 "jessie" ppc64el added
Fix for FULLTEXT index crash (MDEV-11233).
New variable permits restricting the speed at which the slave reads the binlog from the master (MDEV-11064) — Tencent Game DBA Team, developed by chouryzhou.
is supported (MDEV-7145)
is supported (MDEV-11065) — Tencent Game DBA Team, developed by vinchen.
added (MDEV-9143).
Oracle-style statement (MDEV-10585).
/Dynamic SQL now understand most expressions (MDEV-10866, MDEV-10709).
Multiple per table (MDEV-6112)
The FOLLOWS/PRECEDES clauses have been added to the statement.
Multiple triggers are now counted in the Executed_triggers status variable (MDEV-10915).
and now include the date and time the trigger was created.
Fixes for the following :
CVE-`-```
Do not use beta releases on production systems!
For a complete list of changes made in MariaDB 10.2.3, with links to detailed information on each push, see the changelog.
The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now
Download | Release Notes | Changelog | Overview of 10.2
Release date: 13 Feb 2018
MariaDB 10.2 is the current stable series of MariaDB. It is an evolution of MariaDB 10.1 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
MariaDB 10.2.13 is a Stable (GA) release.
For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.
Upgrading from earlier 10.2.x versions is highly recommended for all Galera users due to bug MDEV-12837 which caused serious stability issues with earlier versions. See the bug issue page for more information.
Thanks, and enjoy MariaDB!
updated to 5.7.21
The storage engine is now Beta.
updated to 25.3.23
- ALTER TABLE EXCHANGE PARTITION does not work properly when used with DATA DIRECTORY
Fixes for the following :
For a complete list of changes made in with links to detailed information on each push, see the .
The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now
Download | Release Notes | Changelog | Overview of 10.2
Release date: 17 May 2018
MariaDB 10.2 is the current stable series of MariaDB. It is an evolution of MariaDB 10.1 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
MariaDB 10.2.15 is a Stable (GA) release.
For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.
Thanks, and enjoy MariaDB!
updated to 5.7.22
updated to 8.42
The embedded server library now supports SSL when connecting to remote servers
- Incomplete validation of missing tablespace during recovery
For a complete list of changes made in with links to detailed information on each push, see the .
For a full list of contributors to , see the .
The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now
Download | Release Notes | Changelog | Overview of 10.2
Release date: 13 Nov 2018
MariaDB 10.2 is the previous stable series of MariaDB. It is an evolution of MariaDB 10.1 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
MariaDB 10.2.19 will be a Stable (GA) release.
For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.
Upgrading from earlier 10.2.x versions is highly recommended for all Galera users due to bug MDEV-12837 which caused serious stability issues with earlier versions. See the bug issue page for more information.
Thanks, and enjoy MariaDB!
system variable for a backup-safe TRUNCATE TABLE implementation that is based on RENAME, CREATE, DROP (, , )
Default value for this variable is ON
If you absolutely must use instead of , you can set it to OFF and restart the server.
When upgrading from or earlier to or higher, running is required due to changes introduced in.
For a complete list of changes made in with links to detailed information on each push, see the .
For a full list of contributors to , see the .
The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now
Download | Release Notes | Changelog | Overview of 10.2
Release date: 12 Jul 2017
MariaDB 10.2 is the current stable series of MariaDB. It is an evolution of MariaDB 10.1 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
MariaDB 10.2.7 is a Stable (GA) release.
For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.
This is the second stable release in the series.
A file format compatibility bug that was introduced in was fixed in this version of MariaDB. Creating tables with the attribute created InnoDB internal data dictionary records that are incompatible with . and later will write the dictionary records in a format that is compatible with and will also support the malformed metadata from affected 10.2 versions.This may prevent a downgrade to earlier versions.
The (an alias for LONGTEXT) was introduced.
updated to 5.7.18
updated to 5.6.36-82.0
beta now included for Red Hat, CentOS, and Fedora packages. See for an important note about restoring with this version.
For a complete list of changes made in , with links to detailed information on each push, see the .
The most recent release of is: Stable (GA)
| | |
Release date: 31 Jul 2019
is a previous stable series of MariaDB. It is an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release.
For an overview of see the page.
Thanks, and enjoy MariaDB!
The most recent release of is: Stable (GA)
| | |
Release date: 23 May 2017
is the current stable series of MariaDB. It is an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release.
For an overview of see the page.
Thanks, and enjoy MariaDB!
The most recent release of is: Stable (GA)
| | |
Release date: 25 Mar 2019
is the previous stable series of MariaDB. It is an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
will be a release.
For an overview of see the page.
Upgrading from earlier 10.2.x versions is highly recommended for allGalera users due to bug which caused serious stability issues with earlier versions. See the bug issue page for more information.
The most recent release of is: Stable (GA)
| | |
Release date: 4 Jul 2016
is the current development series of MariaDB. It is an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
is an release.
Do not use Alpha releases on production systems!
For an overview of see the page.
Thanks, and enjoy MariaDB!
The most recent release of is: Stable (GA)
| | |
Release date: 27 Sep 2016
is the current development series of MariaDB. It is an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release.
Do not use beta releases on production systems!
For an overview of see the page.
Thanks, and enjoy MariaDB!
The most recent release of is: Stable (GA)
| | |
Release date: 4 Jan 2018
is the current stable series of MariaDB. It is an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release.
For an overview of see the page.
Upgrading from earlier 10.2.x versions is highly recommended for all Galera users due to bug which caused serious stability issues with earlier versions. See the bug issue page for more information.
MDEV-18025: mariadb-backup fails to detect corrupted page_compressed=1 tables
MDEV-15249 - Crash in MVCC read after IMPORT TABLESPACE
Foreign key bugs:
MDEV-15199 - Referential integrity broken in ON DELETE CASCADE / MDEV-14222 Unnecessary 'cascade' memory allocation for every updated row
MDEV-15219 - FOREIGN KEY CASCADE or SET NULL operations will not resume after lock wait
MDEV-15042 - INSERT ON DUPLICATE KEY UPDATE produces error 1032 (Can't find record)
- InnoDB: Failing assertion: !dict_index_is_online_ddl(index) upon ALTER TABLE
MDEV-14958 - Merge new release of InnoDB MySQL 5.7.21 to 10.2
MDEV-15165 - InnoDB purge for index on virtual column is trying to access an incomplete record
MDEV-15143 - InnoDB: Rollback of trx with id 0 completed
MDEV-11415 - Remove excessive undo logging during
MDEV-15016 - multiple page cleaner threads use a lot of CPU
MDEV-14941 - Timeouts on persistent statistics tables caused by MDEV-14511
MDEV-14985 - innodb_undo_log_truncate may be blocked if transactions were recovered at startup
MDEV-14441 - InnoDB hangs when setting innodb_adaptive_hash_index=OFF during UPDATE
MDEV-14887 - On a 32-bit system, MariaDB 10.2 mishandles data file sizes exceeding 4GiB
Fedora 27 packages added
As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.2 for Fedora 25
MDEV-15720 - ib_buffer_pool unnecessarily includes the temporary tablespace
MDEV-15764 - InnoDB may write uninitialized garbage to redo log
MDEV-15553 - Virtual Columns: Assertion failed in dict_table_get_col_name
MDEV-14705 - slow innodb startup/shutdown can exceed systemd timeout
MDEV-15707 - deadlock in Innodb IO code, caused by change buffering (Windows)
MDEV-15507 - Assertion failed in dict_check_sys_tables on upgrade from 5.5
MDEV-15916 - Change buffer crash during TRUNCATE or DROP TABLE
encryption fixes - MDEV-12632, MDEV-13516, MDEV-15752, MDEV-15566, MDEV-16092
temporary table ROLLBACK fixes - MDEV-15826, MDEV-15374
applicable changes from 5.7.22 - MDEV-16142
Ubuntu 18.04 "bionic" and Fedora 28 packages and repositories are being introduced in this release. See the MariaDB Repository Configuration Tool for instructions on setting up these repositories.
As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.2 for Debian 7 Wheezy and Fedora 26
Fixes for the following :
MDEV-17289: Multi-pass recovery fails to apply some redo log records
MDEV-17073: INSERT…ON DUPLICATE KEY UPDATE became more deadlock-prone
MDEV-17491: micro optimize page_id_t
MDEV-13671: InnoDB should use case-insensitive column name comparisons like the rest of the server
Fixes for indexed virtual columns: MDEV-17215, MDEV-16980
MDEV-17433: Allow InnoDB start up with empty ib_logfile0 from mariadb-backup --prepare
MDEV-12547: InnoDB FULLTEXT index has too strict innodb_ft_result_cache_limit max limit
MDEV-17541: KILL QUERY during lock wait in FOREIGN KEY check causes hang
MDEV-17531: Crash in RENAME TABLE with FOREIGN KEY and FULLTEXT INDEX
MDEV-17532: Performance_schema reports wrong directory for the temporary
files of ALTER TABLE…ALGORITHM=INPLACE
MDEV-17545: Predicate lock for SPATIAL INDEX should lock non-matching record
MDEV-17546: SPATIAL INDEX should not be allowed for FOREIGN KEY
MDEV-17548: Incorrect access to off-page column for indexed virtual column
MDEV-12023: Assertion failure sym_node->table != NULL on startup
MDEV-17230: encryption_key_id from alter is ignored by encryption threads
As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.2 for Fedora 27
Fixes for the following :
MDEV-13125: Core dumps can now be enabled dynamically
MDEV-13132: Literals in the COLUMN_DEFAULT column in the table are now quoted to distinguish them from expressions.
New variables:
As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.2 for Ubuntu 16.10 "Yakkety"
Fixes for the following :
CVE-`-```
MDEV-19922: updated to 10.2
MDEV-19795: Merge upstream .
MDEV-17228: Encrypted temporary tables are not encrypted.
MDEV-18328: is now stable and requires the .
Merge relevant InnoDB changes from MySQL 5.7.27
: When the ctas from a big table is interrupted ,then you can't drop or recreate the table
: InnoDB's row size calculations were fixed, which might result in "Row size too large" errors when creating or altering tables with lots columns. This can occur even if previous MariaDB releases did not throw errors for the same tables. Some workarounds are listed at .
ALTER TABLE:
Indexed virtual columns: ,
FULLTEXT INDEX:
Encryption: ,
Galera + FOREIGN KEY:
Recovery & mariadb-backup:
: Add page id matching check in innochecksum tool
: DROP TEMPORARY table is logged despite no CREATE was logged
: Basic 3-way join queries are not parsed - parsing problem of joins fixed
: mysql_upgrade_service throws exception upgrading from 10.0 to 10.3
: loading the audit plugin causes performance regression
: REPLACE on table with virtual_field can cause crash
: fix Aria ER_CRASHED_ON_USAGE and Assertion
: Make DISKS plugin check some privilege to access information_schema.DISKS table
As per the , this will be the last release of for Ubuntu 18.10 "Cosmic"
Fixes for the following :
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended for all Galera users due to bug MDEV-12837 which caused serious stability issues with earlier versions. See the bug issue page for more information. When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher, running is required due to changes introduced in MDEV-14637.
For a complete list of changes made in MariaDB 10.2.26 with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.2.26, see the MariaDB Foundation release announcement.
This is the first stable release in the MariaDB 10.2 series. As such, please refer to the What is MariaDB 10.2? page for details on all of the new features.
alpha storage engine added (MDEV-9658)
have been introduced.
Recursive Common Table Expressions (MDEV-9864)
added for Windows, CentOS, RHEL, and Fedora packages
Update InnoDB to 5.7.18 ()
updated to 25.3.20
Packages for Ubuntu 17.04 "zesty"
: The --add-drop-trigger option has been added to
: Ignore XtraDB-specific parameters in InnoDB, warning that they are ignored
, : Numerous Encryption fixes
: Disabled defragmentation
: Added support for OpenSSL 1.1 and LibreSSL
and variables introduced
: columns are no longer permitted in , and . They were permitted in earlier versions, but did not work correctly.
Fixes for the following :
(as of 2.4) will not work with MariaDB 10.2 (and MariaDB 10.1) compression. However, MariaDB's fork, mariadb-backup, will work with compression. A beta version of mariadb-backup was included in MariaDB 10.2.7 and declared stable in MariaDB 10.2.10.
A file format compatibility bug that was introduced in MariaDB 10.2.2 was present in this release. Creating tables with the attribute created InnoDB internal data dictionary records that are incompatible with MariaDB 10.1. MariaDB 10.2.7 and later will write the dictionary records in a format that is compatible with MariaDB 10.1 and will also support the malformed metadata from affected 10.2 versions.This bug may prevent a downgrade from later MariaDB 10.2 versions to MariaDB 10.2.6.See the commit for details.
For a complete list of changes made in MariaDB 10.2.6, with links to detailed information on each push, see the changelog.
InnoDB ALTER TABLE fixes: MDEV-18016, MDEV-18630, MDEV-18775, MDEV-18732,MDEV-18749, MDEV-18637, MDEV-13818, MDEV-17595
Performance improvements:
MDEV-18878: InnoDB Purge: Optimize away futile table lookups
: Regression in connect performance
: Purge thread fails to exit on shutdown
Corruption bug fixes:
: InnoDB fails to rollback after exceeding FOREIGN KEY recursion depth
: Data corruption on Galera cluster size change
:
: fix incremental MyRocks backup
: mariadb-backup terminated while copying InnoDB redo log
: mariadb-backup writes timestamp in version line
Debug symbols on CentOS 7, RHEL 7, and SLES 12 distributions have been moved
into debuginfo packages ()
The in the repositories has been updated to version 25.3.26
As per the , this will be the last release of for Ubuntu 14.04 Trusty, Debian has also stopped supporting the ppc64el architecture for Debian 8 Jessie and so this is the last release of on Jessie for that architecture
Fixes for the following :
CVE-`-```
When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher, running is required due to changes introduced inMDEV-14637.
For a complete list of changes made in MariaDB 10.2.23 with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.2.23, see the MariaDB Foundation release announcement.
This is the second alpha release in the MariaDB 10.2 series.
Common Table Expressions -
Support for (MDEV-7563).
Support for (MDEV-10134).
fields can now have a value.
Lots of restrictions lifted for .
Views now support subqueries in the FROM clause ()
Number of supported decimals in has increased from 30 to 38. ()
Optimizations for faster connection creation time.
New variable for setting a directory for storing temporary non-tablespace InnoDB files, .
Temporary tables can be referred to many times in the same query ()
Various other optimizations and refactorings
updated to 5.6.30-76.3
updated to 5.6.31
updated to 5.6.31
updated to 8.39
updated to 5.6.30-76.3
updated to 9.3
Various packages and bintar builds for POWER8 ppc64 and ppc64le architectures now available
The default value of the system variable is nowCRC32.
As per the , this will be the last release of for Ubuntu 15.10 "wily"
Do not use Alpha releases on production systems!
For a complete list of changes made in MariaDB 10.2.1, with links to detailed information on each push, see the changelog.
This is the first beta release in the MariaDB 10.2 series.
was merged from MySQL-5.7.14 (XtraDB is disabled in MariaDB-10.2.2 pending a similar merge)
Note that there have been numerous variable changes, both new variables and changes to defaults, for example now defaults to ON.
InnoDB tables now support .
has been re-implemented so as not to lock the entire table when collecting engine independent statistics ()
The CONNECT engine now supports the ()
Internal CRC32 routines use the optimized implementation on Power8 —
Old GPL client library is gone; now MariaDB Server comes with the LGPL Connector/C client library ()
Recursive Common Table Expressions ()
Further improvements and bugfixing for CHECK CONSTRAINT () and DEFAULT with expressions ()
Optimizer improvement: conditions can be ()
Support for NO PAD , with 88 new NO PAD collations included in the server ()
Table cache can automatically partition itself as needed to reduce the contention ()
The thread pool now gives higher priority to connections that have an active transaction. This can be controlled with the new and system variables. ()
Window functions support extended. All standard aggregate functions (except GROUP_CONCAT) can be used as window functions. ()
New added: , , , , . ()
Performance improvements for faster computing of window functions. Multiple window functions with compatible sorting criteria are computed during the same pass. ()
Default changed from 0 to 1.
New options.
Fixes for the following :
CVE-`-```
Do not use beta releases on production systems!
For a complete list of changes made in MariaDB 10.2.2, with links to detailed information on each push, see the changelog.
MDEV-12837 - WSREP: BF lock wait long
MDEV-14799 - After UPDATE of indexed columns, old values will not be purged from secondary indexes
MDEV-12827 - Assertion failure when reporting duplicate key error in online table rebuild
MDEV-14008 - Failure reading auto-increment values in DOUBLE column from storage engine
- Rollback progress log messages during crash recovery are intermixed with unrelated log messages
- InnoDB shutdown should not be blocked by a large transaction rollback
- InnoDB may hang if shutdown is initiated soon after startup while rolling back recovered incomplete transactions
- Assertion failure in trx_purge_run() on shutdown
- InnoDB should not lock a delete-marked record
/ / - data corruption caused by error log messages ending up in database files or binary logs
- Use fewer transactions for updating InnoDB persistent statistics
/ - Error log flood : "InnoDB: page_cleaner: 1000ms intended loop took N ms. The settings might not be optimal."
: - during backup, retry read of log blocks, if there is (possibly intermittent) checksum mismatch
As per the , this will be the last release of for Ubuntu 17.04 "Zesty".
The WINDOW is now only disallowed for table aliases.
Fixes for the following :
For a complete list of changes made in MariaDB 10.2.12 with links to detailed information on each push, see the changelog.
The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now
Download | Release Notes | Changelog | Overview of 10.2
Release date: 9 May 2019
MariaDB 10.2 is the previous stable series of MariaDB. It is an evolution of MariaDB 10.1 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
MariaDB 10.2.24 is a Stable (GA) release.
For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.
Upgrading from earlier 10.2.x versions is highly recommended for allGalera users due to bug MDEV-12837 which caused serious stability issues with earlier versions. See the bug issue page for more information.
Thanks, and enjoy MariaDB!
- Both (WHERE 0.1) and (WHERE NOT 0.1) return empty set
- Unsafe to log updates on tables referenced by foreign keys with triggers in statement format
- Server crashes in Field::set_warning_truncated_wrong_value
Merge InnoDB changes from MySQL 5.6.44 and 5.7.26
InnoDB persistent corruption fixes: , , ,
InnoDB recovery fixes and speedup: , , ,
- innodb_encrypt_tables will work even with innodb_encryption_rotate_key_age=0
- BULK with replace doesn't take the first parameter in account
- Slave crashes in show_status_array upon running a trigger with select from I_S
- mariadb-backup continues, despite failing to open a tablespace
- mysql_upgrade_service now allows MySQL 5.7 to upgrade
Starting with this release, we are now providing for ()
As per the , this will be the last release of for Fedora 28
- Add option to PAM authentication plugin to allow case insensitive username matching
bugfix - multi-update checked privileges on views incorrectly (commit 5057d4637525eadad438d25ee6a4870a4e6b384c)
- during connect, write error log warning for ER_DBACCESS_DENIED_ERROR, if log_warnings > 1
When upgrading from or earlier to or higher, running is required due to changes introduced in.
For a complete list of changes made in with links to detailed information on each push, see the .
For a full list of contributors to , see the .
The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now
Download | Release Notes | Changelog | Overview of 10.2
Release date: 17 Feb 2017
MariaDB 10.2 is the current development series of MariaDB. It is an evolution of MariaDB 10.1 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
MariaDB 10.2.4 is a Release Candidate (RC) release.
For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.
Thanks, and enjoy MariaDB!
This is the first release candidate (RC) release in the series.
New : ROWS. This can no longer be used as an without being quoted.
Default changed to mixed ().
Default values of and changed to ON ()..
For a complete list of changes made in , with links to detailed information on each push, see the .
MDEV-18855: mariadb-backup should fetch innodb_compression_level from running server
MDEV-18298 - Crashes server with segfault during role grants
MDEV-17610 - Unexpected connection abort after certain operations from within stored procedure
MDEV-19112 - WITH clause does not work with information_schema as default database
MDEV-17830 - Server crashes in Item_null_result::field_type upon SELECT with CHARSET(date) and ROLLUP
MDEV-14041 - Server crashes in String::length on queries with functions and ROLLUP
MDEV-18920 - Prepared statements with st_convexhull hang and eat 100% cpu.
MDEV-15837 - Assertion item1->type() == Item::FIELD_ITEM && item2->type() == Item::FIELD_ITEM
MDEV-9531 - GROUP_CONCAT with ORDER BY inside takes a lot of memory while it's executed
MDEV-17036 - BULK with replace doesn't take the first parameter in account
Bug#28986737 - RENAMING AND REPLACING MYSQL.USER TABLE CAN LEAD TO A SERVER CRASH
MDEV-19350 - Server crashes in delete_tree_element / ... / Item_func_group_concat::repack_tree
MDEV-19188 - Server Crash When Using a Trigger With A Number of Virtual Columns on INSERT/UPDATE
MDEV-19352 - Server crash in alloc_histograms_for_table_share upon query from information schema
Fixes for the following :
Default value of changed to 1M (MDEV-7635).
Default value of changed to zlib - this does not mean pages are now compressed by default, see (MDEV-11838).
Default value of changed to ON (MDEV-7635).
Default value of and changed to ON.
The unused variables have been removed (MDEV-12050).
Numerous other system variable changes.
DML_only can rollback instances/databases/tables to an old snapshot (MDEV-10570).
Implement and functions so the spatial features can be imported/exported using GeoJSON format (MDEV-11042).
for the CONNECT storage engine (MDEV-11295).
Persistent for InnoDB (MDEV-6076).
Default values of the and system variables changed to BACKUP,QUICK.
Support COM_RESET_CONNECTION (MDEV-10340).
can now be set to 1 (MDEV-12061).
MariaDB now works when started with a MySQL 5.7.6+ data directory. (MDEV-11170)
OpenSUSE 42 repositories have been added in this release.
As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.2 for Ubuntu 12.04 "precise", Fedora 23, and openSUSE 13
CVE-`-```
The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now
Download | Release Notes | Changelog | Overview of 10.2
Release date: 18 Apr 2016
MariaDB 10.2 is the current development series of MariaDB. It is an evolution of MariaDB 10.1 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
MariaDB 10.2.0 is an Alpha release.
Do not use alpha releases on production systems!
For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.
Thanks, and enjoy MariaDB!
This is the first alpha release in the series.
Notable changes of this release include:
Syntax:
have been introduced. This release adds support for a limited set of functions, and the basic execution algorithm. Development continues to expand the set of supported functions and optimize the execution.
The statement was introduced.
New options for limiting resource usage and tls/ssl.
New statement.
Scripts:
Continuous binary log backup has been added to - .
and mysqlbug have been removed - , .
Information Schema:
Added an information schema plugin to report all user variables, which creates the - .
Variables:
has been renamed to - .
The server version can now be faked to work around dated applications that require a particular version string -
is now an alias for slave_parallel_threads.
New status variables , and .
EXPLAIN:
now shows outer_ref_condition field which contains the condition that the(?) SELECT checks on each re-execution - .
now shows sort_key field which shows the sort criteria used by filesort operation. ()
EXPLAIN used to show incorrect information about how the optimizer resolved ORDER BY
Optimizations:
Connection setup was made faster by moving creation of THD to new thread ()
Code:
"fast mutexes" have been removed. These aren't faster than normal mutexes, and have been disabled by default for years - .
Do not use alpha releases on production systems!
Repositories exist for 10.2, but because 10.2 is still alpha, it is not visible in the . To configure a 10.2 apt, yum, or zypper repository using the tool, simply select 10.1 and then when executing the instructions, change all occurrences of '10.1' to '10.2'.
- APT 1.2.7 (and later) prefers SHA2 GPG keys and now prints warnings when a repository is signed using a SHA1 key. We have created a new SHA2 key for use with our Debian "sid" repository. When we add an Ubuntu 16.04 "xenial" repository, it will also use this new key.
The Key ID is: C74CD1D8
For a complete list of changes made in , with links to detailed information on each push, see the .
The most recent release of is: Stable (GA)
Note that this version contains an issue that disabled all events created by a server with a different server_id. See for details.
| | |
Release date: 8 Nov 2019
is a previous stable series of MariaDB. It is an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release.
For an overview of see the page.
Thanks, and enjoy MariaDB!
New : OVER and RECURSIVE. These can no longer be used as without being quoted.
DistinctThe full fingerprint of the new key is: 177F 4010 FE56 CA33 3630 0305 F165 6F24 C74C D1D8
The key can be added using the following command:
MDEV-20987: InnoDB fails to start when FTS table has FK relation
See also the release notes for MariaDB 10.2.28 for additional items of note
Fixes for the following :
CVE-`-```
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended for all Galera users due to bug MDEV-12837 which caused serious stability issues with earlier versions. See the bug issue page for more information. When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher, running is required due to changes introduced in MDEV-14637.
For a complete list of changes made in MariaDB 10.2.29 with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.2.29, see the MariaDB Foundation release announcement.
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8MariaDB 10.2 is no longer maintained. Please use a more recent release.
The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now
MariaDB 10.2 is a previous major stable version. The first stable release was in May 2017.
For details on upgrading from MariaDB 10.1, see .
The following lists the major new features in MariaDB 10.2:
is now the default storage engine. Until , MariaDB used the XtraDB storage engine as default. XtraDB in 10.2 is not up to date with the latest features of InnoDB and cannot be used. As the InnoDB on disk format is identical to XtraDB's this will not cause any problems when upgrading to . See
storage engine added. (It has its own . In , it is considered Gamma) ()
have been introduced.
The statement was introduced
New options for limiting resource usage and tls/ssl
has been split into a separate package, mariadb-plugin-tokudb.
has been changed; in particular, NOT NULL fields with no default will no longer fall back to a dummy value for inserts which do not specify a value for that field.
Replication from legacy MySQL servers may require setting to NONE.
New : OVER, RECURSIVE, and ROWS.
Multiple for the same event ()
The FOLLOWS/PRECEDES clauses have been added to the statement
Multiple triggers are now counted in the Executed_triggers status variable ()
and now include the date and time the trigger was created
DML_only can rollback instances/databases/tables to an old snapshot ()
New variable permits restricting the speed at which the slave reads the binlog from the master () — Original code from Tencent Game DBA Team, developed by chouryzhou.
is supported () — Backported from MySQL 5.6 by Kristian Nielsen funded by Booking.com.
The (an alias for LONGTEXT) was introduced.
added ()
Implement and functions so the spatial features can be imported/exported using GeoJSON format ()
An information schema plugin to report all user variables, which creates the ()
Changes to the table. Literals are now quoted in the COLUMN_DEFAULT column to distinguish them from expressions (), and two new columns added providing information about columns ().
now shows outer_ref_condition field which contains the condition that the(?) SELECT checks on each re-execution ()
now shows sort_key field which shows the sort criteria used by filesort operation. ()
EXPLAIN used to show incorrect information about how the optimizer resolved ORDER BY
Connection setup was made faster by moving creation of THD to new thread ()
Pushdown conditions into non-mergeable views/derived tables (, ) — Original code from Galina Shalygina
has been re-implemented so as not to lock the entire table when collecting engine independent statistics ()
Internal CRC32 routines use the optimized implementation on Power8 —
88 new added. In NO PAD collations, end spaces are significant in comparisons () — Original code from Daniil Medvedev
MariaDB now works when started with a MySQL 5.7.6+ data directory ()
for the CONNECT storage engine ()
The CONNECT engine now supports the ()
For a list of all new system variables, see . Variable changes include:
New variable to disable deadlock detection
has been renamed to ()
Default values of the and system variables changed to BACKUP,QUICK
The server version can now be faked to work around dated applications that require a particular
For a list of all new status variables, see .
Continuous binary log backup has been added to ()
and mysqlbug have been removed (, )
Added support for OpenSSL 1.1 and LibreSSL ()
Persistent for InnoDB ()
Support COM_RESET_CONNECTION ()
"fast mutexes" have been removed. These aren't faster than normal mutexes, and have been disabled by default for years ()
For a complete list of security vulnerabilities (CVEs) fixed across all versions of MariaDB, see the page.
:
:
:
:
Plans for 10.x for features under consideration for features under consideration
New statement
Support for (MDEV-7563)
Support for (MDEV-10134)
fields can now have a value
Lots of restrictions lifted for
Number of supported decimals in has increased from 30 to 38 (MDEV-10138)
Added catchall for list partitions (MDEV-8348)
Oracle-style statement (MDEV-10585)
/Dynamic SQL now understand most expressions (MDEV-10866, MDEV-10709).
InnoDB tables now support
Better InnoDB crash recovery progress reporting (MDEV-11027)
Improvements to InnoDB startup/shutdown to make it more robust
added for Windows, CentOS, RHEL, and Fedora packages
. Shannon system SSD cards are now supported.
Default changed to mixed (MDEV-7635)
Default value of changed to ON (MDEV-7635)
Default value of reduced to 60 seconds (MDEV-7635)
Default changed from 0 to 1
DistinctTable cache can automatically partition itself as needed to reduce the contention (MDEV-10296)
is now an alias for slave_parallel_threads
New status variables , and
New variable for setting a directory for storing temporary non-tablespace InnoDB files,
New variable permits restricting the speed at which the slave reads the binlog from the master (MDEV-11064)
can now be set to 1 (MDEV-12061)
The thread pool now gives higher priority to connections that have an active transaction. This can be controlled with the new and system variables. (MDEV-10297)
Default value of changed to 1M (MDEV-7635)
Default value of changed to STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION (MDEV-7635) (MariaDB 10.2.4 and later)
Default value of changed to zlib - this does not mean pages are now compressed by default, see (MDEV-11838)
Default value of changed to ON from MariaDB 10.1.2 to MariaDB 10.1.25 (MDEV-7635 and MDEV-13247)
Default value of and changed to ON
The unused variables have been removed (MDEV-12050)
was added to allow one to limit the size of temporary disk tables stored in tmpdir. At the same time was added an alias for . At some point we plan to deprecate tmp_table_size. (MariaDB 10.2.7 and later).
Old GPL client library is gone; now MariaDB Server comes with the LGPL Connector/C client library (MDEV-9055)
MariaDB is no longer compiled with jemalloc
TokuDB is now a separate package, not part of the server RPM (because TokuDB still needs jemalloc).
Upgrading to a new major release no longer requires setting to 0. Omitting it can make the upgrade process a lot faster. (MDEV-12289)
Stable (GA)
8 Nov 2021
Stable (GA)
6 Aug 2021
Stable (GA)
23 Jun 2021
Stable (GA)
7 May 2021
Stable (GA)
22 Feb 2021
Stable (GA)
11 Nov 2020
Stable (GA)
3 Nov 2020
Stable (GA)
7 Oct 2020
Stable (GA)
10 Aug 2020
Stable (GA)
12 May 2020
Stable (GA)
28 Jan 2020
Stable (GA)
11 Dec 2019
Stable (GA)
8 Nov 2019
Stable (GA)
5 Nov 2019
Stable (GA)
11 Sep 2019
Stable (GA)
31 Jul 2019
Stable (GA)
17 Jun 2019
Stable (GA)
9 May 2019
Stable (GA)
25 Mar 2019
Stable (GA)
11 Feb 2019
Stable (GA)
2 Jan 2019
Stable (GA)
24 Dec 2018
Stable (GA)
19 Nov 2018
Stable (GA)
25 Sep 2018
Stable (GA)
14 Aug 2018
Stable (GA)
26 Jun 2018
Stable (GA)
17 May 2018
Stable (GA)
27 Mar 2018
Stable (GA)
13 Feb 2018
Stable (GA)
4 Jan 2018
Stable (GA)
28 Nov 2017
Stable (GA)
31 Oct 2017
Stable (GA)
27 Sep 2017
Stable (GA)
18 Aug 2017
Stable (GA)
12 Jul 2017
Stable (GA)
23 May 2017
Stable (GA)
5 Apr 2017
RC
17 Feb 2017
RC
24 Dec 2016
Beta
27 Sep 2016
Beta
4 Jul 2016
Alpha
18 Apr 2016
Alpha
20 May 2022
Stable (GA)
12 Feb 2022
Stable (GA)
9 Feb 2022
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL