published The first stable release of the new DBMS branch Mariadb 10.11 (10.11.2), which develops a branch from MySQL, which retains reverse compatibility and differs in the integration of additional storage engines and advanced opportunities. The development of Mariadb is supervised by the independent organization of Mariadb Foundation in accordance with the open and transparent development process, independent of individual manufacturers. Mariadb is delivered instead of MySQL in many distributions of Linux (Rhel, Suse, Fedora, Opensuse, Slackware, OpenMandriva, Rosa, Arch Linux, Debian) and implemented in such large projects, Google Cloud SQL and NIMBUZ. Alpha testing is a branch 11.0, which proposes significant improvements and changes that violate compatibility. The Mariadb 10.11 branch is assigned to the category of issues with a long term of support and will be accompanied by parallel with Mariadb 11.x until February 2028.
Key improvements in Mariadb 10.11:
- implemented Operation “ Grant … to public “, with which you can provide certain privileges at once to all users on the server.
- The powers are divided super and “ Read only admin ” – the privilege “Super” now does not cover the rights “Read only admin” (the possibility of recording, even if the regime is only for reading).
- In the inspection mode “Analyze Format = JSON” is provided by a display of time spent by the optimizer of queries.
- Signed problems with performance, manifested when reading from a table with storage parameters, as well as when completely scanning tables with parameters and procedures for storage scheme.
- In the mariadb-dump utility added Supporting and restoring historical data from versioned tables.
- added System_versioning_insert_History Settings to manage the possibility of amendments to past versions of data in versionized tables.
- It is allowed to change the settings of Innodb_write_io_threads and Innodb_read_io_threads on the fly without the need to restart the server.
- On the Windows platform, the entrance to Windows administrators as a Root in Mariadb without entering a password.
- Переименованы переменные log_slow_min_examined_row_limit (min_examined_row_limit), log_slow_query (slow_query_log), log_slow_query_file (slow_query_log_file) и log_slow_query_time (long_query_time).