메뉴 건너뛰기

Korea Oracle User Group

새소식

MariaDB Community Server 11.0 GA and 11.1 RC 릴리즈 소식

 

URL : https://mariadb.com/resources/blog/announcing-mariadb-community-server-11-0-ga-and-11-1-rc/

 

마리아 DB 커뮤니티 서버가 11 버전 GA가 릴리즈되었네요

더불어 11.1 RC도 같이 릴리즈 됐네요

 

아래 몇가지 변화에 대해서 강조하고 있네요.

  • MARIADB QUERY OPTIMIZER ADOPTS A COST-BASED MODEL
  • INNODB ADVANCES
  • CHANGES TO THE SUPER PRIVILEGE
  • NEW FEATURES FOR MARIADB GALERA CLUSTER
  • COMPATIBILITY FOR BINARY NAMES

 

더 자세한 내용은 위 URL 참고하거나 아래 원문 참고하시기 바랍니다.

 


 

Announcing MariaDB Community Server 11.0 GA and 11.1 RC

We are pleased to announce the general availability (GA) of MariaDB Community Server  and the first release candidate (RC) of MariaDB Community Server 11.1.

MariaDB Community Server 11.0 now GA

The major highlights for MariaDB Community Server 11.0 are an upgrade to the query optimizer, advances to the InnoDB storage engine and of course, the switch to the 11.x release series. Read more here about why we are making the change from 10.x to 11.x.

MARIADB QUERY OPTIMIZER ADOPTS A COST-BASED MODEL

GA introduces a new optimizer cost model, a change from a more rule-based to a cost-based model. Huge effort went into improving the calculations of the optimizer costs, taking into account state of the art SSD disks. The new implementation also takes the different characteristics of a storage engine into account.

If a key lookup cannot be used, the optimizer can now make better choices when to use index scan, table scan, index merges or other methods to join data.

While one model may work well for a specific use case, it may not be the right model for other use cases. With the changes we’ve made, it’s now possible to fine-tune the optimizer by changing costs for different metrics.

INNODB ADVANCES

The InnoDB storage engine, which is the default transactional storage engine in MariaDB Server used for the majority of use cases, has gone through additional code cleanup and we have removed some configuration parameters used by the InnoDB Change Buffering feature, a feature which was disabled for earlier release series. New system variables like innodb_log_file_bufferinginnodb_data_file_bufferinginnodb_log_file_write_through and innodb_data_file_write_through have been added to allow better control for log files and data files. They can be set dynamically while the Server is running.

CHANGES TO THE SUPER PRIVILEGE

Changes have been made regarding the use of the SUPER privilege, which has also been used as an alias for some combinations of other privileges.

NEW FEATURES FOR MARIADB GALERA CLUSTER

MariaDB Galera Cluster now allows splitting the semicolon separated list of options in the system variable wsrep_provider_options to separate system variables, by using a new plugin plugin-wsrep-provider. This allows easier maintenance and is especially useful when the maximum string length of the system variable is reached, most of the time because of long hostnames for Galera Cluster nodes.

The MariaDB Galera Cluster status JSON file now includes details about a node eviction status to the JSON file, to report that a Galera node needs to be restarted to join the cluster.

COMPATIBILITY FOR BINARY NAMES

With this release series, MariaDB Server is deprecating the mysql-prefixed names. Warnings will be shown when a MariaDB tool is used. Symlinks are still provided, but are included in a separate compatibility package.

We encourage all users to change their scripts and tools now, if not already completed.

More details about the changes in MariaDB Community Server 11.0 can be found in its RC blog post MariaDB Community Server 11.0 RC.

 

MariaDB Community Server 11.1 now RC

Our next release series, 11.1 focuses on JSON functionality and further optimizer changes.

NEW JSON FUNCTION

For the 11.1 community server release series, developers can now use the new JSON function JSON_SCHEMA_VALID to validate a JSON document against a JSON schema, as documented by the JSON Schema Draft 2020. This function can also be used in a CHECK constraint to verify that only JSON documents are stored in the database which include required items and that the values are within a given range, length, etcetera.

OPTIMIZER CHANGES

Changes to the optimizer now allow the use of an index for a comparison of a DATE function to a constant value.

DATE(datetime_column) = const

The optimizer also has been enhanced to allow single-table UPDATE and DELETE to take advantage of semi-join optimization.

INNODB INDEX DEFRAGMENTATION REMOVED

Defragmentation of the Index B-trees via OPTIMIZE TABLE instead of rebuilding the table has the cost of excessive locking and cannot reclaim space. Because of this, it has not been used much. Later improvements to MariaDB Community Server online ALTER TABLE and OPTIMIZE TABLE made the defragmentation feature obsolete.

After deprecation with MariaDB Community Server 11.0, the related code was removed for the storage engine InnoDB, which also resulted in the removal of the parameter innodb_defragment and related parameters innodb_defragment_n_pagesinnodb_defragment_stats_accuracyinnodb_defragment_fill_factorinnodb_defragment_fill_factor_n_recs and innodb_defragment_frequency.

NOW WITH MARIADB COLUMNSTORE ENGINE VERSION 23.02

MariaDB Community Server 11.1 is the first release series which includes the new release series 23.02 of the MariaDB ColumnStore engine, which includes new features such as:

  • Support added for loading data from AWS S3 via a UDF columnstore_info.load_from_s3 which allows data loading with cpimport for those with no access to the command line.
  • Allow pushdown of queries involving UNION in outer SELECT to the ColumnStore engine.
  • MariaDB ColumnStore 23.02.1 is confirmed to be compatible with TPC-H benchmark tests.
  • Starting with this release, GROUP BY handler is disabled by default. GROUP BY pushdown may produce unexpected results. In prior releases, GROUP BY handler was rarely used because it was last in precedence.
  • UNION ALL with wrapped selects supports GROUP BY clause.
  • UNION with signed and unsigned integer types is supported.

We encourage you to try MariaDB Community Server 11.1 RC today. Please note that we do not recommend running RC releases in production.

Resources

번호 제목 글쓴이 날짜 조회 수 추천 수
166 OCI 무료 시험 프로모션 진행(Join the Race to Certification!) file 명품관 2023.06.09 144 0
» MariaDB Community Server 11.0 GA and 11.1 RC 릴리즈 소식 명품관 2023.06.07 91 0
164 VS Code 확장 프로그램으로 OCI Toolkit 발표 명품관 2023.06.02 83 0
163 Oracle Enterprise Manager 13c Release 5 Update 15 (13.5.0.15) is now available 명품관 2023.06.01 216 0
162 PostgreSQL 16 Beta 1 Released! 명품관 2023.05.26 160 0
161 pgmetrics 1.15 released 명품관 2023.05.25 53 0
160 Pgpool-II 4.4.3, 4.3.6, 4.2.13, 4.1.16 and 4.0.23 released 명품관 2023.05.25 66 0
159 MariaDB C Connector 3.3.5 and 3.1.21 now available 명품관 2023.05.25 86 0
158 MariaDB Enterprise 10.6.12-8 now available 명품관 2023.05.25 57 0
157 Oracle Linux and Unbreakable Enterprise Kernel (UEK) Releases 명품관 2023.05.24 164 0
156 ODA 19.19 Release is Now Available! 명품관 2023.05.24 195 0
155 PostgreSQL 15.3, 14.8, 13.11, 12.15, and 11.20 Released! 명품관 2023.05.18 111 0
154 PgBouncer 1.19.0 released 명품관 2023.05.18 49 0
153 MariaDB 10.11.3, 10.10.4, 10.9.6, 10.8.8, 10.6.13, 10.5.20, 10.4.29 and 10.3.39 now available 명품관 2023.05.18 177 0
152 MariaDB Node.js Connector 3.1.2 now available 명품관 2023.05.04 50 0
151 Oracle Spatial Studio 23.1 Free 릴리즈 명품관 2023.05.04 77 0
150 Exadata System Software Updates - April 2023 명품관 2023.05.03 47 0
149 MariaDB Java Connector 3.1.4 now available 명품관 2023.05.03 41 0
148 Oracle GoldenGate Free 21c now available! 명품관 2023.05.03 70 0
147 Oracle Database World 2023 - Watch the Replays 명품관 2023.04.28 48 0
위로