MariaDB 10.1.0 Changelog

The most recent release of MariaDB 10.1 is:MariaDB 10.1.48 Stable (GA) Download Now

DownloadRelease NotesChangelogOverview of 10.1

Release date: 30 Jun 2014

For the highlights of this release, see the release notes.

The revision number links will take you to the revision's page on GitHub. On GitHub you can view more details of the revision and view diffs of the code modified in that revision.

• Revision #c235de1 2014-06-26 22:06:41 +0400

  • : ANALYZE DELETE .. RETURNING fails with ERROR 2027 Malformed packet (now, the code)

• 2014-06-26 22:04:04 +0400

  • Merge branch '10.1' of github.com:MariaDB/server into 10.1

• 2014-06-26 22:03:13 +0400

  • : ANALYZE DELETE .. RETURNING fails with ERROR 2027 Malformed packet

• 2014-06-26 20:47:08 +0300

  • Merge branch '10.1' of github.com:MariaDB/server into 10.1

• 2014-06-26 20:45:27 +0300

  • : Change innodb_have_lzo and innodb_have_lz4 as a static variables and reduce the number of ifdef's

• 2014-06-26 20:12:18 +0400

  • Code cleanup, more tests.

• 2014-06-26 19:09:23 +0400

  • : ANALYZE UPDATE does not populate r_rows

• 2014-06-26 18:32:18 +0400

  • : Make ANALYZE UPDATE/DELETE handle the degenerate query plans.

• 2014-06-26 15:55:25 +0400

  • : ANALYZE SELECT crashes ... Don't try printing EXPLAIN if we had an error.

• 2014-06-26 12:46:33 +0200

  • enhance security using special compilation options

• 2014-06-16 21:39:09 +0200

  • enhance security using special compilation options

• 2014-06-16 21:30:48 +0200

  • cmake cleanup: use MY_CHECK_AND_SET_COMPILER_FLAG.

• 2014-06-16 21:24:30 +0200

  • cmake: prefer INSTALL(PROGRAMS over INSTALL(FILES

• 2014-06-16 22:16:21 +0200

  • remove unused sql/examples

• 2014-06-26 11:37:24 +0500

  • Revert " OpenGIS: create required tables: GeometryColumns, related views."

• 2014-06-26 10:48:08 +0400

  • Merge branch 'bb-10.1-explain-analyze' into 10.1

• 2014-06-26 10:43:58 +0400

  • Code cleanup

• 2014-06-26 01:22:50 +0400

  • : ANALYZE $stmt: Make multi-table UPDATE/DELETE work, code cleanup.

• 2014-06-26 00:46:21 +0500

  • OpenGIS: create required tables: GeometryColumns, related views. Scripts added that create OpenGIS-required views and tables they're based upon.

• 2014-06-25 21:00:24 +0300

  • Merge branch '10.1' of github.com:MariaDB/server into 10.1

• 2014-06-25 20:47:54 +0400

  • : ANALYZE $stmt: fix "explain UPDATE view problem".

• 2014-06-25 19:04:44 +0300

  • Fix test failure when trying to set compression algorithm to 3

• 2014-06-25 18:35:30 +0400

  • : ANALYZE $stmt: more testcases, fix memory leak

• 2014-06-25 16:46:42 +0400

  • Merge bb-10.1-explain-analyze into 10.1

• 2014-06-25 16:01:09 +0400

  • : ANALYZE $stmt: add some tests for joins

• 2014-06-25 15:15:38 +0400

  • : ANALYZE $stmt: add support for BNL join buffering

• 2014-06-25 08:46:54 +0300

  • : innodb_compression_algorithm configuration variable can be set to unsupported value.

• 2014-06-24 23:58:13 +0400

  • : ANALYZE $stmt: Scans that never executed will have r_rows=NULL

• 2014-06-24 23:38:49 +0400

  • Fix compile on Windows: use rint() instead of round().

• 2014-06-24 22:21:34 +0400

  • : ANALYZE $stmt: fix order_by.test

• 2014-06-24 19:41:43 +0400

  • : ANALYZE $stmt: get ANALYZE work for subqueries

• 2014-06-23 12:09:00 +0200

  • GUI-friendly cmake options to enable/disable plugins

• 2014-06-17 10:59:40 +0200

  • cmake GUI cleanup

• 2014-06-23 16:23:51 +0200

  • [PATCH] Clean up code working with ACL tables

• 2014-06-21 08:56:49 +0200

  • main.temp_table_frm failure on fulltest (--embedded, when TMPDIR=/tmp)

• 2014-06-20 11:34:24 +0200

  • Don't create frm files for temporary tables

• 2014-06-18 11:53:42 +0200

  • remove HTON_FLUSH_AFTER_RENAME (BDB-ism, unused for years)

• 2014-06-17 17:57:18 +0200

  • Fix CMakeLists.txt for cmake Ninja generator

• 2014-06-19 12:02:23 +0200

  • better help for SET/ENUM sysvars

• 2014-06-18 15:00:58 +0200

  • update sys_vars.innodb_compression_algorithm_basic to pass

• 2014-06-17 11:33:50 +0300

  • Merge branch '10.1' of github.com:MariaDB/server into 10.1

• 2014-06-17 08:40:54 +0300

  • Fixed test failure introduced by adding a new dynamic configuration variable innodb_compression_algorithm. Removed unnecessary test for removed configuration variable.

• 2014-06-16 13:34:03 +0400

  • Update analyze_stmt.result after the last commit

• 2014-06-14 22:15:52 +0200

  • merge default_tmp_storage_engine

• 2014-06-15 12:19:33 +0200

  • .gitignore ninja files

• 2014-06-14 18:24:22 +0200

  • fix bison warnings (clash != <>)

• 2014-06-13 16:10:25 +0200

  • Merge branch '10.0' into 10.1

• 2014-06-04 14:43:05 +0400

  • Amend "make distclean" message to mention "git clean -Xdf"

• 2014-06-03 19:04:59 +0400

  • : ANALYZE $stmt - Testcase for ANALYZE UNION - Provide r_rows for union result.

• 2014-06-03 17:59:01 +0400

  • : ANALYZE $stmt - Support tracking for UNIONs, temporary-table based ORDER BYs, and both.

• 2014-05-27 20:16:51 +0400

  • : ANALYZE $stmt -Add analyze_stmt.test/result

• 2014-05-27 20:13:17 +0400

  • Re-commit in git: : ANALYZE $stmt - Ported the old patch to new explain code - New SQL syntax (ANALYZE $stmt) - ANALYZE UPDATE/DELETE is now supported (because EXPLAIN UPDATE/DELETE is supported) - Basic counters are calculated for basic kinds of queries (still need to see what happens with join buffer, ORDER BY...LIMIT queries, etc)

• 2014-05-27 14:29:05 +0200

  • don't include <linux/falloc.h> when it's not really needed

• 2014-05-26 21:14:33 +0200

  • Merge remote-tracking branch 'origin/10.1' into 10.1-serg-merge

• 2014-05-26 21:11:53 +0200

  • merge the compilation fixes from 10.0-FusionIO

• 2014-05-26 20:42:06 +0200

  • compilation failure on Win64

• 2014-05-26 20:41:10 +0200

  • use ENUM not ULONG for innodb-compression-algorithm command-line option

• 2014-05-26 20:31:03 +0200

  • compilation failure on Windows

• 2014-05-26 20:27:14 +0200

  • don't include the file that 1) not present everywhere 2) not used anyway

• 2014-05-26 20:26:51 +0200

  • temporarily disable lzo compression

• 2014-05-26 20:26:04 +0200

  • lzo.cmake: don't use the same symbol for two different tests

• 2014-05-25 17:20:15 +0200

  • more files in .gitignore

• 2014-05-25 17:17:50 +0200

  • set version to 10.1.0

• 2014-05-25 10:18:07 +0200

  • Merge branch '10.1' of bzr::/usr/home/serg/Abk/mysql into 10.1

• 2014-05-24 21:37:21 +0300

  • Merge 10.0 -> 10.1

• 2014-05-23 16:40:10 +0200

  • split README into the actual README and third-party licenses

• 2014-05-22 11:08:14 +0200

  • fix file_contents to pass with git

• 2014-05-21 15:30:06 +0200

  • git support in cmake files

• 2014-05-21 14:50:01 +0200

  • remove support for per-plugin bzr repositories

• 2014-05-24 12:14:06 +0200

  • remove now-obsolete "5.5+5.6 merge" TODO file

• 2014-05-24 12:13:03 +0200

  • add .gitignore

• 2014-05-23 08:20:43 +0300

  • Fix compiler warnings.

• 2014-05-23 08:10:54 +0300

  • Fix compiler warnings.

• 2014-05-22 21:05:35 +0300

  • Fixed compiler error if LZO is not installed.

• 2014-05-22 21:03:26 +0300

  • Fix compiler error if LZO is not installed.

• 2014-05-22 19:48:34 +0300

  • Fixed compiler errors caused by merge error.

• 2014-05-22 19:01:41 +0300

  • Fix compiler errors caused by merge error.

• 2014-05-22 16:31:31 +0300

  • Fix some compiler warnings and small errors on code.

• 2014-05-22 14:24:00 +0300

  • : Merge 10.0.10-FusionIO to 10.1.

• 2014-05-16 15:30:13 +0300

  • Code cleanup after review.

• 2014-05-13 13:28:57 +0300

  • : Allow > 16K pages on InnoDB

• 2014-05-08 13:09:15 +0400

  • Merge 10.0 -> 10.1

• 2014-04-28 07:52:41 +0300

  • Fixed small error on compression failure error text.

• 2014-04-23 23:14:29 -0700

  • Merge 10.0->10.1

• 2014-04-23 19:23:11 +0300

  • Fixed bug on free buffer space calculation when LZO is used. Fixed bug on function call when InnoDB plugin is used.

• 2014-04-17 08:22:54 +0300

  • Merge lp:maria/10.0 up to mariadb-10.0.10 revision 4140.

• 2014-04-16 16:55:36 +0300

  • : FusionIO: Failure to create a table with ATOMIC_WRITES option leaves the database in inconsistent state,

• 2014-04-15 14:28:25 +0300

  • Added support for LZO compression method.

• 2014-03-29 16:51:28 +0200

  • Disable failing test cases that fail because of upstream.

• 2014-03-28 08:42:53 +0200

  • Fix error on innodb_mtflush_threads parameter.

• 2014-03-27 12:21:16 +0200

  • Fixed windows compiler errors.

• 2014-03-27 10:00:30 +0200

  • Fix bug (Inadequate background LRU flushing for write workloads with InnoDB compression).

• 2014-03-27 09:35:24 +0200

  • Fix bug (Inadequate background LRU flushing for write workloads with InnoDB compression).

• 2014-03-25 21:31:27 +0200

  • Fix candidate for XtraDB and row compressed tables.

• 2014-03-22 11:30:03 +0200

  • Fix test cases to contain new status variables introduced.

• 2014-03-21 15:46:36 +0200

  • Code cleanup: Removed some unnecessary outputs from standard builds (available on special builds UNIV_PAGECOMPRESS_DEBUG and UNIV_MTFLUSH_DEBUG).

• 2014-03-12 14:47:38 +0200

  • Removed options innodb_compress_index_pages and innodb_trim_pct. Both are unnecessary. There is a lot more index pages than there is normal pages. Earlier all pages were compressed and this provided best performance and compression ratio. Added status variable to show how many non index pages are written.

• 2014-03-11 13:49:52 +0200

  • Added multi-key unique test case.

• 2014-03-11 13:40:29 +0200

  • : Force PK option. Added a new dynamic configuration variable innodb_force_primary_key default off. If option is true, create table without primary key or unique key where all keyparts are NOT NULL is not accepted. Instead an error message is printed. Variable value can be changed with set global innodb_force_primary_key = .

• 2014-03-11 07:57:54 +0200

  • Merge lp:maria/10.0 up to revision 4040 = RC

• 2014-03-07 08:20:43 +0200

  • Changed so that innodb_compress_index pages means that if true also index pages are compressed if false index pages are not compressed.

• 2014-03-07 07:42:28 +0200

  • Merge lp:maria/10.0 up to revision 4032 (10.0.9).

• 2014-03-04 20:12:32 +0200

  • Set index page compression on by default and remove innodb_trim_pct as it is not used/implemented.

• 2014-03-04 18:56:18 +0200

  • Additional merge to lp:maria/10.0

• 2014-03-04 17:14:08 +0200

  • Set actual compressed page size also on read code path to buffer pool so that we can later use it to avoid unnecessary trim operations.

• 2014-03-03 18:14:29 +0200

  • Fixed a hang. The core issues is with the heap-thrashing by the individual queue's. Tried to minimize memory allocation from heap whenever it is unnecessary.

• 2014-03-03 15:51:54 +0200

  • Yet more windows fixes.

• 2014-03-03 15:43:38 +0200

  • Fix windows os_file_write.

• 2014-03-03 15:26:58 +0200

  • Additional windows fixes.

• 2014-03-03 15:15:00 +0200

  • Fix typo.

• 2014-03-03 15:02:39 +0200

  • Fix windows compiler erros.

• 2014-03-03 14:45:45 +0200

  • Fix compiler error on windows.

• 2014-03-03 14:27:56 +0200

  • Merge: lp:maria/10.0 latest.

• 2014-03-03 12:34:33 +0200

  • Turn all new features off by default.

• 2014-02-28 09:05:36 +0200

  • Fix compiler error.

• 2014-02-28 08:53:09 +0200

  • Temporal fix for flush thread hang.

• 2014-02-26 19:00:24 +0200

  • Small fixes to work_item handling.

• 2014-02-25 13:15:55 +0200

  • Fixed memory leak on queue nodes by using local memory heap on normal execution and global memory heap on shutdown.

• 2014-02-21 12:51:03 +0200

  • Remove incorrect trim_len calculation. We have already alligned actual page data write.

• 2014-02-21 10:20:18 +0200

  • Write size was not correctly alligned to SECT_SIZE. This lead to situation where trim corrupted the database. Fixed the issue and added temporal guards against unalligned write/trim.

• 2014-02-20 09:28:18 +0200

  • Make tokudb working with 10.1

• 2014-02-19 20:25:55 +0200

  • Removed unnecessary memory initialization of page compressed buffer and added guard against unalligned trim size.

• 2014-02-15 09:51:06 +0200

  • Fixed hang seen on TPC-C measure phase. We should not use timedwait on threads waiting for a job. They should sleep and let other threads to their work. At shutdown, we know that we put "work" and that is handled as soon as possible.

• 2014-02-14 15:02:26 +0200

  • Fix timing on queues, this could clearly lead to starvation.

• 2014-02-13 12:35:37 +0200

  • Fixed compiler warnings.

• 2014-02-13 12:23:55 +0200

  • Fixed small issue with dictionary.

• 2014-02-13 09:13:56 +0200

  • Fixed issue on data dictionary corruption. Fixed issue on multi-threaded flush at shutdown. Removed unnecessary startup option innodb_compress_pages. Added a new startup option innodb_mtflush_threads, default 8.

• 2014-02-12 18:00:03 +0200

  • Fixed issue on atomic writes and system tables. Atomic writes can be used also on system tables but not per table.

• 2014-02-12 12:52:34 +0200

  • Fixed issue on atomic writes setup and atomic blobs setup on system tables.

• 2014-02-12 10:55:45 +0200

  • Code cleanup. Removed those questions that are now addressed.

• 2014-02-12 07:09:06 +0200

  • Fix compiler error if lz4 is not found on the system.

• 2014-02-11 20:05:09 +0200

  • Removed unnecessary files and set lz4 under HAVE_LZ4 compiler option using cmake find_library. Fixed bunch of compiler warnings.

• 2014-02-07 15:31:31 +0200

  • Merged latest mt-flush code to xtradb. Cleaned up thread statistic output code.

• 2014-02-06 17:49:55 +0200

  • Fixed issue on file space extension. File space should be extended from current offset to desired size if posix_fallocate is used.

• 2014-02-06 17:25:26 +0200

  • Moved mt-flush code to buf0mtflu.[cc|h] and cleaned it up. This is for InnoDB.

• 2014-02-06 00:14:15 +0400

  • Change version number to 10.1

• 2014-02-05 15:32:29 +0200

  • Fixed issue on xtradb shutdown merge error. Multi-threaded flush threads where not shut down properly.

• 2014-02-04 20:08:59 +0200

  • Fixed compiler errors.

• 2014-02-04 14:52:02 +0200

  • Fixed issue on atomic writes on startup, removed incorrect assert.

• 2014-02-03 10:08:15 +0200

  • Fixed merge error on InnoDB page compression level handling.

• 2014-01-27 13:00:36 +0200

  • Merge lp:maria/10.0 10.0.7 revision 3961

• 2014-01-13 15:02:31 +0200

  • Removed some unnecessary assertions to debug build and enhanced the page_compression and page_compression_level fetch.

• 2014-01-10 12:11:36 +0200

  • Enhancement: Change atomic_writes table option to enum type. Now every file can either use atomic writes, not use it or use default.

• 2014-01-09 12:33:29 +0200

  • Feature: In first write if we trim we set write_size to actual bytes written and rest of the page is trimmed. In following writes there is no need to trim again if write_size only increases because rest of the page is already trimmed. If actual write size decreases we need to trim again. Need to research if this can happen frequently enough to make any effect.

• 2014-01-09 08:30:09 +0200

  • Fixed issues with atomic writes and compressed pages.

• 2013-12-20 08:59:34 +0200

  • Temporally disable posix_fallocate on os_file_set_size because currently Fusion-io SSD drive does not support setting file size without fysically writing pages with zeroes when fallocate with PUCH_HOLE is used.

• 2013-12-20 06:50:58 +0200

  • Need to disable fast file extension with posix_fallocate for Fusion-io currently.

• 2013-12-19 18:04:26 +0200

  • Atomic writes require also atomic_blobs. Add that missing flag to dictionary setting and from there it will be stored to table space.

• 2013-12-19 14:36:38 +0200

  • Changes for Fusion-io multi-threaded flush, page compressed tables and tables using atomic write/table.

• 2013-12-06 19:02:55 +0400

  • TIME(0), TIMESTAMP(0) and DATETIME(0) are self-incompatible during replication (upstream) Fixed.

• 2013-12-05 16:54:50 +0400

  • Fixing an MSVC warning about double "const" data type qualifier in the code merged from MySQL-5.6: