MariaDB Server 10.5 Alpha Now Available

Posted on December 3, 2019 by

The first alpha release of MariaDB Server 10.5 is now available!

Ever since the GA release of MariaDB Server 10.4 this summer, we have been working hard to release the first alpha version of MariaDB Server 10.5. With this new version, we are delivering a number of new features, including:

  • Improvements to partitioning for System Versioned Tables
  • New plugin type for a user defined function
  • New plugin type for a user defined type
    • INET6 data type plugin 
  • Enhancements to SQL Syntax
    • INSERT with support of RETURNING
    • EXCEPT ALL and INTERSECT ALL
    • REFERENCES clause in the column definitions in CREATE TABLE
  • For InnoDB
    • New InnoDB internal thread handling
    • More detailed SHOW ENGINE INNODB STATUS
    • Optimized doublewrite buffer usage
  • Enhancements to the Information Schema
    • Show config file a configuration parameter comes from
    • New tables for the thread pool
  • Session user variable tracker
  • Aria supports longer keys (up to 2000 bytes, was 1000 bytes)
  • Optimizer enhancements for searches on columns with NULL values
  • Inconsistency voting for MariaDB Cluster
  • Per-database comments
  • Optimizations for ARMv8
  • JSON_ARRAYAGG and JSON_OBJECTAGG functions
  • and lots of internal refactoring

 

MariaDB Server 10.5 will also include changes for defaults and system variables.

  • New defaults:
    • Innodb_checksum_algorithm is full_crc32 by default
    • Innodb_adaptive_hash_index is OFF by default
    • Innodb_log_files_in_group is 1 by default
  • System variables added: thread_pool_exact_stats and thread_pool_dedicated_listener
  • System variables deprecated: big_tables, innodb_log_checksums, and innodb_undo_logs
  • System variables removed: max_long_data_size, innodb_locks_unsafe_for_binlog, innodb_rollback_segments, and innodb_stats_sample_pages

 

And we have more enhancements in store that we’ll be releasing with future versions of MariaDB Server 10.5. Stay tuned! 

This is an alpha release and it should not be used in production. We encourage you to download MariaDB Community Server 10.5, test it and share your feedback with us.