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.3 was a long-term maintenance series of MariaDB maintained until May 2023
Download | Release Notes | Changelog | Overview of 10.3
Release date: 10 May 2023
MariaDB 10.3 is the previous stable series of MariaDB, supported until May 2023, and an evolution of MariaDB 10.2 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
MariaDB 10.3.39 is a Stable (GA) release.
MariaDB 10.3.39 is the last release of the MariaDB 10.3 release series.
For an overview of MariaDB Server 10.3 see the What is MariaDB 10.3? page.
Thanks, and enjoy MariaDB!
As per the , this will be the final release of
Fixed a deadlock on parallel slave involving full image Write event on the sequence engine ()
Add replication setup to containers contributed by Md Sahil ()
When upgrading from or earlier to or higher, running is required due to changes introduced in.
Fixes for the following :
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: 12 Feb 2022
is the previous stable series of MariaDB, and an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
is a release.
For an overview of MariaDB Server 10.3 see the page.
Thanks, and enjoy MariaDB!
This release fixes a blocking problem with the MariaDB 10.3.33 release when manually running . (MDEV-27789)
See MariaDB 10.3.33 for other changes since the previous release.
Fixes for the following :
When upgrading from MariaDB 10.3.8 or earlier to MariaDB 10.3.9 or higher, running is required due to changes introduced inMDEV-14637.
For a complete list of changes made in MariaDB 10.3.34, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.3.34, see the MariaDB Foundation release announcement.
Download | Release Notes | Changelog | Overview of 10.3
Release date: 6 Feb 2023
MariaDB 10.3 is the previous stable series of MariaDB, supported until May 2023, and an evolution of MariaDB 10.2 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
MariaDB 10.3.38 is a Stable (GA) release.
For an overview of MariaDB Server 10.3 see the What is MariaDB 10.3? page.
Thanks, and enjoy MariaDB!
As mentioned in the , our Yum/DNF/Zypper repositories for Red Hat Enterprise Linux, CentOS, openSUSE, and SUSE are changing with this release to being signed with a new GPG key with SHA2 digest algorithms instead of SHA1. See and the page for more details.
corruption with ()
Parallel slave applying in binlog order is corrected for admin class of commands including ANALYZE ()
is now shown now more precisely at the slave applier start, including in the delayed mode ()
mysqlbinlog --verbose is made to show the type of compressed columns ()
Infinite sequence of recursive calls when processing embedded CTE ()
Crash with a query containing nested WINDOW clauses ()
Major performance regression with 10.6.11 ()
Fixes for the following :
CVE-`-```
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.3 is:MariaDB 10.3.39 Stable (GA) Download Now
Download 10.3.37 | Release Notes | Changelog | Overview of 10.3
Release date: 7 Nov 2022
MariaDB 10.3 is a previous stable series of MariaDB, maintained until May 2023, and an evolution of MariaDB 10.2 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
MariaDB 10.3.37 is a Stable (GA) release.
For an overview of MariaDB Server 10.3 see the What is MariaDB 10.3? page.
Thanks, and enjoy MariaDB!
The server no longer tolerates incorrectly configured SSL (). If you have enabled SSL in my.cnf but have not configured it properly (for example, a certificate file is missing), MariaDB used to silently disable SSL, leaving you under impression that everything was fine and connections were secure. Since this release, MariaDB will fail to start if SSL is enabled, but cannot be switched on.
hangs ()
InnoDB unnecessarily extends data files ()
Adaptive hash index ,
MVCC and locking ,
Virtual columns ,
does not parse NULL properties properly ()
minor correction in unsafe warning message ()
False replication error-stop of from a non-existing user on primary () in combination with a filtering replica is corrected
replication is mended on a replica that filters system tables ()
Beginning with the next release (Q1 2023), our Yum, DNF, and Zypper repositories for Red Hat, Fedora, and SUSE will be migrated to being signed with a new . The key we are migrating to is the same one we already use for our Debian and Ubuntu Repositories.
The short Key ID is: 0xC74CD1D8
The long Key ID is: 0xF1656F24C74CD1D8
The following changes have been made to the docker.io/library/mariadb container image.
The number of gpg packages has been removed, leaving enough to apt-get update, but dirmngr that would fetch keys has been removed. (inspired by )
The environment variable LANG=C.UTF-8 has been added for those that exec into containers and copy paste UTF8 characters (fixes ).
Adds OCI labels to image (fixes and )
Fixes for the following :
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 full fingerprint of the key is: 177F 4010 FE56 CA33 3630 0305 F165 6F24 C74C D1D8
The key can be imported now in preparation for this change using the following command:
MariaDB config: skip-host-cache and skip-name-resolve moved to /etc/mysql/mariadb.conf.d/05-skipcache.cnf
The most recent release of MariaDB 10.3 is:MariaDB 10.3.39 Stable (GA) Download Now
Download 10.3.36 | Release Notes | Changelog | Overview of 10.3
Release date: 15 Aug 2022
MariaDB 10.3 is the previous stable series of MariaDB, supported until May 2023, and an evolution of MariaDB 10.2 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
MariaDB 10.3.36 is a Stable (GA) release.
For an overview of MariaDB Server 10.3 see the What is MariaDB 10.3? page.
Thanks, and enjoy MariaDB!
InnoDB corruption due to lack of file locking ()
FULLTEXT search with apostrophe, and mandatory words ()
ALTER TABLE IMPORT TABLESPACE corrupts an encrypted table ()
ER_SLAVE_INCIDENT error is specified now on slave to be seen with SHOW-SLAVE-STATUS ()
INCIDENT_EVENT is no longer binlogged when a being logged transaction can be safely rolledback ()
sequences related row-format events are made to correspond to binlog_row_image ()
Server crash in JOIN_CACHE::free or in copy_fields ()
Queries that use DISTINCT and an always-constant function like COLLATION(aggegate_func(...)) could cause a server crash. Note that COLLATION() is a special function - its value is constant even if its argument is not costant.
Crash when using ANY predicand with redundant subquery in GROUP BY clause ()
MariaDB Server SEGV on INSERT .. SELECT ()
Certain queries in form "INSERT ... SELECT with_aggregate_or_window_func" could cause a crash.
restore_prev_nj_state() doesn't update cur_sj_inner_tables correctly ()
Subquery semi-join optimization could miss LooseScan or FirstMatch strategies for certain queries.
now supports with ()
New option, -enable-cleartext-plugin. Option does not do anything, and is for MySQL-compatibility purposes only.
Crash in ()
As per the , this will be the last release of for Debian 10 "Buster" for ppc64el
Fixes for the following :
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)
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 the previous stable series of MariaDB, and an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
is a release.
For an overview of MariaDB Server 10.3 see the page.
Thanks, and enjoy MariaDB!
The most recent release of is: Stable (GA)
| | |
Release date: 7 Oct 2020
is the previous stable series of MariaDB, and an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
is a release.
For an overview of MariaDB Server 10.3 see the page.
Thanks, and enjoy MariaDB!
sudo rpm --import https://supplychain.mariadb.com/MariaDB-Server-GPG-KEYOptimizer uses all partitions after upgrade to 10.3 (MDEV-28246)
For multi-table UPDATE or DELETE queries, the optimizer failed to apply Partition Pruning optimization for the table that is updated or deleted from.
MDEV-20987: InnoDB fails to start when FTS table has FK relation
See also the release notes for MariaDB 10.3.19 for additional items of note
Fixes for the following :
CVE-`-```
When upgrading from MariaDB 10.3.8 or earlier to MariaDB 10.3.9 or higher, running is required due to changes introduced inMDEV-14637.
For a complete list of changes made in MariaDB 10.3.20, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.3.20, see the MariaDB Foundation release announcement.
Fixes for the following :
When upgrading from MariaDB 10.3.8 or earlier to MariaDB 10.3.9 or higher, running is required due to changes introduced inMDEV-14637.
For a complete list of changes made in MariaDB 10.3.25, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.3.25, see the MariaDB Foundation release announcement.
The most recent release of MariaDB 10.3 is:MariaDB 10.3.39 Stable (GA) Download Now
Download | Release Notes | Changelog | Overview of 10.3
Release date: 18 Jan 2018
MariaDB 10.3 is the current development series of MariaDB. It is an evolution of MariaDB 10.2 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
MariaDB 10.3.4 is a Beta release.
Do not use Beta releases on production systems!
For an overview of MariaDB 10.3 see the What is MariaDB 10.3? page.
Thanks, and enjoy MariaDB!
This is the second beta release in the series.
Notable changes of this release include:
()
The storage engine is now Beta.
- Duplicate primary keys are allowed after ADD COLUMN / UPDATE
- refuses InnoDB crash-upgrade from
Do not use Beta releases on production systems!
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.3 is:MariaDB 10.3.39 Stable (GA) Download Now
Download | Release Notes | Changelog | Overview of 10.3
Release date: 11 Sep 2019
MariaDB 10.3 is the previous stable series of MariaDB, and an evolution of MariaDB 10.2 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
MariaDB 10.3.18 is a Stable (GA) release.
For an overview of MariaDB Server 10.3 see the What is MariaDB 10.3? page.
Thanks, and enjoy MariaDB!
updated to Connect 1.06.0010
: This bug could cause a table to become corrupt if a column was added instantly
: A race condition in InnoDB transaction commit that affects record locking was fixed
: Table doesn't exist in engine after ALTER of FOREIGN KEY
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: 20 May 2022
is the previous stable series of MariaDB, and an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
is a release.
For an overview of MariaDB Server 10.3 see the page.
Thanks, and enjoy MariaDB!
The most recent release of is: Stable (GA)
| | |
Release date: 8 Nov 2021
is the previous stable series of MariaDB, and an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
is a release.
For an overview of MariaDB Server 10.3 see the page.
Thanks, and enjoy MariaDB!
The most recent release of is: Stable (GA)
| | |
Release date: 15 Aug 2018
is an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
is a release.
For an overview of MariaDB Server 10.3 see the page or watch the webinar recording, .
Thanks, and enjoy MariaDB!
... ANY (SELECT ... GROUP BY (SELECT redundant_subselect_here)) ...MDEV-14717 - RENAME TABLE in InnoDB is not crash-safe
MDEV-14952 - Avoid repeated calls to btr_get_search_latch()
MDEV-14638 - Replace trx_sys_t::rw_trx_set with LF_HASH
Added the tail-lines option to
As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.3 for Ubuntu 17.04 "zesty"
MDEV-20301: InnoDB's MVCC has O(N^2) behaviors
MDEV-18128: Simplify .ibd file creation
MDEV-20060: Failing assertion: srv_log_file_size <= 512ULL << 30 while preparing backup
MDEV-20247: Replication hangs with "preparing" and never starts
MDEV-17614: Remove unnecessary locking for INSERT...ON DUPLICATE KEY UPDATE
MDEV-20311: row_ins_step accesses uninitialized memory
MDEV-19947: Repositories for RHEL 8 ppc64le added
Fixes for the following :
CVE-`-```
removed (MDEV-25975)
InnoDB gap locking fixes (MDEV-20605, MDEV-28422)
Binlogs disappear after rsync IST (MDEV-28583)
master crash is eliminated in compressed semisync replication protocol with packet counting amendment (MDEV-25580)
OPTIMIZE on a sequence does not cause counterfactual ER_BINLOG_UNSAFE_STATEMENT anymore (MDEV-24617)
Automatically generated Gtid_log_list_event is made to recognize within replication event group as a formal member (MDEV-28550)
using two or more unique key values at a time with is corrected ()
stops issuing unnecessary "Unsafe statement" with ()
Incomplete replication event groups are detected to error out by the slave IO thread ()
now flushes the result file to disk after each processed event so the file can be listed with the actual bytes ()
Incorrect binlogs after Galera SST using rsync and MariaDB Backup (MDEV-27524)
MariaDB Backup does not detect multi-source replication slave (MDEV-21037)
Useless warning "InnoDB: Allocated tablespace ID for , old maximum was 0" during backup stage (MDEV-27343)
MariaDB Backup prepare fails for incrementals if a new schema is created after full backup is taken (MDEV-28446)
ANALYZE FORMAT=JSON fields are incorrect for UNION ALL queries (MDEV-27699)
Subquery in an UPDATE query uses full scan instead of range (MDEV-22377)
Assertion `item1->type() == Item::FIELD_ITEM ... (MDEV-19398)
Server crashes in Expression_cache_tracker::fetch_current_stats (MDEV-28268)
MariaDB server crash at Item_subselect::init_expr_cache_tracker (, )
Crash with union of my_decimal type in ORDER BY clause ()
SIGSEGV in st_join_table::cleanup ()
Assertion `!eliminated' failed in Item_subselect::exec ()
For RHEL/CentOS 7, non x86_64 architectures are no longer supported upstream and so our support will also be dropped with this release
As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.3 for Debian 9 "Stretch"
Fixes for the following :
When upgrading from MariaDB 10.3.8 or earlier to MariaDB 10.3.9 or higher, running is required due to changes introduced inMDEV-14637.
For a complete list of changes made in MariaDB 10.3.34, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.3.35, see the MariaDB Foundation release announcement.
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-26672, 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 :
When upgrading from MariaDB 10.3.8 or earlier to MariaDB 10.3.9 or higher, running is required due to changes introduced inMDEV-14637.
For a complete list of changes made in MariaDB 10.3.32, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.3.32, see the MariaDB Foundation release announcement.
Notable changes of this release include:
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.
InnoDB 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
- Assertion `is_instant() || id == DICT_INDEXES_ID' failed in dict_index_t::instant_field_value
- ALTER TABLE DROP FOREIGN KEY - unexpected end of stream error
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
- Unnecessary explicit lock acquisition during UPDATE or DELETE
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.3.8 or earlier to MariaDB 10.3.9 or higher, running is required due to changes introduced inMDEV-14637.
For a complete list of changes made in MariaDB 10.3.9, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.3.9, see the MariaDB Foundation release announcement.
The most recent release of MariaDB 10.3 is:MariaDB 10.3.39 Stable (GA) Download Now
Download 10.3.30 | Release Notes | Changelog | Overview of 10.3
Release date: 23 Jun 2021
MariaDB 10.3 is the previous stable series of MariaDB, and an evolution of MariaDB 10.2 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
MariaDB 10.3.30 is a Stable (GA) release.
For an overview of MariaDB Server 10.3 see the What is MariaDB 10.3? 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 :
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.3 is:MariaDB 10.3.39 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.3
Release date: 28 Jan 2020
MariaDB 10.3 is the previous stable series of MariaDB, and an evolution of MariaDB 10.2 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
MariaDB 10.3.22 is a Stable (GA) release.
For an overview of MariaDB Server 10.3 see the What is MariaDB 10.3? page.
Thanks, and enjoy MariaDB!
: fix aligned_malloc()
: Threadpool/Unix- wait_begin() function does not wake/create threa ds, when it should
As per the , this will be the last release of for Ubuntu 19.04 Disco
: Deadlock of parallel slave and mariadb-backup (with failed log copy thread)
: Reduce size of record offsets
: Reduce the memory usage during recovery
: TRUNCATE and OPTIMIZE are being refused due to "row size too large"
: Server hang when using simulated AIO
: aria_pack segfaults in compress_maria_file
: Wrong results with window functions and implicit grouping
: Wrong result of query using DISTINCT COUNT() OVER ()
: Possible range plan is not used under certain conditions
: Crashes caused by random values to the offset option of SHOW BINLOG EVENT offset command
: Semisync Master could crash when it executed RESET MASTER and a replica reconnects using GTID protocol
Fixes for the following :
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.3 is:MariaDB 10.3.39 Stable (GA) Download Now
Download | Release Notes | Changelog | Overview of 10.3
Release date: 2 Jul 2018
MariaDB 10.3 is an evolution of MariaDB 10.2 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
MariaDB 10.3.8 is a Stable (GA) release.
For an overview of MariaDB Server 10.3 see theWhat is MariaDB 10.3? page or watch the webinar recording, What's new in MariaDB TX 3.0.
Thanks, and enjoy MariaDB!
Notable changes of this release include:
- O_CLOEXEC on innodb/xtradb temp files
- Wrong INFORMATION_SCHEMA.INNODB_BUFFER_PAGE.TABLE_NAME
- InnoDB fails to shut down purge, causing hang
- ALTER TABLE...DISCARD TABLESPACE still takes long on a large buffer pool
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.3 is:MariaDB 10.3.39 Stable (GA) Download Now
Download | Release Notes | Changelog | Overview of 10.3
Release date: 25 May 2018
MariaDB 10.3 is an evolution of MariaDB 10.2 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
MariaDB 10.3.7 is a Stable (GA) release.
For an overview of MariaDB Server 10.3 see theWhat is MariaDB 10.3? page or watch the webinar recording, What's new in MariaDB TX 3.0.
Thanks, and enjoy MariaDB!
Notable changes of this release include:
is now
is now
Two new options, INSTANT and NOCOPY, which allow operations that would require any data files to be modified, or that would require rebuilding the clustered index respectively, to be refused rather than potentially perform slowly, as well as other ALTER TABLE improvements. (, )
The embedded server library now supports SSL when connecting to remote servers.
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.3 is:MariaDB 10.3.39 Stable (GA) Download Now
Download 10.3.31 | Release Notes | Changelog | Overview of 10.3
Release date: 6 Aug 2021
Warning: This version can cause InnoDB file corruption on FreeBSD and on AIX. If you are using AIX, please, stick to an earlier release, or upgrade to a more recent release. If you are using FreeBSD, upgrade to the bugfix release (the version ends with _1) of the mariadb-server from the Ports Collection. See MDEV-26537.
MariaDB 10.3 is the previous stable series of MariaDB, and an evolution of MariaDB 10.2 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
MariaDB 10.3.31 is a Stable (GA) release.
For an overview of MariaDB Server 10.3 see the What is MariaDB 10.3? 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. ()
As per the , this will be the last release of for Ubuntu 20.10 Groovy
updated to 25.3.34
Fixes for the following :
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.3 is:MariaDB 10.3.39 Stable (GA) Download Now
Download | Release Notes | Changelog | Overview of 10.3
Release date: 16 Apr 2018
MariaDB 10.3 is the current development series of MariaDB. It is an evolution of MariaDB 10.2 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
MariaDB 10.3.6 is a RC release.
Do not use non-GA releases on production systems!
For an overview of MariaDB 10.3 see theWhat is MariaDB 10.3? page.
Thanks, and enjoy MariaDB!
Notable changes of this release include:
Added the , for monitoring the disk space situation.
, , , and now return NULL if returning an empty result when - , .
now has a new mode, 3, which skips the rollback of connected transactions -
Do not use non-GA releases on production systems!
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.3 is:MariaDB 10.3.39 Stable (GA) Download Now
Download | Release Notes | Changelog | Overview of 10.3
Release date: 9 Oct 2017
Do not use alpha releases in production!
MariaDB 10.3 is the current development series of MariaDB. It is an evolution of MariaDB 10.2 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
MariaDB 10.3.2 is an Alpha release.
For an overview of MariaDB 10.3 see theWhat is MariaDB 10.3? page.
Thanks, and enjoy MariaDB!
Notable changes of this release include:
() — Tencent Game DBA Team, developed by vinchen.
() — from Jerome Brauge.
and in multi-table update ()
- 3 argument form of DATE_FORMAT ()
() — Tencent Game DBA Team, developed by willhan, also thanks to AliSQL.
Temporary files created by merge sort and row log are encrypted if is set to 1, regardless of whether the table encrypted or not ().
- permits seeing which version of the source was used for the build ().
Renamed idle_readwrite_transaction_timeout to .
The following deprecated variables have been removed:
Do not use alpha releases in production!
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.3 is:MariaDB 10.3.39 Stable (GA) Download Now
Download | Release Notes | Changelog | Overview of 10.3
Release date: 21 Feb 2019
MariaDB 10.3 is an evolution of MariaDB 10.2 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
MariaDB 10.3.13 is a Stable (GA) release.
For an overview of MariaDB Server 10.3 see the What is MariaDB 10.3? page.
Thanks, and enjoy MariaDB!
: updated to 9.5
: Maximum value of is now 2097152.
mariadb-backup 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 is: Stable (GA)
| | |
Release date: 7 May 2021
is the previous stable series of MariaDB, and an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
is a release.
For an overview of MariaDB Server 10.3 see the page.
Thanks, and enjoy MariaDB!
The most recent release of is: Stable (GA)
| | |
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.
is the previous stable series of MariaDB, and an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
is a release.
For an overview of MariaDB Server 10.3 see the page.
Thanks, and enjoy MariaDB!
The most recent release of is: Stable (GA)
| | |
Release date: 29 Aug 2017
Do not use alpha releases in production!
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.
is an 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 an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
is a release.
For an overview of MariaDB Server 10.3 see the page.
Thanks, and enjoy MariaDB!
The most recent release of is: Stable (GA)
| | |
Release date: 2 Apr 2019
is an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
is a release.
For an overview of MariaDB Server 10.3 see the page.
Thanks, and enjoy MariaDB!
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: 11 Dec 2019
is the previous stable series of MariaDB, and an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
is a release.
For an overview of MariaDB Server 10.3 see the page.
Thanks, and enjoy MariaDB!
Potential hang in purge for virtual columns (MDEV-25664)
Change buffer entries for secondary indexes are lost on InnoDB restart (MDEV-25869)
MDEV-21509: Possible hang during purge of history, or rollback
MDEV-21511: Wrong estimate of affected BLOB columns in update
MDEV-21512: InnoDB may hang due to SPATIAL INDEX
MDEV-21513: Avoid some crashes in ALTER TABLE...IMPORT TABLESPACE
MDEV-18865: Assertion `t->first->versioned_by_id()' failed in innodb_prepare_commit_versioned
MDEV-13834 - Upgrade failure from 10.1 innodb_encrypt_log
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-16469 - SET GLOBAL innodb_change_buffering has no effect
MDEV-13103 - Deal with page_compressed page corruption
MDEV-15611 - Due to the failure of foreign key detection, Galera slave node killed himself
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
MDEV-16330 - Allow instant change of WITH SYSTEM VERSIONING column attribute
MDEV-16365 - Setting a column NOT NULL fails to return error for NULL values when there is no DEFAULT
MDEV-15953 - Alter InnoDB Partitioned Table Moves Files (which were originally not in the datadir) to the datadir
MDEV-13122: MariaDB Backup now supports
As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.3 for Ubuntu 17.10 Artful
New system variable for restricting the direct setting of a session timestamp (MDEV-15923)
New status variables for monitoring JSON functionality usage and for .
--ignore-database option (MDEV-13336)
Remove InnoDB 5.7 version number from MariaDB 10.3 onwards (MDEV-16172)
Fixes for instant ADD COLUMN (MDEV-14906, MDEV-15060, MDEV-15871, MDEV-16065)
Various performance fixes and code cleanup, including clean up InnoDB parameter validation (MDEV-12218)
Fixed hangs on shutdown (MDEV-13779) and EXPORT (MDEV-13987)
As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.3 for Debian 7 Wheezy and Fedora 26
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)
The max value of the system variable has been increased from 1048576 to 4294967295
The variable can now be modified without restarting the server - MDEV-15501
The Information Schema is optimized to use much less memory when selecting from or any other table with many or columns - MDEV-14275
Added new status variables to count the usage of user defined aggregate functions: - MDEV-14592
Windows binaries now use high-precision timer when available - MDEV-15694. This makes much less probable for two queries to have the same CURRENT_TIMESTAMP(6) value, for example.
is not allowed for tables in the mysql database - MDEV-14790
The now displays info in the EXTRA column - MDEV-15062
New Galera system variable, for rejecting client connection queries.
As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.3 for Debian 7 Wheezy
InnoDB crash recovery fixes: MDEV-18183, MDEV-18279, MDEV-18349
Galera crash recovery fixes: MDEV-15740
MDEV-18281: COM_RESET_CONNECTION changes the connection encoding
binlog fixes: MDEV-10963 & MDEV-10963
updated to 3.3.14
Fixed some crashes and a few wrong results with Spider
Fixes for the following :
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)
DELETE HISTORY may delete current data on system-versioned table ()
Crashes with nested table value constructors ()
RENAME TABLE causes "Ignoring data file" messages (MDEV-25568)
Deprecated the *innodb and *none options in (MDEV-25106)
MVCC read from index on CHAR or VARCHAR wrongly omits rows (MDEV-25459)
Race conditions in persistent statistics (MDEV-10682, MDEV-18802, MDEV-25051)
Sequence created by one connection remains invisible to another ()
Replication Heartbeat event was uncapable to cary 4GB+ offsets (MDEV-16146)
FLUSH LOGS race against Binlog checkpoint event creation (MDEV-24526)
slave_compressed_protocol did not work correctly with semi-sync (MDEV-24773)
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)
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.3 for Ubuntu 16.04 Xenial
Fixes for the following :
When upgrading from MariaDB 10.3.8 or earlier to MariaDB 10.3.9 or higher,
running is required due to changes introduced inMDEV-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.3.29, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.3.29, see the MariaDB Foundation release announcement.
MDEV-24188 - Hang in buf_page_create() after reusing a previously freed page
MDEV-24275 - analyze forces full scan forcing lock crash
MDEV-24449 - Corruption of system tablespace or last recovered page
Galera updated to 25.3.32
MDEV-23328 - Server hang due to Galera lock conflict resolution
MDEV-23851 - BF-BF Conflict issue because of UK GAP locks
MDEV-20717 - Plugin system variables and activation options can break
- and system variables are now read-only
MDEV-8134 - relay-log is corrected to rotate past 999999
MDEV-23033 - fixed slave applier for row-based events with FK constraints on virtual columns
MDEV-4633 - Relay_Log_Space of Show-Slave-Status is made thread-safe
MDEV-10272 - add master host/port info to slave thread exit messages
MDEV-24122 - anomalies in mysql.user tables on previously 5.7 MySQL versions corrected
MDEV-23630 - option
Fixes for the following :
When upgrading from MariaDB 10.3.8 or earlier to MariaDB 10.3.9 or higher, running is required due to changes introduced inMDEV-14637.
For a complete list of changes made in MariaDB 10.3.28, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.3.28, see the MariaDB Foundation release announcement.
This is the second alpha release in the MariaDB 10.3 series.
Notable changes of this release include:
Update to 5.7.19
function ()
The statement can now delete from the table that is used in a subquery in the WHERE clause ()
Stored routine parameters can now use ()
The server now - see also the new system variable ()
Reset old history of records and redo log format changes (, , )
New setting, split_grouping_derived=on (see description)
Functions that used to only return 64-bit now can return 32-bit results (MDEV-12619).
Disable logging of certain statements to the or the with the and system variables.
A new option to , filsort_priority_queue (renamed to filesort_priority_queue in MariaDB 10.3.2).
New system variable for improving performance if a server is using multiple different storage engines in different transactions (MDEV-12179)
New status variables , , and .
is enabled by default (MDEV-11825)
Remove deprecated variables , , and .
Do not use alpha releases in production!
For a complete list of changes made in MariaDB 10.3.1, with links to detailed information on each push, see the changelog.
MDEV-13992: and
MDEV-19490: show tables fails when selecting the information_schema database
MDEV-19491: multi-update with triggers and stored routines
MDEV-19541: InnoDB crashes when trying to recover a corrupted page
: Incorrect error handling in ALTER TABLE
: FULLTEXT INDEX fix
: System Versioning fix
: InnoDB skips the tablespace in rotation list
: SET GLOBAL innodb_ deadlock due to LOCK_global_system_variables
: Unable to start galera node
: Malicious SUPER user can possibly change audit log configuration without leaving traces
: Wrong results from query, using left join
: RIGHT JOIN hangs in MariaDB
Virtual columns fixes: ,
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.3.8 or earlier to MariaDB 10.3.9 or higher, running is required due to changes introduced inMDEV-14637.
For a complete list of changes made in MariaDB 10.3.16, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.3.16, see the MariaDB Foundation release announcement.
Repositories for CentOS 7, RHEL 7 & 8, Fedora 28 & 29, and SLES 12 & 15 now include a src.rpm file that you can use to build MariaDB. Instructions for doing so are found on the page
InnoDB corruption fixes: MDEV-14126, MDEV-18272, MDEV-18879, MDEV-18972, MDEV-18981
InnoDB purge performance fixes: MDEV-18878, MDEV-18936
InnoDB ALTER TABLE fixes: , , , , ,
Galera fixes: , ,
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.3.8 or earlier to MariaDB 10.3.9 or higher, running is required due to changes introduced inMDEV-14637.
For a complete list of changes made in MariaDB 10.3.14, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.3.14, see the MariaDB Foundation release announcement.
MDEV-13492: SEC_E_INVALID_TOKEN when server sends large message during SSL handshake
MDEV-18310: Aria engine: Undo phase failed from incremental backup
MDEV-20949: Stop issuing 'row size' error on DML
MDEV-20832: Don't print "row size too large" warnings in error log if innodb_strict_mode=OFF and log_warnings<=2
MDEV-21024: Remove redundant writes to the redo log
: Crash on DROP TABLE if the data file is corrupted
some cleanup of AIO code, to better report errors
: MRR scan over partitioned InnoDB table produces "Out of memory" error
: Table cannot be loaded after instant ADD/DROP COLUMN
: heap-use-after-poison in ADD PRIMARY KEY after instant ADD COLUMN
: Memory leak after failed ADD PRIMARY KEY
: trx_undo_seg_free() is never redo-logged
MDEV-21044: Wrong result when using a smaller size for sort buffer
MDEV-20611: MRR scan over partitioned InnoDB table produces "Out of memory" error
MDEV-19376: Repl_semi_sync_master::commit_trx assertion failure
MDEV-18929: 2nd execution of SP does not detect ER_VERS_NOT_VERSIONED
MDEV-21011: Table corruption reported for versioned partitioned table after DELETE
Packages for Fedora 31 have been added in this release
As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.3 for Fedora 29
Fixes for the following :
CVE-`-```
When upgrading from MariaDB 10.3.8 or earlier to MariaDB 10.3.9 or higher, running is required due to changes introduced inMDEV-14637.
For a complete list of changes made in MariaDB 10.3.21, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.3.21, see the MariaDB Foundation release announcement.
The most recent release of MariaDB 10.3 is:MariaDB 10.3.39 Stable (GA) Download Now
Download 10.3.33 | Release Notes | Changelog | Overview of 10.3
Release date: 9 Feb 2022
This release is no longer available for download after a problem was noticed when manually running mariadb-upgrade. See MDEV-27789 for more details.Please use a later release.
MariaDB 10.3 is the previous stable series of MariaDB, and an evolution of MariaDB 10.2 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
MariaDB 10.3.33 is a Stable (GA) release.
For an overview of MariaDB Server 10.3 see the What is MariaDB 10.3? page.
Thanks, and enjoy MariaDB!
does not disallow .isl file creation ()
updated to 25.3.35()
Galera SST scripts should use ssl_capath (not ssl_ca) for CA directory ()
Seconds behind master corrected from artificial spikes at relay-log rotation ()
Statement rollback in binlog when transaction creates or drop temporary table is set right ()
CREATE-or-REPLACE SEQUENCE is made to binlog with the DDL flag to stabilize its parallel execution on slave ()
prohibition running two upgrades in parallel (, , )
As per the , this will be the last release of for CentOS 8
script updated to version 2022-02-08, with the following fixes and enhancements:
Default location of the script has been moved to:
Faster initialization by disabling binary logging during initialization ()
mysql_upgrade can be run if needed using the environment variable MARIADB_AUTO_UPGRADE=1 ()
A healthcheck script /usr/local/bin/healthcheck.sh is installed in the container with various checking options ()
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} (
Fixes for the following :
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.3 is:MariaDB 10.3.39 Stable (GA) Download Now
Download | Release Notes | Changelog | Overview of 10.3
Release date: 26 Feb 2018
MariaDB 10.3 is the current development series of MariaDB. It is an evolution of MariaDB 10.2 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
MariaDB 10.3.5 is a RC release.
Do not use non-GA releases on production systems!
For an overview of MariaDB 10.3 see theWhat is MariaDB 10.3? page.
Thanks, and enjoy MariaDB!
The PL/SQL stored procedure dialect (enabled with ) now supports Oracle style packages. Support for the following statements has been added ():
On Linux, shrink the core dumps by omitting the ()
Fix upgrades from earlier versions ()
New status variable ()
As per the , 10.3 binary tarball packages for GLIBC_2.5 (that were built on CentOS 5) have been discontinued.
includes all bug fixes from , including the following:
Remove excessive undo logging during
Faster startup when no crash recovery is deeded (, )
Do not use non-GA releases on production systems!
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.3 is:MariaDB 10.3.39 Stable (GA) Download Now
Download | Release Notes | Changelog | Overview of 10.3
Release date: 20 Nov 2018
MariaDB 10.3 is an evolution of MariaDB 10.2 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
MariaDB 10.3.11 is a Stable (GA) release.
For an overview of MariaDB Server 10.3 see the What is MariaDB 10.3? page.
Thanks, and enjoy MariaDB!
Notable changes of this release include:
now uses utf8mb4 as a default , instead of utf8.
can now be set as a command-line and my.cnf option.
Fixed crash on upgrade from or earlier:
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.3 is:MariaDB 10.3.39 Stable (GA) Download Now
Download | Release Notes | Changelog | Overview of 10.3
Release date: 31 Jul 2019
MariaDB 10.3 is the previous stable series of MariaDB, and an evolution of MariaDB 10.2 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
MariaDB 10.3.17 is a Stable (GA) release.
For an overview of MariaDB Server 10.3 see the What is MariaDB 10.3? page.
Thanks, and enjoy MariaDB!
: updated to 10.2
: Merge upstream .
: Encrypted temporary tables are not encrypted.
: is now stable and requires the .
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.3 is:MariaDB 10.3.39 Stable (GA) Download Now
Download 10.3.27 | Release Notes | Changelog | Overview of 10.3
Release date: 11 Nov 2020
MariaDB 10.3 is the previous stable series of MariaDB, and an evolution of MariaDB 10.2 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
MariaDB 10.3.27 is a Stable (GA) release.
For an overview of MariaDB Server 10.3 see the What is MariaDB 10.3? 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) ()
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)
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 for more details.Do not download or use this release.
| | |
Release date: 5 Nov 2019
is the previous stable series of MariaDB, and an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
The most recent release of is: Stable (GA)
| | |
Release date: 12 May 2020
is the previous stable series of MariaDB, and an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
is a release.
For an overview of MariaDB Server 10.3 see the page.
Thanks, and enjoy MariaDB!
The GPG keyring file, used with Debian and Ubuntu repositories, has moved to: mariadb-keyring-2019.gpg and the checksum for the file can be found at: mariadb-keyring-2019.gpg.sha256
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
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 (issue #401)
log note about note on Securing system users, mysql_secure_installation not required (reddit suggestion)
The storage engine is now RC.
Numerous performance improvements for high-concurrency load.
Useless @@system_versioning_innodb_algorithm_simple server variable was removed.
New SIMULTANEOUS_ASSIGNMENT to make the SET part of the statement evaluate all assignments simultaneously, not left-to-right.
Numerous scalability and performance improvements to global data structures, including MDEV-14756, MDEV-15019, MDEV-14482, MDEV-15059, MDEV-15104
Correctness improvement - honors transactional locks (MDEV-15061)
Performance improvements to persistent data structures: MDEV-15090, MDEV-15132
If a user has the but not the DELETE HISTORY privilege, running will grant DELETE HISTORY as well.
Added Max_index_length and Temporary to
MDEV-17073 - is now less deadlock-prone
MDEV-17289 - Multi-pass recovery fails to apply some redo log records
MDEV-17541 - during lock wait in check no longer causes hang
MDEV-17531 - Fix crash in with and
fixes: MDEV-17545, MDEV-17546
fixes: MDEV-17215, MDEV-17548
MariaDB Backup fixes:
MDEV-13564 - now works with MariaDB Backup
MDEV-17433 - Allow InnoDB start up with empty ib_logfile0 from mariadb-backup --prepare
Packages for Fedora 29 and Ubuntu 18.10 Cosmic have been added in this release
As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.3 for Fedora 27
Fixes for the following :
Merge relevant InnoDB changes from MySQL 5.7.27
Adjust spin loops to the x86 PAUSE instruction latency (MDEV-19845)
MDEV-20102: When the ctas from a big table is interrupted ,then you can't drop or recreate the table
MDEV-19292: 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: MDEV-15641, MDEV-19630, MDEV-19916, MDEV-19974
Indexed virtual columns: MDEV-16222, MDEV-17005, MDEV-19870
FULLTEXT INDEX: MDEV-14154
Encryption: MDEV-17228, MDEV-19914
Galera + FOREIGN KEY: MDEV-19660
Recovery & mariadb-backup: MDEV-19978
MDEV-19871: Add page id matching check in innochecksum tool
MDEV-20091: DROP TEMPORARY table is logged despite no CREATE was logged
MDEV-19427: mysql_upgrade_service throws exception upgrading from 10.0 to 10.3
MDEV-19814: Server crash in row_upd_del_mark_clust_rec or Assertion
MDEV-17363: Compressed columns cannot be restored from dump
As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.3 for Ubuntu 18.10 "Cosmic"
Fixes for the following :
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--``#
For an overview of MariaDB Server 10.3 see the What is MariaDB 10.3? page.
Thanks, and enjoy MariaDB!
MDEV-20864: Debug-only option for dumping the contents of the InnoDB change buffer to the server error log at startup.
mariadb-backup:
MDEV-18438: mbstream recreates xtrabackup_info on same directory as backup file
MDEV-20703: mariadb-backup creates binlog files in server binlog directory on --prepare --export step
Read-only replicas
Issues related to read only replicas are fixed:
, , , and of temporary tables are not logged to binary log, even in or mode. With earlier MariaDB versions, one can avoid the problem with temporary tables by using in which cases temporary tables are never logged.
FULLTEXT INDEX:
: Server hangs after dropping full text indexes and restart
: InnoDB hang on DROP FULLTEXT INDEX
: FTS row mismatch after crash recovery
: Duplicate key with auto increment
ALTER TABLE:
: DROP Virtual Column crash
: BtrBulk is unnecessarily holding dict_index_t::lock
System-Versioned Tables:
: FK constraints on versioned tables use historical rows, which may cause constraint violation
: Unexpected ER_ROW_IS_REFERENCED_2 or server crash in row_ins_foreign_report_err upon DELETE from versioned table with FK
updated to 25.3.28
Packages for Ubuntu 19.10 Eoan have been added in this release
Fixes for the following :
When upgrading from MariaDB 10.3.8 or earlier to MariaDB 10.3.9 or higher, running is required due to changes introduced inMDEV-14637.
For a complete list of changes made in MariaDB 10.3.19, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.3.19, see the MariaDB Foundation release announcement.
Fixed issue that, from MariaDB 10.3.19, disabled all created by a server with a different server_id. Note that the fix does not re-enable affected events. (MDEV-21758)
now correctly lists the Delete history privilege, rather than displaying it as Delete versioning rows. (MDEV-20382)
updated to 11.0 (MDEV-22032)
Introduce a file format constraint to ALTER TABLE. See (MDEV-20590)
ALTER TABLE, FORCE all partition to rebuild if any one of the partition does rebuild (MDEV-21832)
ALTER TABLE, InnoDB aborts while adding instant column for discarded tablespace (MDEV-22446)
Optimizer, Wrong query results with optimizer_switch="split_materialized=on" ()
SHOW GRANTS does not quote role names properly ()
Paritioning INSERT chooses wrong partition for RANGE partitioning by DECIMAL column ()
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' failed in fts_optimize_remove_table` ()
Wrong estimate of affected BLOB columns in update of PRIMARY KEY ()
Duplicate key value is silently truncated to 64 characters in print_keydup_error ()
Session tracking returns incorrectly long tracking data ()
Add pam_user_map.so file to binary tarball package ()
Running out of file descriptors and eventual crash ()
mysql_upgrade is made aware of the upstream slave tables to issue warnings when that takes place ()
Corruption for SET GLOBAL innodb_ string variables ()
wsrep performance optimization ()
parameter, --ignore-table-data, added ()
Server can fail while replicating conditional comments (Bug#28388217)
updated to 25.3.29
Added the xml-report option to ()
Packages and for Ubuntu 20.04 "focal" added
As per the , this will be the last release of for Debian 8 "Jessie"
Fixes for the following :
When upgrading from MariaDB 10.3.8 or earlier to MariaDB 10.3.9 or higher, running is required due to changes introduced inMDEV-14637.
For a complete list of changes made in MariaDB 10.3.23, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.3.23, see the MariaDB Foundation release announcement. Thanks, and enjoy MariaDB!>
The most recent release of MariaDB 10.3 is:MariaDB 10.3.39 Stable (GA) Download Now
Download 10.3.26 | Release Notes | Changelog | Overview of 10.3
Release date: 3 Nov 2020
MariaDB 10.3 is the previous stable series of MariaDB, and an evolution of MariaDB 10.2 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
MariaDB 10.3.26 is a Stable (GA) release.
For an overview of MariaDB Server 10.3 see the What is MariaDB 10.3? page.
Thanks, and enjoy MariaDB!
Set the default value of to OFF by default ()
maximum index size increased from 1000 to 3500 bytes ()
issue ()
Temporary tables can no longer overwrite existing files. Instead an error is returned should a conflict occur (
updated to 25.3.31
Fixed galera got stuck after flush tables ()
Fixed data loss on rolling upgrade between 10.3 and 10.4 ()
IPv6 SST handling improved (, , , , )
As per the , this will be the last release of for CentOS/RHEL 6 and Fedora 31
Packages for added
Packages for arm64 and ppc64el added
Packages for arm64 added
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.3 is:MariaDB 10.3.39 Stable (GA) Download Now
Download | Release Notes | Changelog | Overview of 10.3
Release date: 14 May 2019
MariaDB 10.3 is an evolution of MariaDB 10.2 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
MariaDB 10.3.15 is a Stable (GA) release.
For an overview of MariaDB Server 10.3 see the What is MariaDB 10.3? page.
Thanks, and enjoy MariaDB!
- Assertion ``(thd->lex)->current_select'failed inMYSQLparse(), query with VALUES()`
- 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
Merge InnoDB changes from MySQL 5.6.44 and 5.7.26
Fixes of corruption or crashes: , , , , ,
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.3 is:MariaDB 10.3.39 Stable (GA) Download Now
Download | Release Notes | Changelog | Overview of 10.3
Release date: 4 Oct 2018
MariaDB 10.3 is an evolution of MariaDB 10.2 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
MariaDB 10.3.10 is a Stable (GA) release.
For an overview of MariaDB Server 10.3 see the What is MariaDB 10.3? page.
Thanks, and enjoy MariaDB!
Notable changes of this release include:
- Added the
- if available, stunnel can be used during
- add new system variable to speed up queries that new long nested IN lists. For backward compatibility the default value is 0, meaning "unlimited".
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: 23 Dec 2017
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.
is a release.
For an overview of see the page.
Thanks, and enjoy MariaDB!
read_only will not be logged even after read_only mode is disabled (for example if the replica is promoted to a primary).The Admin statements , and will not be logged to the binary log under read-only.
MDEV-20621: FULLTEXT INDEX activity causes InnoDB hang
Binlog checksum verification at recovery time (MDEV-23832)
Verbose print-out of by (MDEV-22330)
from validates when binlog checksummed (MDEV-21839)
Freeing memory of (MDEV-23534)
Corrected verbose output for multi-record Rows-log-event (MDEV-16372)
no longer causes crash (MDEV-20744)
that were running an index condition pushdown in InnoDB will now return an error (MDEV-23938)
Wrong direxec param data caused crash; Numerous fixes about Mac builds (by Dmitri Shulga) (MDEV-19838)
now logs proxy users (MDEV-19443)
Crash on SELECT on a table with indexed virtual columns (MDEV-18366)
updated to 5.7.32 (MDEV-23989)
Bug fixes related to adaptive hash index (MDEV-23452, MDEV-23370)
Fixed a bug in the recovery of encrypted tables (MDEV-23456)
Fixed a race condition in MVCC reads (MDEV-22924)
ALTER TABLE fixes (MDEV-22277, MDEV-22939, MDEV-23685, MDEV-23722)
Diskspace not reused for BLOB in data file (MDEV-23072)
InnoDB: Failing assertion: !space->referenced() (MDEV-23651)
SIGSEGV in maria_create() because of double free (MDEV-23222)
CREATE TEMPORARY TABLE .. LIKE (system versioned table) returns error if unique index is defined in the table (MDEV-23968)
Error upon querying the view, that selecting from versioned table with partitions (MDEV-23779)
CREATE .. SELECT wrong result on join versioned table (MDEV-23799)
Fixed a crash with the function (MDEV-15180)
Computing certain on a server started with could cause a wrong query result or crash (MDEV-23867)
A query with a certain form of WHERE clause over a table with multiple indexes could pick a less efficient range plan (MDEV-23811)
Fixed a memory leak for correlated subqueries with ROLLUP (MDEV-17066)
Fixed SIGSEGV in lock_rec_unlock (MDEV-23101)
Fixed replication of timezone if only 1 timezone is loaded (MDEV-22626)
Fixed replication of (MDEV-21578)
Fixed SST FLUSH TABLES WITH READ LOCK timeout (MDEV-22543)
Fixes for the following :
()
()
MDEV-18899 - Server crashes in Field::set_warning_truncated_wrong_value
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 :
MDEV-13564 - mariadb-backup does not work with TRUNCATE
MDEV-15872 - Crash in online ALTER TABLE...ADD PRIMARY KEY after instant ADD COLUMN...NULL
MDEV-17003 - service_manager_extend_timeout() being called too often
MDEV-17196 - Crash during instant ADD COLUMN with long DEFAULT value
MDEV-16328 - ALTER TABLE...page_compression_level should not rebuild table
The Galera library in the repositories has been updated to version 25.3.24.
Also all changes from MariaDB 10.2.18
Fixes for the following :
This is the first beta release in the MariaDB 10.3 series.
Notable changes of this release include:
. As a result, the function has been renamed to VALUE() (MDEV-12172) — GSoC 2017 project by Galina Shalygina
(MDEV-12176) — GSoC 2017 project by Galina Shalygina
now supports local SP variables (MDEV-14139)
() — GSoC 2016 project by Varun Gupta
supports "leaves" algorithm () — contribution by Heinz Wiesinger
Support for clause in ()
, , and ()
statement ()
()
Oracle compatible function () — contribution by Jérôme Brauge
() — GSoC 2016 project by Sachin Setiya
Various scalability improvements (, )
can now be used with DEFAULT.
merged into the server () — contribution by Alibaba
Numerous improvements for the partition engine () — contribution by Kentoku Shiba
HANDLER support, condition pushdown, MRR, fulltext search, aggregate pushdown, bulk update/delete
updated to version 3.3.13
Join push-down for Spider 3.3 () — contribution by Kentoku Shiba
As per the , this will be the last release of for RHEL 7.2 and CentOS 7.2. Starting with the next 10.3 release we will be building MariaDB for CentOS 7 and RHEL 7 on version 7.3.
updated to 25.3.22
for Ubuntu 17.10 Artful added
MDEV-14717 crash-safe RENAME TABLE
MDEV-14585 Automatically remove #sql- tables in InnoDB dictionary during recovery
MDEV-12323 Rollback progress log messages during crash recovery are intermixed with unrelated log messages
MDEV-14589 InnoDB should not lock a delete-marked record
Use fewer transactions for updating InnoDB persistent statistics
- UT_DELAY code : Removing hardware barrier for arm64 bit platform
InnoDB update_time is wrongly updated after partial rollback or internal COMMIT
Support CRC32 SSE4.2 implementation under Windows
New , EMPTY_STRING_IS_NULL (MDEV-14013) — contribution by Jérôme Brauge
Added as a system variable (MDEV-12542).
New status variables , , , (MDEV-11153)
is now dynamic (MDEV-11025)
() — contribution by Jun Su.
is now set by default to one level less than server maturity. This may cause plugins below that maturity level that were previously working to no longer load ().
now correctly detects and reports tcmalloc ()
New variables , , () — contribution by Oleg Obleukhov
tcp_linger, tcp_linger_timeout () — contribution by Shuode Li
, allowing one to specify certain operations resulting in an error during replication to be retried, and allowing the retry interval for a failed transaction to be set () — contribution by Kentoku Shiba
In addition to K, M, and G, numeric command-line options now support — contribution by Daniel Black
Do not use beta releases on production systems!
For a complete list of changes made in MariaDB 10.3.3, with links to detailed information on each push, see the changelog.
The most recent release of MariaDB 10.3 is:MariaDB 10.3.39 Stable (GA) Download Now
Download | Release Notes | Changelog | Overview of 10.3
Release date: 16 Apr 2017
MariaDB 10.3 is the new development series of MariaDB. It is an evolution of MariaDB 10.2 with several entirely new features not found anywhere else.
MariaDB 10.3.0 is an Alpha release.
Do not use alpha releases in production!
For an overview of MariaDB 10.3 see theWhat is MariaDB 10.3? page.
Thanks, and enjoy MariaDB!
This is the first release in the series. Alpha releases are useful for testing and planning, but should not be used in production.
Notable additions in this release include:
-
and . These are both now and can no longer be used as an without being quoted -
data type for variables - , ,
Connections with idle transactions can be automatically killed after a specified time period by means of the , and system variables.
When running with , the server now understands a subset of Oracle's PL/SQL language instead of the traditional MariaDB syntax for stored routines. This work is in progress. See and for the current status and subtasks. The 10.3.0 release includes:
Providing compatibility for basic PL/SQL constructs -
%TYPE in variable declarations -
cursor%ROWTYPE in variable declarations -
table%ROWTYPE in variable declarations -
10.3 continues refactoring for the data type API started in 10.2, which will make it possible to have user data type plugins. This work is still in progress (see for the current status and subtasks). Most of the task in this category do not change the server behavior. Some tasks implemented in 10.3.0 do have a good visible effect:
An expression of the data type is not allowed any more:
as an argument to functions ABS(), CEILING(), FLOOR(), ROUND(), SUM(), AVG(), VARIANCE(), CAST(AS..), as well as to the unary minus operator - , , ,
as an argument to hybrid functions such as CASE, COALESCE, IF which have other arguments of the numeric or temporal data types -
The following new system variables have been added:
The following new status variables have been added:
See the page for an overview of .
Do not use alpha releases in production!
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.3 is:MariaDB 10.3.39 Stable (GA) Download Now
Download | Release Notes | Changelog | Overview of 10.3
Release date: 10 Aug 2020
MariaDB 10.3 is the previous stable series of MariaDB, and an evolution of MariaDB 10.2 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
MariaDB 10.3.24 is a Stable (GA) release.
For an overview of MariaDB Server 10.3 see the What is MariaDB 10.3? page.
Thanks, and enjoy MariaDB!
Limit to 255 ().
Minimum value of raised to 8 (previously 4) so fixed size like and are not truncated for lower values of max_sort_length ().
Fixed corruption in delete buffering ()
Fixed a deadlock in FLUSH TABLES…FOR EXPORT ()
InnoDB data file extension is not crash-safe ()
Minor fixes related to encryption and FULLTEXT INDEX
Make the binlog dump thread to log into errorlog a requested GTID position ()
Fix stop of the optimistic parallel slave at requested START-SLAVE-UNTIL position ()
Properly handle RESET MASTER TO value, when the value exceeds the max allowed 2147483647 ()
ALTER TABLE ... ANALYZE PARTITION ... with EITS reads and locks all rows ... ()
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 ()
LATERAL DERIVED is not clearly visible in EXPLAIN FORMAT=JSON, make LATERAL DERIVED
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 ()
data type qualifier allowing MariaDB native date types in an SQL_MODE that has conflicting data type translations.
MariaDB could crash after changing the query_cache size ()
Errors and SIGSEGV on CREATE TABLE w/ various charsets (
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 .
anchored data types for variables - MDEV-12461
with parameters - MDEV-12457
FOR loop statement - MDEV-10580
Implicit cursor FOR loop - MDEV-12098
Explicit cursor FOR LOOP - MDEV-10581
Cursors with parameters - MDEV-10597
Implicit cursor FOR LOOP for cursors with parameters - MDEV-12314
Explicit cursor attributes %ISOPEN, %ROWCOUNT, %FOUND, %NOTFOUND - MDEV-10582
SQL%ROWCOUNT - MDEV-10583
Variable declarations can go after cursor declarations - MDEV-10598
Predefined exceptions: TOO_MANY_ROWS, NO_DATA_FOUND, DUP_VAL_ON_INDEX - MDEV-10839
RAISE statement for predefined exceptions - MDEV-10840
User defined exceptions - MDEV-10587
SP control functions SQLCODE, SQLERRM - MDEV-10578
Triggers: Understand :NEW.c1 and :OLD.c1 instead of NEW.c1 and OLD.c1 - MDEV-10579
Dynamic SQL placeholders - MDEV-10801
Allow VARCHAR and VARCHAR2 without length as a data type of routine parameters and in RETURN clause - MDEV-10596
CAST(..AS VARCHAR(N)) - MDEV-11275
Anonymous blocks - MDEV-10655
GOTO statement - MDEV-10697
Allow SELECT UNIQUE as a synonym for SELECT DISTINCT - MDEV-12086
Do not require BEGIN..END in multi-statement exception handlers in THEN clause - MDEV-12088
Understand optional routine name after the END keyword - MDEV-12089
Inside routines the CALL keywoard is optional - MDEV-12107
Make the concatenation operator ignore NULL arguments - MDEV-11880
make the CONCAT function ignore NULL arguments - MDEV-12143
TRUNCATE TABLE t1 [ {DROP|REUSE} STORAGE ] - MDEV-10588
Providing compatibility for basic SQL data types - MDEV-10343
as an argument to operators +, -, *, /, MOD - MDEV-12238
Wrong result for INSERT INTO t1 (datetime_field) VALUES (hybrid_function_of_TIME_data_type) - MDEV-11331
Expect "Impossible where condition" for WHERE timestamp_field>=DATE_ADD(TIMESTAMP'9999-01-01 00:00:00',INTERVAL 1000 YEAR) - MDEV-11333
SP variables of temporal data types do not replicate correctly - MDEV-11815
Incorrect result for (time_expr BETWEEN timestamp_exp1 AND timestamp_expr2) - MDEV-11482
Wrong result for CASE on a mixture of signed and unsigned expressions - MDEV-11554
Wrong result for (int_expr IN (mixture of signed and unsigned expressions)) - MDEV-11497
CASE with a mixture of TIME and DATETIME returns a wrong result - MDEV-11555
SP variables of the SET data type erroneously allow values with comma - MDEV-11146
mysql_list_field() returns wrong default values for VIEW - MDEV-11672
Dropping the adaptive hash index may cause DDL to lock up InnoDB (MDEV-22456)
innodb_log_optimize_ddl=OFF is not crash safe (MDEV-21347)
Mariadb service won't shutdown when it's running and the OS datetime updated backwards (MDEV-17481)
Doublewrite recovery can corrupt data pages (MDEV-11799)
Fixed race conditions related to buffer pool resizing
ALTER TABLE fixes (MDEV-22637, MDEV-23244)
Crash recovery fixes (MDEV-21347, MDEV-23190, MDEV-11799)
Eliminate deadlock involving parallel workers, STOP SLAVE and FLUSH TABLES WITH READ LOCK (MDEV-23089)
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 (MDEV-14203)
Refine mysqlbinlog output to print out START TRANSACTION at Gtid_log_event processing which satisfies clients that submit the output with sql_mode=oracle (MDEV-23108)
Replication aborts with ER_SLAVE_CONVERSION_FAILED upon CREATE ... SELECT in ORACLE mode (MDEV-19632)
EXPLAIN FORMAT=JSONCrash on WITH RECURSIVE large query (MDEV-22748)
Crash with Prepared Statement with a '?' parameter inside a re-used CTE (MDEV-22779)
Crash in CREATE TABLE AS SELECT when the precision of returning type = 0 (MDEV-22502)
XA: Reject DDL operations between PREPARE and COMMIT (MDEV-22420)
Stop mariadb-backup --prepare on errors during innodb redo log applying (MDEV-22354)
Server crashes in mysql_alter_table upon adding a non-null date column under NO_ZERO_DATE with ALGORITHM=INPLACE (MDEV-18042)
Can't uninstall plugin if the library file doesn't exist (MDEV-21258)
As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.3 for Ubuntu 19.10 Eoan and Fedora 30
Fixes for the following :
MariaDB 10.3 is no longer maintained. Please use a more recent release.
The most recent release of MariaDB 10.3 is:MariaDB 10.3.39 Stable (GA) Download Now
MariaDB 10.3 is a previous major stable version. The first stable release was in May 2018, and it was maintained until May 2023.
For details on upgrading from MariaDB 10.2, see .
MariaDB Server 10.3 is included in MariaDB TX 3.0. Watch the webinar recording to learn more about the new features included in this release.
The following lists the major new features in MariaDB 10.3:
()
(also known as AS OF) ()
() — GSoC 2017 project by Galina Shalygina
() — GSoC 2017 project by Galina Shalygina
now supports local SP variables ()
As a result of implementing Table Value Constructors, the has been renamed to VALUE() ()
When running with , the server now understands a subset of Oracle's PL/SQL language instead of the traditional MariaDB syntax for stored routines. See , and to know the current status.
New , EMPTY_STRING_IS_NULL.
() — Tencent Game DBA Team, developed by willhan, also thanks to AliSQL.
On Linux, shrink the core dumps by omitting the InnoDB buffer pool ()
Temporary files created by merge sort and row log are encrypted if is set to 1, regardless of whether the table encrypted or not ().
Condition pushdown through PARTITION BY clause of ()
New was introduced.
Numerous performance improvements for high-concurrency load
Numerous scalability and performance improvements to global data structures, including ,
now has a new mode, 3, which skips the rollback of connected transactions ()
The has been updated to 3.3.13. The partitioning storage engine has been updated to support all the new Spider features including:
Direct join support. This allows Spider to do JOINS and GROUP BYs internally.
Direct update and delete.
Direct aggregates.
and allow more control over handling delays or conflicts when applying binary logs.
Most of the features were done as part of .
now supports the "leaves" algorithm () — contribution by Heinz Wiesinger
Numerous improvements for the partition engine () — contribution by Kentoku Shiba
Full text support.
Multi-range-read (Gives better performance when handling multiple ranges).
Support for condition pushdown.
The Information Schema is optimized to use much less memory when selecting from or any other table with many or columns ()
The now displays info in the EXTRA column -
Disable logging of certain statements to the or the with the and system variables.
A new option to , filsort_priority_queue.
Per-engine mysql.gtid_slave_pos tables () — Implemented by Kristian Nielsen funded by Booking.com.
10.3 continues refactoring for the data type API started in 10.2, which will make it possible to have user data type plugins. This work is still in progress (see for the current status and subtasks). Most of the task in this category do not change the server behavior. Some tasks do have a .
Connections with idle transactions can be automatically killed after a specified time period by means of the , and system variables.
For a list of all new variables, see and .
New system variable .
New system variable for restricting the direct setting of a session timestamp ()
is enabled by default ()
Remove deprecated variables , , and .
For a complete list of security vulnerabilities (CVEs) fixed across all versions of MariaDB, see the page.
:
:
:
:
(MDEV-7773) — GSoC 2016 project by Varun Gupta
Support for clause in (MDEV-11297)
, , and (MDEV-12985)
statement (MDEV-14415)
Oracle compatible function (MDEV-14012) — contribution by Jérôme Brauge
(MDEV-10177) — GSoC 2016 project by Sachin Setiya
Various scalability improvements (MDEV-14529, MDEV-14505)
merged into the server (MDEV-13073) — contribution by Alibaba
and . These are both now and can no longer be used as an without being quoted (MDEV-10141)
data type for variables (MDEV-10914, MDEV-12007, MDEV-12291)
anchored data types for variables (MDEV-12461)
with parameters (MDEV-12457)
function (MDEV-12685)
statement can delete from the table that is used in a subquery in the WHERE clause (MDEV-12137)
Stored routine parameters can use (MDEV-13581)
The server now - see also the new system variable (MDEV-11159)
(MDEV-11369) — Tencent Game DBA Team, developed by vinchen.
(MDEV-12874) — from Jerome Brauge.
and in multi-table update (MDEV-13911)
- 3 argument form of DATE_FORMAT (MDEV-11553)
The MariaDB SQL/PL stored procedure dialect (enabled with sql_mode=ORACLE) now supports Oracle style packages. Support for the following statements has been added (MDEV-10591):
New SIMULTANEOUS_ASSIGNMENT to make the SET part of the statement evaluate all assignments simultaneously, not left-to-right.
Correctness improvement - TRUNCATE honors transactional locks (MDEV-15061)
Windows binaries now use high-precision timer when available (MDEV-15694). This makes much less probable for two queries to have the same CURRENT_TIMESTAMP(6) value, for example.
Two new options, INSTANT and NOCOPY, which allow operations that would require any data files to be modified, or that would require rebuilding the clustered index respectively, to be refused rather than potentially perform slowly (MDEV-13134)
--ignore-database option (MDEV-13336)
Functions that used to only return 64-bit now can return 32-bit results (MDEV-12619).
Performance improvements to persistent data structures: MDEV-15090, MDEV-15132
HANDLER support
Aggregate pushdown
Bulk update/delete
- permits seeing which version of the source was used for the build (MDEV-12583).
Added as a system variable (MDEV-12542).
The max value of the system variable has been increased from 1048576 to 4294967295
The variable can now be modified without restarting the server (MDEV-15501)
Stable (GA)
15 Aug 2022
Stable (GA)
20 May 2022
Stable (GA)
12 Feb 2022
Stable (GA)
9 Feb 2022
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)
14 May 2019
Stable (GA)
2 Apr 2019
Stable (GA)
21 Feb 2019
Stable (GA)
7 Jan 2019
Stable (GA)
20 Nov 2018
Stable (GA)
4 Oct 2018
Stable (GA)
15 Aug 2018
Stable (GA)
2 Jul 2018
Stable (GA)
25 May 2018
Stable (GA)
16 Apr 2018
Release Candidate (RC)
26 Feb 2018
Release Candidate (RC)
18 Jan 2018
Beta
23 Dec 2017
Beta
9 Oct 2017
Alpha
29 Aug 2017
Alpha
16 Apr 2017
Alpha
10 May 2023
Stable (GA)
6 Feb 2023
Stable (GA)
7 Nov 2022
The most recent release of MariaDB 10.3 is:MariaDB 10.3.39 Stable (GA) Download Now
Download | Release Notes | Changelog | Overview of 10.3
Release date: 7 Jan 2019
MariaDB 10.3 is an evolution of MariaDB 10.2 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
MariaDB 10.3.12 is a Stable (GA) release.
For an overview of MariaDB Server 10.3 see the What is MariaDB 10.3? page.
Thanks, and enjoy MariaDB!
- Stack-buffer-overflow with indexed varchar (utf8) field
- possible in read-only mode (forbid ALTER DATABASE in read_only)
- does not handle
- Assertion `inited==NONE || (inited==RND && scan)' failed in handler::ha_rnd_init(bool) with InnoDB, joins, AND/OR conditions
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 .
MDEV-18105 - MariaDB Backup fails to copy encrypted InnoDB system tablespace if LSN>4G
MDEV-17470 - Orphan temporary files after interrupted cause InnoDB: Operating system error number 17 and eventual fatal error 71
MDEV-17765: Locking bug fix for SPATIAL INDEX
ALTER TABLE Fixes for FULLTEXT INDEX: MDEV-17923, MDEV-17904, MDEV-17938
Other ALTER TABLE fixes: MDEV-17470, MDEV-17833, MDEV-17815, MDEV-18039, MDEV-18041
Fixes for regressions introduced in MariaDB 10.3.10 by the backup-safe TRUNCATE TABLE (MDEV-13564, innodb_safe_truncate=ON) and innodb_undo_log_truncate:
Several improvements to MariaDB Server and backup for dealing with encrypted or page_compressed pages:
MDEV-17957: Make stricter for strict_* values
MDEV-17958: On little-endian systems, remove bug-compatible variant of
MDEV-12112: corruption in encrypted table may be overlooked
: fails to detect corrupted page_compressed=1 tables
Virtual columns: MDEV-17199 Assertion `pos < table->n_v_def' failed after upgrade from before 10.2
MDEV-17881: Assertion failure in cmp_dtuple_rec_with_match_bytes after instant ADD COLUMN
The Galera library in the repositories has been updated to version 25.3.25
Experimental packages for the RedHat 8 beta have been added in this release. See the package repository tool to configure the repository and for installation instructions.
Fixes for the following :
CVE-`-```
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