{"id":136040,"date":"2025-06-09T15:05:09","date_gmt":"2025-06-09T13:05:10","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/opublikovana-novaya-lts-vetka-subd-mariadb-11-8"},"modified":"2025-06-09T15:05:09","modified_gmt":"2025-06-09T13:05:10","slug":"opublikovana-novaya-lts-vetka-subd-mariadb-11-8","status":"publish","type":"post","link":"https:\/\/prohoster.info\/en\/blog\/news\/opublikovana-novaya-lts-vetka-subd-mariadb-11-8","title":{"rendered":"A new LTS branch of the MariaDB database management system 11.8 has been released.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
The release of the MariaDB Database Management System 11.8.2 has been announced, marking the first stable release of the 11.8 branch. The MariaDB 11.8 branch is designated for long-term support and will be maintained for at least 5 years. At the same time, MariaDB 12.0.1 is available, which is designated as a release candidate. <\/p>\n
The MariaDB project develops a fork from MySQL, preserving backward compatibility and distinguished by the integration of additional storage engines and enhanced capabilities. The development of MariaDB is overseen by the independent MariaDB Foundation in accordance with an open and transparent development process that is not dependent on individual vendors. MariaDB is supplied instead of MySQL in many Linux distributions (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) and is implemented in major projects such as Wikipedia, Google Cloud SQL, and Nimbuzz. <\/p>\n
Changes in the MariaDB 11.8 branch compared to the previous LTS release 11.4 include: <\/p>\n
\n
The integration of developments from the MariaDB Vector project, which enhances capabilities for vector search, in demand in machine learning systems. Built-in support for the data type VECTOR has been implemented, along with the functions VEC_DISTANCE_EUCLIDEAN(), VEC_DISTANCE_COSINE(), and VEC_DISTANCE() to calculate vector similarity, as well as the functions VEC_FromText() and VEC_ToText() for converting between binary and text representations of vectors. Optimizations for vector processing using Intel CPU SIMD extensions (AVX2 and AVX512), ARM, and IBM Power10 have been implemented. Testing has shown that the performance of vector queries in MariaDB exceeds that of Redis, pgvector, qdrant, and weaviate.
<\/center>\n
The year 2038 problem has been addressed. The boundary value for the TIMESTAMP type has been increased from 2038 to 2106.\n
By default, the Unicode (utf8mb4) encoding with full emoji support is set instead of latin1. The locale properties 'Collation' that determine the sorting and comparison rules considering the meaning of characters have been updated to version UCA 14.0.0.\n
A new password authentication plugin PARSEC (Password Authentication with Response Signed by Elliptic Curves) has been added, which uses the PBKDF2 function for password hashing and verifies responses using a public key based on the ed25519 digital signature scheme.\n
Authentication for database access from the local system has been improved using UNIX sockets.\n
Support for multithreaded backup creation and restoration has been added to mariadb-dump and mariadb-import. Parallelization is applied both when dumping a single large database and during simultaneous backups of multiple databases.\n
Replication performance has been significantly improved. To speed up the acceptance of very large transactions, a binary log (binlog) segment switching mechanism has been implemented to avoid resource-intensive file copy operations. To reduce restart time after failures, transaction rollback in asynchronous mode has been provided. A new setting 'slave_replication_delay_abort_timeout' has been added, which allows automatically aborting transactions that block replication for too long.\n
Monitoring tools have been expanded. Additional columns for performance analysis and problem diagnosis have been added to the statistics tables.\n
A USERS table has been added, containing information about users, the restrictions applied to them, and the duration of their passwords.\n
The commands 'FLUSH GLOBAL STATUS', 'REPAIR TABLE \u2026 FORCE', and 'SHOW CREATE SERVER' have been added.\n
The ability to return values with a ROW type from stored procedures has been introduced.\n
Compatibility with Oracle database management systems has been improved when working with sequences. The operation 'CREATE SEQUENCE \u2026 AS' can now be used with any integer types, including 'BIGINT UNSIGNED'.\n
New functions for generating UUIDs have been added \u2014 UUID_v7 and UUID_v4.\n
A FORMAT_BYTES function has been introduced for converting byte counts into a human-readable format (for example, FORMAT_BYTES(1000000000) will yield 953.67 MiB).\n
The ability to limit disk space used for temporary files and temporary tables has been added. Settings max_tmp_session_space_usage and max_tmp_total_space_usage have been introduced to set limits for both individual users and all users.\n
The query optimizer has accelerated the processing of UPDATE\/DELETE operations on a single table. By default, optimizations that truncate encodings to a smaller subset of characters have been enabled. Queries with expressions 'SUBSTR(col, 1, n) = const_str' have been sped up. Support for optimizing virtual columns has been added. <\/ul>\n
![\"A](\"\/wp-content\/uploads\/2025\/06\/5dab0cbe2844dfeca0434c966be5ee52.png\")
<\/center>\n