MariaDB 10.2.10

MariaDB is a database server that offers drop-in replacement functionality for MySQL. It is built by some of the original authors of MySQL, with assistance from the broader community. In addition to the core functionality of MySQL, it offers a rich set of feature enhancements including alternate storage engines, server optimizations, and patches.

Tags database database-server database-engine mysql mariadb
License GNU GPL
State stable

Recent Releases

10.2.1001 Nov 2017 19:25 minor feature: InnoDB updated to 5.7.20 MDEV-14051 : 'Undo log record is too big.' error occurring in very narrow range of string lengths. MDEV-13918 : Race condition between INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS and ALTER/DROP/TRUNCATE TABLE. MDEV-13838 : Wrong result after altering a partitioned table. in InnoDB FULLTEXT INDEX. MDEV-12676 : InnoDB FTS duplicate key error. MDEV-13051 : InnoDB crash after failed ADD INDEX and table_definition_cache eviction. MDEV-13446 : fts_create_doc_id() unnecessarily allocates 8 bytes for every inserted row. MDEV-12676 : InnoDB FTS duplicate key error. MDEV-13051 : InnoDB crash after failed ADD INDEX and table_definition_cache eviction. MDEV-13446 : fts_create_doc_id() unnecessarily allocates 8 bytes for every inserted row. for the following security vulnerabilities : CVE-2017-10378, MDEV-13819. CVE-2017-10268. CVE-2017-10378, MDEV-13819. CVE-2017-10268. Release Notes - MariaDB 10.2 Series ?. MariaDB 10.2.9 Release Notes ?.
10.2.929 Sep 2017 04:25 minor feature: TokuDB updated to 5.6.37-82.2 Temporary files created by merge sort and row log are encrypted if innodb_encrypt_log is set to. 1, regardless of whether the table encrypted or not ( MDEV-12634 ). innodb_mtflush_threads. innodb_use_mtflush. for the following security vulnerabilities : CVE-.. -. CVE-.. -. Release Notes - MariaDB 10.2 Series ?. MariaDB 10.2.8 Release Notes ?.
10.2.819 Aug 2017 06:25 minor feature: InnoDB updated to 5.7.19 CONNECT engine updated to 1.06.0001. Beta support for MongoDB added. ST_GeomFromGeoJSON ( MDEV-12181 ). ST_AsGeoJSON ( MDEV-12180 ). MariaDB Backup now included for Debian and Ubuntu (in MariaDB 10.2.7 it was released only for Red Hat, CentOS, and Fedora). Fedora 26 repositories have been added in this release. As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.2 for Fedora 24. Beta support for MongoDB added. for the following security vulnerabilities : CVE-2017-3636. CVE-2017-3641. CVE-2017-3653. CVE-2017-3636. CVE-2017-3641. CVE-2017-3653. Release Notes - MariaDB 10.2 Series ?. MariaDB 10.2.7 Release Notes ?.
10.2.713 Jul 2017 22:45 minor feature: TokuDB updated to 5.6.36-82.0 MariaDB Backup beta now included for Red Hat, CentOS, and Fedora packages. MDEV-13125 : Core dumps can now be enabled dynamically. New variables: tmp_disk_table_size. tmp_memory_table_size. As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.2 for Ubuntu 16.10 "Yakkety". tmp_disk_table_size. tmp_memory_table_size. for the following security vulnerabilities : CVE-.. -. CVE-.. -. Release Notes - MariaDB 10.2 Series ?. MariaDB 10.2.6 Release Notes ?.
10.2.624 May 2017 15:45 minor feature: MyRocks alpha storage engine added ( MDEV-9658 ) Window functions have been introduced. Recursive Common Table Expressions ( MDEV-9864 ). AWS Key Management plugin added for Windows, CentOS, RHEL, and Fedora packages. Update InnoDB to 5.7.18 ( MDEV-11751 ). Galera wsrep library updated to 25.3.20. Packages for Ubuntu 17.04 "zesty" added. MDEV-10431 : The. --add-drop-trigger option has been added to mysqldump. MDEV-12472 : Ignore XtraDB-specific parameters in InnoDB, warning that they are ignored. MDEV-12253, MDEV-12602 : Numerous Encryption. MDEV-11336 : Disabled defragmentation. MDEV-10332 : Added support for OpenSSL 1.1 and LibreSSL. innodb_deadlock_detect and innodb_stats_include_delete_marked variables introduced. for the following security vulnerabilities : CVE-.. -. CVE-.. -. Percona XtraBackup (as of 2.4) will not work with MariaDB 10.2 (and MariaDB 10.1 ) compression. However, MariaDB's fork, MariaDB Backup, will work with compression. It will be included in a future version of MariaDB 10.2. Release Notes - MariaDB 10.2 Series ?. MariaDB 10.2.5 Release Notes ?.
10.1.2305 May 2017 00:05 minor feature: MDEV-12602 : some race conditions in InnoDB encryption MariaDB Backup alpha introduced, see this blog post for more information. Galera wsrep library updated to 25.3.20. Packages for Ubuntu 17.04 "zesty" added. As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.1 for Ubuntu 12.04 LTS "Precise" and Mint 13 LTS "Maya". for the following security vulnerabilities : CVE-2017-3302. CVE-2017-3313. CVE-2017-3308. CVE-2017-3309. CVE-2017-3453. CVE-2017-3456. CVE-2017-3464. CVE-2017-3302. CVE-2017-3313. CVE-2017-3308. CVE-2017-3309. CVE-2017-3453. CVE-2017-3456. CVE-2017-3464. Release Notes - MariaDB 10.1 Series ?. MariaDB 10.1.22 Release Notes ?.
10.1.2216 Mar 2017 05:45 minor feature: XtraDB updated to 5.6.35-80.0 TokuDB updated to 5.6.35-80.0. PCRE updated to 8.40. MDEV-12160 : ed25519 authentication plugin. MDEV-11842 : a 10.1.21 regression with failed INSERT, BEFORE INSERT triggers, and columns with no default value. MDEV-12075 : a 10.1.21 regression in the InnoDB data file extension code. MDEV-11027 : better InnoDB crash recovery progress reporting. MDEV-11520 : improvements to how InnoDB data files are extended. Improvements to InnoDB startup/shutdown to make it more robust. MDEV-11233 : for FULLTEXT index crash. MDEV-9734 : systemd compatible bintar files now available. As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.1 for Fedora 23, CentOS 5, RHEL 5, and openSUSE 13. OpenSUSE 42 repositories have been added in this release. for the following security vulnerabilities : CVE-2017-3313. CVE-2017-3302. CVE-2017-3313. CVE-2017-3302. Release Notes - MariaDB 10.1 Series ?. MariaDB 10.1.21 Release Notes ?.
10.1.2120 Jan 2017 09:25 minor feature: Innodb updated to 5.6.35 A file format compatibility that was introduced in MariaDB 10.1.0 was. Using page_compression or non-default innodb_page_size created files that were incompatible with MariaDB 10.0 or MySQL 5.6. MariaDB 10.1.21 will convert affected files from earlier MariaDB 10.1 releases to compatible format. This prevents a downgrade to earlier MariaDB 10.1 versions. See the commit for details. Performance Schema updated to 5.6.35. A file format compatibility that was introduced in MariaDB 10.1.0 was. Using page_compression or non-default innodb_page_size created files that were incompatible with MariaDB 10.0 or MySQL 5.6. MariaDB 10.1.21 will convert affected files from earlier MariaDB 10.1 releases to compatible format. This prevents a downgrade to earlier MariaDB 10.1 versions. See the commit for details. for the following security vulnerabilities : CVE-2016-6664. CVE-2017-3238. CVE-2017-3243. CVE-2017-3244. CVE-2017-3257. CVE-2017-3258. CVE-2017-3265. CVE-2017-3291. CVE-2017-3312. CVE-2017-3317. CVE-2017-3318. CVE-2016-6664. CVE-2017-3238. CVE-2017-3243. CVE-2017-3244. CVE-2017-3257. CVE-2017-3258. CVE-2017-3265. CVE-2017-3291. CVE-2017-3312. CVE-2017-3317. CVE-2017-3318. Release Notes - MariaDB 10.1 Series ?. MariaDB 10.1.20 Release Notes ?.
10.1.2017 Dec 2016 01:25 minor feature: XtraDB updated to 5.6.34-79.1 TokuDB updated to 5.6.34-79.1. HeidiSQL updated to 9.4. The limit for the table_open_cache system variable has been increased to 1024K. Galera wsrep library updated to 25.3.19. packages for Debian 9 "stretch" amd64 and Debian 8 "jessie" ppc64el added. for the following security vulnerabilities : CVE-.. -. CVE-.. -. Release Notes - MariaDB 10.1 Series ?. MariaDB 10.1.19 Release Notes ?.
10.1.1909 Nov 2016 04:45 minor feature: XtraDB updated to 5.6.33-79.0 TokuDB updated to 5.6.33-79.0. Packages for Ubuntu 16.10 Yakkety added. Use the Repository Configuration Tool to add the MariaDB Ubuntu repository to your system. for the following security vulnerabilities : CVE-2016-7440. CVE-2016-5584. CVE-2016-7440. CVE-2016-5584. Release Notes - MariaDB 10.1 Series ?. MariaDB 10.1.18 Release Notes ?.
10.1.1802 Oct 2016 12:45 minor feature: XtraDB updated to 5.6.32-78.1 TokuDB updated to 5.6.32-78.1. Innodb updated to 5.6.33. Performance Schema updated to 5.6.33. Optimizer sometimes use "index" instead of "range" access for UPDATE ( MDEV-10649 ). for the following security vulnerabilities : CVE-XXXX-XXXX. CVE-XXXX-XXXX. Release Notes - MariaDB 10.1 Series ?. MariaDB 10.1.17 Release Notes ?.
10.1.1731 Aug 2016 11:25 minor feature: XtraDB updated to 5.6.31-77.0 TokuDB updated to 5.6.31-77.0. Innodb updated to 5.6.32. Performance Schema updated to 5.6.32. As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.1 for Fedora 22. Packages for Fedora 24 are now available. Galera wsrep library updated to 25.3.17. The support for wsrep_max_ws_rows system variable has now been added and thus its values will no longer be ignored by the server. In order to be backward compatible its default value has been changed to. 0, which essentially allows writesets of any size. The default value of wsrep_max_ws_size has been raised from 1GB to 2GB. Release Notes - MariaDB 10.1 Series ?. MariaDB 10.1.16 Release Notes ?.
10.1.1620 Jul 2016 06:25 minor feature: XtraDB updated to 5.6.30-76.3 Innodb updated to 5.6.31. Performance Schema updated to 5.6.31. PCRE library updated to 8.39. TokuDB updated to 5.6.30-76.3. HeidiSQL updated to 9.3. Various packages and bintar builds for POWER8 ppc64 and ppc64le architectures now available. As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.1 for Ubuntu 15.10 "wily". for the following security vulnerabilities : CVE-.. -. CVE-.. -. Release Notes - MariaDB 10.1 Series ?. MariaDB 10.1.15 Release Notes ?.
10.1.1503 Jul 2016 11:45 minor feature: XtraDB updated to 5.6.30-76.3 Innodb updated to 5.6.31. Performance Schema updated to 5.6.31. PCRE library updated to 8.39. TokuDB updated to 5.6.30-76.3. HeidiSQL updated to 9.3. Various packages and bintar builds for POWER8 ppc64 and ppc64le architectures now available. As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.1 for Ubuntu 15.10 "wily". for the following security vulnerabilities : CVE-.. -. CVE-.. -. Release Notes - MariaDB 10.1 Series ?. MariaDB 10.1.14 Release Notes ?.
10.1.1412 May 2016 14:05 minor feature: XtraDB updated to XtraDB-5.6.29-76.2 Innodb updated to InnoDB-5.6.30. Performance Schema updated to 5.6.30. for the following security vulnerabilities : CVE-.. -. CVE-.. -. The Key ID is: C74CD1D8. The full fingerprint of the new key is: 177F 4010 FE56 CA33 3630 0305 F165 6F24 C74C D1D8. The key can be added using the following command: Release Notes - MariaDB 10.1 Series ?. MariaDB 10.1.13 Release Notes ?.
10.1.1328 Mar 2016 00:05 minor feature: MDEV-9659 AWS Key management encryption plugin (currently distributed in source form only). MDEV-6058 new server variables; log_slow_admin_statements and log_slow_slave_statements. MDEV-9443 CREATE ROLE and DROP ROLE are now allowed in prepared statements. MDEV-9640 INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION has a new column;. key_id. The Galera library has. Been updated to version. 25.3.15. for the following security vulnerabilities : CVE-.. -. CVE-.. -. Release Notes - MariaDB 10.1 Series ?. MariaDB 10.1.12 Release Notes ?.
10.1.1226 Feb 2016 14:05 minor feature: XtraDB updated to XtraDB-5.6.28-76.1 InnoDB updated to InnoDB-5.6.29. Performance Schema updated to 5.6.29. for the following security vulnerabilities : CVE-.. -. CVE-.. -. Release Notes - MariaDB 10.1 Series ?. MariaDB 10.1.11 Release Notes ?.
10.1.1130 Jan 2016 12:25 minor feature: New authentication plugin for clients connecting on Windows using named pipes. New SSPI/GSSAPI/Kerberos authentication plugin. Galera library has been updated from 25.3.9 to 25.3.12. for the following security vulnerabilities : CVE-.. -. CVE-.. -. Release Notes - MariaDB 10.1 Series ?. MariaDB 10.1.10 Release Notes ?.
10.1.1004 Jan 2016 05:45 minor feature: MDEV-7384 : mysqlcheck now supports. --persistent option, when used Together with. --analyze option, it will force Engine-independent Statistics for. This table to be updated. MDEV-9288 : On POWER8 architecture MariaDB now uses hardware accelerated. Crc32. MDEV-9212 : incorrect implementation of the. --ssl-verify-server-cert. Option that allowed a malicious attacker (with a capability to perform a Man-in-the-middle attack) to replace the server SSL certificate, bypassing The client-side hostname verification. This vulnerability was discovered by Paul Kehrer and Alex Gaynor. Release Notes - MariaDB 10.1 Series ?. MariaDB 10.1.9 Release Notes ?.
10.1.925 Nov 2015 14:45 minor feature: CONNECT engine updated to version 1.04.0003 The SHOW SLAVE STATUS field. seconds_behind_master, is now, with parallel replication, only updated after transactions commit. Includes all from MariaDB 5.5.46, MariaDB 10.0.22, and MariaDB Galera Cluster 10.0.22 releases. Release Notes - MariaDB 10.1 Series ?. MariaDB 10.1.8 Release Notes ?.
10.1.819 Oct 2015 17:05 minor feature: systemd support has been added for those distributions that support it. For CSV tables, the IETF_QUOTES option. Enables IETF-compatible parsing of embedded quote and comma characters MDEV-8682 ). wsrep_node_address now. Supports IPv6 ( MDEV-8034 ). silent-startup mysqld option. If specified, mysqld does not. Print Notes to log during startup. Replication from MySQL 5.6 with GTID, binlog_rows_query_log_events and. Ignorable events now works. In this case MariaDB will remove the MySQL GTIDs And other unneeded events and instead adds its own GTIDs. for the following security vulnerabilities : CVE-.. -. CVE-.. -. Release Notes - MariaDB 10.1 Series ?. MariaDB 10.1.7 Release Notes ?.
10.1.711 Sep 2015 06:45 minor feature: MariaDB can now also encrypt binary logs (including relay Logs). To enable binary logs encryption make sure That an encryption plugin is loaded and add. encrypt-binlog to Your. my.cnf file. The sql_log_bin. Variable no longer affects the replication of events in a Galera Cluster. Default values of server variables were changed as follows: One can now explicitly request MariaDB to select a good value for certain. Command-line options by using the. --autoset pre. For example, in. my.cnf : for the following security vulnerabilities : CVE-.. -. CVE-.. -. Release Notes - MariaDB 10.1 Series ?. MariaDB 10.1.6 Release Notes ?.
10.0.2107 Aug 2015 09:05 minor feature: XtraDB updated to XtraDB-5.6.25-73.1 Innodb updated to InnoDB-5.6.26. Performance Schema updated to 5.6.26. Connect engine has now.. Gamma maturity (was: Beta). Release Notes - MariaDB 10.0 Series ?. MariaDB 10.0.20 Release Notes ?.
10.0.2020 Jun 2015 08:25 minor feature: XtraDB updated to XtraDB-5.6.24-72.2 Innodb updated to InnoDB-5.6.25. Performance Schema updated to 5.6.25. TokuDB updated to TokuDB-7.5.7. Client command line option. --ssl-verify-server-cert (and. MYSQL_OPT_SSL_VERIFY_SERVER_CERT option of the client API) when used together with. --ssl will ensure that the established connection is SSL-encrypted and the MariaDB server has a valid certificate. This fixes CVE-2015-3152. We're introducing Debian Jessie packages in this version of MariaDB. They are considered experimental at this point. We've fixed a bug that caused a segfault on FreeBSD 10.1 x86 (MDEV-7398). Release Notes - MariaDB 10.0 Series ?. MariaDB 10.0.19 Release Notes ?.
10.0.1913 May 2015 05:45 minor feature: Fixed the server crash caused by mysql_upgrade (MDEV-8115) Release Notes - MariaDB 10.0 Series ?. MariaDB 10.0.18 Release Notes ?.
10.0.1808 May 2015 22:25 minor feature: Performance Schema updated to 5.6.24 XtraDB updated to XtraDB-5.6.23-72.1. Innodb updated to InnoDB-5.6.24. Spider updated to 3.2.21. Mroonga updated to 5.02. Fixed unrecognised column quoted with backticks in a function in a HAVING clause (MDEV-7301). ALTER TABLE with conflicting CHARACTER SET and CONVERT TO CHARACTER SET arguments now reports error (MDEV-7386). Fixed Regression: Bit and hex string literals changed column names (MDEV-7629). Merged derived tables/VIEWs incorrectly increment created_tmp_tables (MDEV-7586). TODO - Stalled - Assertion in subselects in queries run twice in the same connection (MDEV-7445). Some symbols in table name can cause to Error Code: 1050 when created FK. Table name is on filename charset but foreign key identifiers are not. This lead incorrect foreign key identifier number to be used (MDEV-7627). ALTER ONLINE TABLE with no options no longer requires a table copy (MDEV-7390). Fixed a case where it was impossible to create copy of a table if the table contained a default value for timestamp field in sql_mode="NO_ZERO_DATE" (MDEV-7778). INSTALL PLUGIN can now be done in bootstrap mode where authentication is disabled (MDEV-7781). Corrected error handing in AES_ENCRYPT/AES_DECRYPT where incorrect data could result in a SSL client connection being terminated (MDEV-7697). Corrected Assertion `status_var.memory_used == 0' failed in THD::THD() on disconnect after executing EXPLAIN for multi-table UPDATE (MDEV-7038). Fixed crash when dropping user within rebuild_role_grants which occurs in some cases in SHOW GRANTS and DROP ROLE (MDEV-7774). SHOW GRANTS now shows the password for users that have the password field set, auth_string field empty, plugin=mysql_native_password (MDEV-7985). In Debug builds, an assertion could be triggered on really large blobs (MDEV-7754). Fixed segfault when a virtual column used on an Innodb table and an index was created on a field after the virtual column (MDEV-7367). Fixed server crash when inserting mor
10.0.1701 Mar 2015 17:50 minor feature: InnoDB updated to 5.6.23 XtraDB updated to 5.6.22-72.0 TokuDB updated to 7.5.5 mroonga updated to 5.0 Spider updated to 3.2.18 Connect updated to 1.03.0005 HeidiSQL updated to 9.1 (MDEV-7290) galera-sst-mode option removed from mysqldump (MDEV-7615) mysqlbinlog --binlog-row-event-max-size support added (MDEV-6703) Release Notes - MariaDB 10.0 Series ? MariaDB 10.0.16 Release Notes ?
10.0.1628 Jan 2015 03:45 security: The innodb_stats_traditional system variable enables a larger sample of pages for larger tables for the purposes of index statistics calculation. InnoDB upgraded to 5.6.22 XtraDB upgraded to 5.6.22-71.0 TokuDB upgraded to 7.5.4 Updates to the CONNECT handler (supporting the JSON table type) Fixes for the following security vulnerabilities: CVE-2015-0411 CVE-2015-0382 CVE-2015-0381 CVE-2015-0432 CVE-2014-6568 CVE-2015-0374
10.0.1526 Nov 2014 03:18 minor feature: This release fixes a serious bug in InnoDB and XtraDB that sometimes could cause a hard lock up of the server (MDEV-7026). This is the first release that includes Mroonga full-text search storage engine. When compiled with OpenSSL, MariaDB now supports TLSv1.2 protocol. Limit it to TLSv1.2 ciphers only with --ssl_cipher=TLSv1.2. Limit it to SSLv3 ciphers with --ssl-cipher=SSLv3. RPM and DEB packages from MariaDB.org are built with OpenSSL, others (for Windows and generic Linux) are built with yaSSL. Fixes for the following security vulnerabilities: CVE-2014-6507 CVE-2014-6491 CVE-2014-6500 CVE-2014-6469 CVE-2014-6555 CVE-2014-6559 CVE-2014-6494 CVE-2014-6496 CVE-2014-6464 CVE-2014-6507 CVE-2014-6491 CVE-2014-6500 CVE-2014-6469 CVE-2014-6555 CVE-2014-6559 CVE-2014-6494 CVE-2014-6496 CVE-2014-6464 Bundled PCRE is upgraded to 8.36 InnoDB upgraded to 5.6.21 XtraDB upgraded to 5.6.21-70.0 TokuDB upgraded to 7.5.3 SphinxSE upgraded to 2.2.6 Updates to the CONNECT handler including: A new VIR virtual table type. New variables connect_use_tempfile and connect_exact_info A new VIR virtual table type. New variables connect_use_tempfile and connect_exact_info We now offer openSUSE repos, see the repository configuration tool for details on how to use it.
10.0.1427 Sep 2014 04:55 minor bugfix: TokuDB upgraded to 7.5.0 XtraDB upgraded to 5.6.20-68.0 InnoDB upgraded to 5.6.20 Spider upgraded to 3.2.11 SphinxSE upgraded to 2.1.9 The Feedback plugin now includes statistics on collation usage. Error log has a flood protection that is activated after 10 identical unsafe warnings and disables them for the next 5 minutes. Many fixes and optimizations for the Power8 platform. As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.0 for both Ubuntu 13.10 "Saucy" and Mint 16 "Petra". With the recent release of CentOS 7 and RHEL 7, we are pleased to now provide packages for both distributions. Instructions for how to enable the repositories can be found by visiting the "Installing MariaDB with YUM" page and the repository configuration tool.
10.0.1312 Aug 2014 19:25 minor bugfix: Filesort-with-small-limit-optimization is now visible through the slow query log and a new status variable, sort_priority_queue_sorts. New variables aria_pagecache_file_hash_size and key_cache_file_hash_size for determining the number of hash buckets for open and changed files for Aria and MyISAM respectively. Connect engine supports partitioning. Many plugins have had their maturity level increased (from beta to gamma or from gamma to stable). TokuDB was upgraded to 7.1.7, XtraDB to 5.6.19-67.0, InnoDB to 5.6.19, and Performance_Schema upgraded to 5.6.20.