Release Notes for MariaDB Enterprise ColumnStore 22.08.1

Overview

MariaDB Enterprise ColumnStore 22.08.1 is a maintenance release of MariaDB Enterprise ColumnStore. MariaDB Enterprise ColumnStore is a columnar storage engine included with MariaDB Enterprise Server. This is the first release in the Enterprise ColumnStore 22.08 series.

MariaDB Enterprise ColumnStore 22.08.1 was released on 2022-09-12. This release is of General Availability (GA) maturity.

MariaDB Enterprise ColumnStore 22.08 replaces MariaDB Enterprise ColumnStore 6 in MariaDB Enterprise Server 10.6.

This release of MariaDB Enterprise ColumnStore is included with MariaDB Enterprise Server 10.6.9-5.

Notable Changes

JOINs

  • Support has been added for JOINs with an ON clause that reference tables that are not involved in the join. (MCOL-5167)

  • Support has been added for circular outer JOINs. (MCOL-4699)

  • Support has been added for complex JOINs in views. (MCOL-5061) (MCOL-4902)

  • Support has been added for combining outer JOINs and IS NULL filters. (MCOL-4715)

Query Performance

  • In single-node ColumnStore, query performance has been improved by removing a network hop. (MCOL-5166)

  • Performance has been enhanced for queries that filter on numbers. (MCOL-5140) (MCOL-4995)

  • Performance has been enhanced for DELETE queries. (MCOL-5021)

Functions

Tooling

Operating Systems

  • Operating system compatibility has changed, as designated in MariaDB Engineering Policy, including:

    • Support for Debian 11, Red Hat Enterprise Linux 9, Rocky Linux 9, and Ubuntu 22.04 have been added.

    • Support for Debian 9 and Ubuntu 18.04 have been removed.

CPU Compatibility

  • When ColumnStore is installed and started, ColumnStore's binaries check the system's CPU to confirm that the CPU supports the SIMD instructions required by ColumnStore. (MCOL-5180)

    • On x86_64, ColumnStore requires SSE4.2.

    • On ARM64, ColumnStore requires NEON.

    • If the ColumnStore installation scripts determine that the required SIMD instructions are not supported, the following error is raised:

      error: this machine CPU lacks of support for Intel SSE4.2 or ARM Advanced SIMD instructions. Columnstore requires one of this instruction sets, installation aborted
      
    • If the ColumnStore binaries are started and determine that the required SIMD instructions are not supported, the following error is raised:

      Unsupported CPU architecture. ARM Advanced SIMD or x86_64 SSE4.2 required; aborting.
      

Internal Processes

  • Internal stability improvements have been made to the processes that write data. (MCOL-5163)

    • The WriteEngineServer, DMLProc, and DDLProc processes have been improved.

  • PrimProc thread pool has been changed to use a fair scheduler. (MCOL-5044)

  • The ExeMgr process has been merged with the PrimProc process. (MCOL-5001) (MCOL-5109)

Platforms

In alignment to the enterprise lifecycle, MariaDB Enterprise ColumnStore 22.08.1 is provided for:

  • CentOS 7 (x86_64)

  • Debian 10 (x86_64 / ARM64)

  • Debian 11 (x86_64 / ARM64)

  • Red Hat Enterprise Linux 7 (x86_64)

  • Red Hat Enterprise Linux 8 (x86_64 / ARM64)

  • Red Hat Enterprise Linux 9 (x86_64 / ARM64)

  • Rocky Linux 8 (x86_64 / ARM64)

  • Rocky Linux 9 (x86_64 / ARM64)

  • Ubuntu 20.04 (x86_64 / ARM64)

  • Ubuntu 22.04 (x86_64 / ARM64)