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...
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 .
MariaDB 10.3 was a long-term maintenance series of MariaDB maintained until May 2023
The most recent release of MariaDB 10.3 is:MariaDB 10.3.39 Stable (GA) Download Now
Download 10.3.25 | Release Notes | Changelog | Overview of 10.3
Release date: 7 Oct 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.25 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!
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!
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.
The most recent release of MariaDB 10.3 is:MariaDB 10.3.39 Stable (GA) Download Now
Download 10.3.34 | Release Notes | Changelog | Overview of 10.3
Release date: 12 Feb 2022
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.34 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 release fixes a blocking problem with the release when manually running . ()
See for other changes since the previous release.
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 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)
| | |
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: 23 Jun 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: 11 Sep 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: 21 Feb 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: 4 Oct 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.
Thanks, and enjoy MariaDB!
The most recent release of is: Stable (GA)
| | |
Release date: 2 Jul 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!
| | |
Release date: 6 Feb 2023
is the previous stable series of MariaDB, supported until May 2023, 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!
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--``#
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.
This version of MariaDB is being released now to fix the following two regressions:
Table alias from previous statement interferes later commands (MDEV-25672)
Join using derived with aggregation returns incorrect results (MDEV-25714)
In addition to the above, this release also contains the following fixes:
Change buffer entries are lost on InnoDB restart (MDEV-25869)
InnoDB spatial indexes miss large geometry fields after MDEV-25459 (MDEV-25758)
Double free of transaction during truncate operation (MDEV-25663)
Double free of table when inplace alter FTS add index fails (MDEV-25721)
Potential hang in purge for virtual columns ()
Change buffer entries for secondary indexes are lost on InnoDB restart ()
Do not replicate killed multi-table OPTIMIZE TABLE when the signal arrives before any table has been processed (MDEV-22530)
Fix optistic parallel applier to not deadlock on admin commands OPTIMIZE, REPAIR, and ANALYZE (MDEV-17515)
Backport MDEV-20821 parallel slave server shutdown hang (MDEV-22370)
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.30, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.3.30, see the MariaDB Foundation release announcement.
updated to Connect 1.06.0010
MDEV-20066: This bug could cause a table to become corrupt if a column was added instantly
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
: 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
: row_ins_step accesses uninitialized memory
: for RHEL 8 ppc64le added
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.18, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.3.18, see the MariaDB Foundation release announcement.
MDEV-18254: updated to 9.5
MDEV-17475: Maximum value of is now 2097152.
mariadb-backup fixes: MDEV-18185, MDEV-18201, MDEV-18194, MDEV-18415, MDEV-18611
InnoDB ALTER TABLE fixes: , , , , , , , ,
InnoDB crash recovery fixes: , ,
Galera crash recovery fixes:
: COM_RESET_CONNECTION changes the connection encoding
binlog fixes: &
updated to 3.3.14
Fixed some crashes and a few wrong results with Spider
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.13, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.3.13, see the MariaDB Foundation release announcement.
Notable changes of this release include:
MDEV-14474 - Added the
MDEV-15511 - if available, stunnel can be used during
MDEV-16934 - add new system variable to speed up queries that new long nested IN lists. For backward compatibility the default value is 0, meaning "unlimited".
- mariadb-backup does not work with TRUNCATE
- Crash in online ALTER TABLE...ADD PRIMARY KEY after instant ADD COLUMN...NULL
- service_manager_extend_timeout() being called too often
- Crash during instant ADD COLUMN with long DEFAULT value
- ALTER TABLE...page_compression_level should not rebuild table
The in the repositories has been updated to version 25.3.24.
Also all changes from
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.10, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.3.10, see the MariaDB Foundation release announcement.
Notable changes of this release include:
MDEV-8743 - O_CLOEXEC on innodb/xtradb temp files
MDEV-16267 - Wrong INFORMATION_SCHEMA.INNODB_BUFFER_PAGE.TABLE_NAME
MDEV-13779 - InnoDB fails to shut down purge, causing hang
MDEV-16283 - ALTER TABLE...DISCARD TABLESPACE still takes long on a large buffer pool
- Upgrade failure from 10.1 innodb_encrypt_log
- ASAN: heap-use-after-free in gcol.innodb_virtual_debug
- innodb_defragment=ON trumps innodb_optimize_fulltext_only=ON in OPTIMIZE TABLE
- fil_rename_tablespace() times out and crashes server during table-rebuilding ALTER TABLE
- Crash on IMPORT TABLESPACE of a ROW_FORMAT=COMPRESSED table
- InnoDB error "returned OS error 71" complains about wrong path
- SET GLOBAL innodb_change_buffering has no effect
- Deal with page_compressed page corruption
- Due to the failure of foreign key detection, Galera slave node killed himself
- mariadb-backup: Implement --verbose option to instrument InnoDB log apply
- Inconsistent SELECT results when query cache is enabled
- ASAN heap-use-after-free in mem_heap_dup or dfield_data_is_binary_equal
- Allow instant change of WITH SYSTEM VERSIONING column attribute
- Setting a column NOT NULL fails to return error for NULL values when there is no DEFAULT
- Alter InnoDB Partitioned Table Moves Files (which were originally not in the datadir) to the datadir
: now supports
As per the , this will be the last release of for Ubuntu 17.10 Artful
For a complete list of changes made in MariaDB 10.3.8, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.3.8, see the MariaDB Foundation release announcement.
As mentioned in the 10.3.37 release notes, 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 this blog post and the page for more details.
corruption with (MDEV-25004)
Parallel slave applying in binlog order is corrected for admin class of commands including ANALYZE (MDEV-30323)
is now shown now more precisely at the slave applier start, including in the delayed mode (MDEV-29639)
mysqlbinlog --verbose is made to show the type of compressed columns (MDEV-25277)
Infinite sequence of recursive calls when processing embedded CTE (MDEV-30248)
Crash with a query containing nested WINDOW clauses (MDEV-30052)
Major performance regression with 10.6.11 (MDEV-29988)
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.38, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.3.38, 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.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 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 10.3.28 | Release Notes | Changelog | Overview of 10.3
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.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.28 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!
- 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
- add master host/port info to slave thread exit messages
- anomalies in mysql.user tables on previously 5.7 MySQL versions corrected
- option
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: 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 is: Stable (GA)
| | |
Release date: 15 Aug 2022
is the previous stable series of MariaDB, supported until May 2023, 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)
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 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)
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!
The most recent release of is: Stable (GA)
| | |
Release date: 31 Jul 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: 26 Feb 2018
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.
Do not use non-GA releases on production systems!
For an overview of see the page.
Thanks, and enjoy MariaDB!
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
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)
MDEV-25179 - and system variables are now read-only
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 corruption due to lack of file locking (MDEV-28495)
FULLTEXT search with apostrophe, and mandatory words (MDEV-20797)
ALTER TABLE IMPORT TABLESPACE corrupts an encrypted table (MDEV-28779)
ER_SLAVE_INCIDENT error is specified now on slave to be seen with SHOW-SLAVE-STATUS (MDEV-21087)
INCIDENT_EVENT is no longer binlogged when a being logged transaction can be safely rolledback (MDEV-21443)
sequences related row-format events are made to correspond to binlog_row_image (MDEV-28487)
Server crash in JOIN_CACHE::free or in copy_fields (MDEV-23809)
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 (MDEV-29139)
A query with a subuquery in this form could cause a crash:
MariaDB Server SEGV on INSERT .. SELECT (MDEV-26427)
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 (MDEV-28749)
Subquery semi-join optimization could miss LooseScan or FirstMatch strategies for certain queries.
Optimizer uses all partitions after upgrade to 10.3 ()
For multi-table UPDATE or DELETE queries, the optimizer failed to apply Partition Pruning optimization for the table that is updated or deleted from.
CONNECT Engine now supports with Mysql Table type (MDEV-27766)
New option, -enable-cleartext-plugin. Option does not do anything, and is for MySQL-compatibility purposes only.
Crash in (MDEV-29188)
As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.3 for Debian 10 "Buster" for ppc64el
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.36, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.3.36, 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
As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.3 for Ubuntu 19.04 Disco
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
: Assertion `t->first->versioned_by_id()' failed in innodb_prepare_commit_versioned
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-21383: Possible range plan is not used under certain conditions
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 :
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.22, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.3.22, 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.
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
Adjust spin loops to the x86 PAUSE instruction latency ()
: 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
: mysql_upgrade_service throws exception upgrading from 10.0 to 10.3
: Server crash in row_upd_del_mark_clust_rec or Assertion
: Compressed columns cannot be restored from dump
As per the , this will be the last release of for Ubuntu 18.10 "Cosmic"
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.17, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.3.17, see the MariaDB Foundation release announcement.
The PL/SQL stored procedure dialect (enabled with sql_mode=ORACLE) now supports Oracle style packages. Support for the following statements has been added (MDEV-10591):
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 , , , ,
Correctness improvement - honors transactional locks ()
Performance improvements to persistent data structures: ,
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
On Linux, shrink the core dumps by omitting the (MDEV-10814)
Fix upgrades from earlier versions (MDEV-15370)
New status variable (MDEV-11455)
As per the MariaDB Deprecation Policy, 10.3 binary tarball packages for GLIBC_2.5 (that were built on CentOS 5) have been discontinued.
MariaDB 10.3.5 includes all bug fixes from MariaDB 10.2.13, including the following:
MDEV-11415 Remove excessive undo logging during
Faster startup when no crash recovery is deeded (MDEV-15333, MDEV-13869)
Do not use non-GA releases on production systems!
For a complete list of changes made in MariaDB 10.3.5, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.3.5, 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 10.3.29 | Release Notes | Changelog | Overview of 10.3
Release date: 7 May 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.29 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!
for calculating the spherical distance between two geometries (point or multipoint) on a sphere ()
Crash with invalid multi-table update of view in 2nd execution of SP ()
Incorrect name resolution for subqueries in ON expressions ()
Complex query in Store procedure corrupts results ()
RENAME TABLE causes "Ignoring data file" messages ()
Deprecated the *innodb and *none options in ()
MVCC read from index on CHAR or VARCHAR wrongly omits rows ()
Race conditions in persistent statistics (, , )
Replication Heartbeat event was uncapable to cary 4GB+ offsets ()
FLUSH LOGS race against Binlog checkpoint event creation ()
slave_compressed_protocol did not work correctly with semi-sync ()
updated to 25.3.33
SET PASSWORD command fail with wsrep api ()
Long BF log wait turns on InnoDB Monitor output without telling, never turns it off ()
The QUERY_DDL setting now logs CREATE/DROP [PROCEDURE / FUNCTION / USER] statements. See . ()
As per the , this will be the last release of for Ubuntu 16.04 Xenial
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: 12 May 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.23 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!
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. ()
now correctly lists the Delete history privilege, rather than displaying it as Delete versioning rows. ()
updated to 11.0 ()
Introduce a file format constraint to ALTER TABLE. See ()
ALTER TABLE, FORCE all partition to rebuild if any one of the partition does rebuild ()
ALTER TABLE, InnoDB aborts while adding instant column for discarded tablespace ()
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.3 is:MariaDB 10.3.39 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.3
Alternate download from mariadb.org
Release date: 5 Nov 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.19 is a release.
For an overview of MariaDB Server 10.3 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
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: 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: 17 Jun 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.16 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!
: and
: show tables fails when selecting the information_schema database
: multi-update with triggers and stored routines
: InnoDB crashes when trying to recover a corrupted page
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: 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 is: Stable (GA)
| | |
Release date: 10 Aug 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-KEY... ANY (SELECT ... GROUP BY (SELECT redundant_subselect_here)) ...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)
DELETE HISTORY may delete current data on system-versioned table (MDEV-25468)
Crashes with nested table value constructors (MDEV-22786)
Optimizer, Wrong query results with optimizer_switch="split_materialized=on" (MDEV-21614)
SHOW GRANTS does not quote role names properly (MDEV-20076)
Paritioning INSERT chooses wrong partition for RANGE partitioning by DECIMAL column (MDEV-21195)
mariadb-backup does not honor ignore_db_dirs from server config (MDEV-19347)
mariadb-backup --ftwrl-wait-timeout never times out on explicit lock (MDEV-20230)
FULLTEXT INDEX, Assertion ``!table->fts->in_queue' failed in fts_optimize_remove_table` (MDEV-21550)
Wrong 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)
Packages and repositories for Ubuntu 20.04 "focal" added
As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.3 for Debian 8 "Jessie"
Fixes for the following :
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.
Changes to temporary tables created during 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.
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
System-Versioned Tables:
MDEV-16210: FK constraints on versioned tables use historical rows, which may cause constraint violation
MDEV-20812: Unexpected ER_ROW_IS_REFERENCED_2 or server crash in row_ins_foreign_report_err upon DELETE from versioned table with FK
Galera wsrep library updated to 25.3.28
Packages for Ubuntu 19.10 Eoan have been added in this release
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-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 :
MDEV-19725: Incorrect error handling in ALTER TABLE
MDEV-19445: FULLTEXT INDEX fix
MDEV-19486: System Versioning fix
MDEV-19509: InnoDB skips the tablespace in rotation list
MDEV-19614: SET GLOBAL innodb_ deadlock due to LOCK_global_system_variables
MDEV-17458: Unable to start galera node
MDEV-17456: Malicious SUPER user can possibly change audit log configuration without leaving traces
MDEV-19588: Wrong results from query, using left join
MDEV-19258: RIGHT JOIN hangs in MariaDB
Virtual columns fixes: MDEV-19027, MDEV-19602
Crash recovery fixes: MDEV-13080, MDEV-19587, MDEV-19435
MDEV-11094: Fixed row-based event applying with an error anymore when the events aim at the blackhole engine and row annotation is enabled
MDEV-19076: 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
MDEV-19158: 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 MariaDB Deprecation Policy, this will be the last release of MariaDB 10.3 for OpenSUSE 42.3
Fixes for the following :
CVE-`-```
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"
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).
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
ALTER TABLE fixes (, )
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 ()
Refine mysqlbinlog output to print out START TRANSACTION at Gtid_log_event processing which satisfies clients that submit the output with sql_mode=oracle ()
Replication aborts with ER_SLAVE_CONVERSION_FAILED upon CREATE ... SELECT in ORACLE mode ()
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)
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 (MDEV-5924)
Errors and SIGSEGV on CREATE TABLE w/ various charsets ()
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 ()
As per the , this will be the last release of for Ubuntu 19.10 Eoan and Fedora 30
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.24, see the MariaDB Foundation release announcement.
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: 3 Nov 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 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: 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!
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.
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 ()
ALTER TABLE fixes (, , , )
Diskspace not reused for BLOB in data file ()
InnoDB: Failing assertion: !space->referenced() ()
SIGSEGV in maria_create() because of double free ()
CREATE TEMPORARY TABLE .. LIKE (system versioned table) returns error if unique index is defined in the table ()
Error upon querying the view, that selecting from versioned table with partitions ()
CREATE .. SELECT wrong result on join versioned table ()
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 ()
Fixed a memory leak for correlated subqueries with ROLLUP ()
Galera wsrep library updated to 25.3.31
Fixed galera got stuck after flush tables (MDEV-22707)
Fixed data loss on rolling upgrade between 10.3 and 10.4 (MDEV-22723)
IPv6 SST handling improved (MDEV-21770, MDEV-23576, MDEV-23580, MDEV-23581, MDEV-23574)
Fixed SIGSEGV in lock_rec_unlock ()
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.3 for CentOS/RHEL 6 and Fedora 31
Packages for Ubuntu 20.10 "Groovy Gorilla" added
Packages for Debian 10 "buster" arm64 and ppc64el added
Packages for Debian 9 "stretch" arm64 added
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.26, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.3.26, 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.
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 | 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 | 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 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!
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
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: 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 .
The most recent release of is: Stable (GA)
| | |
Release date: 16 Apr 2017
is the new development series of MariaDB. It is an evolution of with several entirely new features not found anywhere else.
is an release.
Do not use alpha releases in production!
For an overview of 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!
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 is the first alpha release in the MariaDB 10.3 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 - MDEV-10141
data type for variables - MDEV-10914, MDEV-12007,
anchored data types for variables -
with parameters -
- ,
Connections with idle transactions can be automatically killed after a specified time period by means of the , and system variables.
When running with sql_mode=ORACLE, 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 MDEV-10142 and MDEV-10764 for the current status and subtasks. The 10.3.0 release includes:
Providing compatibility for basic PL/SQL constructs - MDEV-10411
%TYPE in variable declarations - MDEV-10577
cursor%ROWTYPE in variable declarations - MDEV-12011
table%ROWTYPE in variable declarations - MDEV-12133
FOR loop statement -
Implicit cursor FOR loop -
Explicit cursor FOR LOOP -
Cursors with parameters -
Implicit cursor FOR LOOP for cursors with parameters -
Explicit cursor attributes %ISOPEN, %ROWCOUNT, %FOUND, %NOTFOUND -
SQL%ROWCOUNT -
Variable declarations can go after cursor declarations -
Predefined exceptions: TOO_MANY_ROWS, NO_DATA_FOUND, DUP_VAL_ON_INDEX -
RAISE statement for predefined exceptions -
User defined exceptions -
SP control functions SQLCODE, SQLERRM -
Triggers: Understand :NEW.c1 and :OLD.c1 instead of NEW.c1 and OLD.c1 -
Dynamic SQL placeholders -
Allow VARCHAR and VARCHAR2 without length as a data type of routine parameters and in RETURN clause -
CAST(..AS VARCHAR(N)) -
Anonymous blocks -
GOTO statement -
Allow SELECT UNIQUE as a synonym for SELECT DISTINCT -
Do not require BEGIN..END in multi-statement exception handlers in THEN clause -
Understand optional routine name after the END keyword -
Inside routines the CALL keywoard is optional -
Make the concatenation operator ignore NULL arguments -
make the CONCAT function ignore NULL arguments -
TRUNCATE TABLE t1 [ {DROP|REUSE} STORAGE ] -
Providing compatibility for basic SQL data types -
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 MDEV-4912 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 - MDEV-12303, MDEV-12239, MDEV-12199, MDEV-12001
as an argument to hybrid functions such as CASE, COALESCE, IF which have other arguments of the numeric or temporal data types - MDEV-11478
as an argument to comparison operators in combination with numeric and temporal data types -
as an argument to operators +, -, *, /, MOD -
Wrong result for INSERT INTO t1 (datetime_field) VALUES (hybrid_function_of_TIME_data_type) -
Expect "Impossible where condition" for WHERE timestamp_field>=DATE_ADD(TIMESTAMP'9999-01-01 00:00:00',INTERVAL 1000 YEAR) -
SP variables of temporal data types do not replicate correctly -
Incorrect result for (time_expr BETWEEN timestamp_exp1 AND timestamp_expr2) -
Wrong result for CASE on a mixture of signed and unsigned expressions -
Wrong result for (int_expr IN (mixture of signed and unsigned expressions)) -
CASE with a mixture of TIME and DATETIME returns a wrong result -
SP variables of the SET data type erroneously allow values with comma -
mysql_list_field() returns wrong default values for VIEW -
The following new system variables have been added:
The following new status variables have been added:
See the What is MariaDB 10.3? page for an overview of MariaDB 10.3.
Do not use alpha releases in production!
For a complete list of changes made in MariaDB 10.3.0, with links to detailed information on each push, see the changelog.
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.
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
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