ื ืึธื ืึท ืืึธืจ ืคืื ืึทื ืืืืืงืืื ื ืืื ืืจืื ืคึผืจืืืืืึทื ืขืจื ืจืืืืกืื, ืืขืจ ืขืจืฉืืขืจ ืกืืึทืืื ืืขืืืื ื ืคืื ืื ื ืืึทืข ืฆืืืืึทื ืคืื ืื MariaDB 10.6 DBMS ืืื ืืจืืืก, ืืื ืืืึธืก ืึท ืฆืืืืึทื ืคืื MySQL ืืื ืืขืืืขืืึธืคึผืขื ืืืึธืก ืืืื ืืืื ื ืฆืืจืืง ืงืึทืืคึผืึทืืึทืืืืึทืื ืืื ืืื ืืื ืืขืจืฉืืืื ืืืจื ืื ืื ืึทืืจืืืฉืึทื ืคืื ื ืึธื ืกืืึธืจืืืืฉ ืขื ืืืฉืึทื ื ืืื ืึทืืืึทื ืกืืจืืข ืงืืืคึผืึทืืืืึทืืื. ืฉืืืฆื ืคึฟืึทืจ ืื ื ืืึทืข ืฆืืืืึทื ืืืขื ืืืื ืฆืืืขืฉืืขืื ืคึฟืึทืจ 5 ืืึธืจ, ืืื ืืืื 2026.
MariaDB ืึทื ืืืืืงืืื ื ืืื ืึธืืืืขืจืกืึทื ืืืจื ืื ืคืจืืึท MariaDB ืืืืงืืคึผืขืืืข, ื ืึธื ืึท ืืึธืจ ืึธืคึฟื ืืื ืืจืึทื ืกืคึผืขืจืึทื ื ืึทื ืืืืืงืืื ื ืคึผืจืึธืฆืขืก ืืืึธืก ืืื ืคืจืืึท ืคืื ืืืื ืืืขื ืืึธืจืก. MariaDB ืืื ืกืึทืคึผืืืื ืืื ืึท ืคืึทืจืืืึทื ืคึฟืึทืจ MySQL ืืื ืคืืืข ืืื ืืงืก ืืืกืืจืืืืืฉืึทื ื (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) ืืื ืืื ืืืคึผืืึทืืขื ืึทื ืืื ืึทืืึท ืืจืืืก ืคึผืจืึทืืืฉืขืงืก ืืื Wikipedia, Google Cloud SQL ืืื Nimbuzz.
ืฉืืืกื ืืืคึผืจืืืืืึทื ืฅ ืืื MariaDB 10.6:
- ืื ืึทืืึธืืืฉืข ืืืจืืคืืจืื ื ืคืื ืื ืืืืกืืจืืงื "CREATE TABLE|VIEW|SEQUENCE|TRIGGER", "ALTER TABLE|SEQUENCE", "Rename TABLE|TABLES", "DROP TABLE|VIEW|VIEW|TRIGGER|DATABASE" ืืื ืื ืฉืืจื (ืึธืืขืจ ืืขืจ ืืืืกืืจืืง ืืื ืืึธืจ ืืขืขื ืืืงื ืึธืืขืจ ืึทืืฅ ืืื ืืืืืขืงืขืจื ืฆื ืืืื ืึธืจืืืื ืขื ืฉืืึทื). ืืื ืืขื ืคืึทื ืคืื "DROP TABLE" ืึทืคึผืขืจืืืฉืึทื ื ืืืึธืก ืืืกืืขืงื ืขืืืขืืข ืืืฉื ืืื ืึทืืึธื, ืึทืืึธืืืกืืื ืืื ืื ืฉืืจื ืืืืฃ ืืขืจ ืืืจืื ืคืื ืืขืืขืจ ืืืื ืืืฉ. ืืขืจ ืฆืื ืคืื ืืขืจ ืขื ืืขืจืื ื ืืื ืฆื ืขื ืฉืืจ ืึธืจื ืืืขืืงืืึทื ืืื ืื ืืขืฉืขืขื ืืฉ ืคืื ืึท ืกืขืจืืืขืจ ืงืจืึทื ืืขืฉืึทืก ืึทื ืึธืคึผืขืจืึทืฆืืข. ืืื ืึทืืขืจ, ื ืึธื ืึท ืงืจืึทื, ืฆืืึทืืืืืึทืืืง ืืืฉื ืืื ืืขืงืขืก ืงืขื ืืืืึทืื, ืื ืกืื ืืงืจืึทื ืึทืืืืฉืึทื ืคืื ืืืฉื ืืื ืกืืึธืจืืืืฉ ืขื ืืืฉืึทื ื ืืื ืคืจื ืืขืงืขืก ืงืขื ืืืื ืืืกืจืึทืคึผืืื, ืืื ืืืื ืืืฉื ืงืขื ืืืืึทืื ืึทื ืจืื ืืื ืืืขื ืขืืืขืืข ืืืฉื ืืขื ืขื ืจืื ืืืื ืืื ืึทืืึธื. ืึธืจื ืืืขืืงืืึทื ืืื ืื ืฉืืจื ืืืจื ืืืื ืืืื ืื ื ืึท ืฉืืึทื ืึธืคึผืืื ืงืืึธืฅ, ืืขืจ ืืจื ืฆื ืืืึธืก ืงืขื ืขื ืืืื ืืืฉืืืกื ืืืจื ืื ื ืืึทืข ืึธืคึผืฆืืข "-log-ddl-recovery=file" (ddl-recovery.log ืืืจื ืคืขืืืงืืึทื).
- ืื "SELECT ... OFFSET ... FETCH" ืงืึทื ืกืืจืึทืงืฉืึทื ืืืคืืื ื ืืื ืื SQL 2008 ื ืึธืจืืึทื ืืื ืืืคึผืืึทืืขื ืึทื, ืึทืืึทืืื ื ืืืจ ืฆื ืืืืึทืื ืึท ืืืืขืจ ื ืืืขืจ ืคืื ืจืึธืื ืกืืึทืจืืื ื ืคืื ืึท ืกืคึผืขืกืืคืืขื ืคืึธืืึธ, ืืื ืื ืคืืืืงืืื ืฆื ื ืืฆื ืื "ืืื ืืืื" ืคึผืึทืจืึทืืขืืขืจ ืฆื ืฆืืืฉืขืคึผืขื ืื ืืขืจื ืืืืึทืืขืจ ืืืขืจื. ืฆืื ืืืืฉืคึผืื, ืืขืจ ืืืืกืืจืืง "SELECT i FROM t1 ORDER BY i ASC OFFSET 1 ROWS FETCH FIRST 3 ROWS WITH TIES" ืืื ืึทื ืืขืจืฉ ืคืื ืื ืงืึทื ืกืืจืึทืงืฉืึทื "SELECT i FROM t1 ORDER BY i ASC LIMIT 3 OFFSET 1" ืืืจื ืึทืจืืืกืคืืจื ื ืึธื ืืืื ืขืืขืืขื ื ืืื ืื ืขืง. (ืึทื ืฉืืึธื 3 4 ืฉืืจืืช ืืืขื ืืืื ืจืขืืืืืึทื).
- ืคึฟืึทืจ ืื InnoDB ืืึธืืึธืจ, ืื "SELECT ... SKIP LOCKED" ืกืื ืืึทืงืก ืืื ืืืคึผืืึทืืขื ืึทื, ืืืึธืก ืึทืืึทืื ืืืจ ืฆื ืืืกืฉืืืกื ืจืึธืื ืคึฟืึทืจ ืืืึธืก ืึท ืฉืืึธืก ืงืขื ืขื ื ืื ืืืื ืฉืืขืื ("ืืึทืง ืืื ืืึทื ืืืืื ืืึธืืข" ืึธืืขืจ "ืคึฟืึทืจ ืืขืจืืืึทื ืืืงืื ืืขื").
- ืื ืคืืืืงืืื ืฆื ืืืื ืึธืจืืจื ืื ืืขืงืกืื ืืื ืืืคึผืืึทืืขื ืึทื (ืืื MySQL 8, ืื ืคืึทื ืืงืฉืึทื ืึทืืืื ืืื ืืขืจืืคึฟื "ืืืืขืืง ืื ืืขืงืกืื"). ืืึทืจืงืื ื ืึทื ืืื ืืขืงืก ืฆื ืืืื ืึธืจืืจื ืืื ืืืจืืืขืงืึธืื ืืื ืื IGNORED ืคืึธื ืืื ืื ALTER TABLE ืืืกืืึธืืื ื, ื ืึธื ืืืึธืก ืืขืจ ืืื ืืขืงืก ืืืืืื ืงืขื ืืืง ืืื ืืขืจืืืึทื ืืืงื, ืึธืืขืจ ืืื ื ืืฉื ืืขื ืืฆื ืืืจื ืื ืึธืคึผืืืืืืขืจ.
- ืฆืืืขืืขืื JSON_TABLE () ืคึฟืื ืงืฆืืข ืฆื ืืขืจ JSON ืืึทืื ืืื ืจืืืืืฉืึทื ืึทื ืคืึธืจืขื. ืคึฟืึทืจ ืืืึทืฉืคึผืื, ืึท JSON ืืึธืงืืืขื ื ืงืขื ืขื ืืืื ืคืืจืืืื ืืืขื ืคึฟืึทืจ ื ืืฆื ืืื ืืขื ืงืึธื ืืขืงืกื ืคืื ืึท ืืืฉ, ืืืึธืก ืงืขื ืขื ืืืื ืกืคึผืขืกืืคืืขื ืืื ืึท FROM ืืืึธืง ืืื ืึท SELECT ืืืกืืึธืืื ื.
- ืืืคึผืจืืืื ืงืึทืืคึผืึทืืึทืืืืึทืื ืืื Oracle DBMS: ืึทืืืขื ืฉืืืฆื ืคึฟืึทืจ ืึทื ืึทื ืึทืืึทืก ืกืึทืืงืืืขืจืื ืืื ืื FROM ืืืึธืง. ืืืคึผืืขืืขื ืืขื ืืื ืืก ืืืืขื (ืขืงืืืืืืึทืืขื ื ืฆื ืึทืืืฅ). ืฆืืืขืืขืื ADD_MONTHS(), TO_CHAR(), SYS_GUID() ืืื ROWNUM() ืคืึทื ืืงืฉืึทื ื.
- ืืื ืื InnoDB ืืึธืืึธืจ, ืื ืกืขืจืืื ื ืืื ืืืืืืง ืืืฉื ืืื ืึทืงืกืขืืขืจืืืืื. ืื COMPRESSED ืฉืืจืืงื ืคึฟืึธืจืืึทื ืืื ืืึทืฉืืืื ืฆื ืืืืขื ืขื-ืืืืื ืืึธืืข ืืืจื ืคืขืืืงืืึทื. ืื SYS_TABLESPACES ืกืืขืืข ืจืืคึผืืืืกื SYS_DATAFILES ืืื ืืืืื ืจืืคืืขืงืก ืื ืฉืืึทื ืืื ืื ืืขืงืข ืกืืกืืขื. ืคืืื ืฉืจืืึทืื ืฉืืืฆื ืืื ืฆืืืขืฉืืขืื ืคึฟืึทืจ ืื ืฆืืึทืืืืืึทืืืง ืืืฉ ืคึผืืึทืฅ. ืฉืืืฆื ืคึฟืึทืจ ืื ืึทืื ืืฉืขืงืงืกืื ืึทืืืขืจืืืึทื, ืืืึธืก ืืื ืืขืืืขื ืจืืืืื ื ืคึฟืึทืจ ืงืึทืืคึผืึทืืึทืืืืึทืื ืืื MariaDB 5.5, ืืื ืึธืคึผืืขืฉืืขืื.
- ืืื ืื ืจืขืคึผืืึทืงืืืฉืึทื ืกืืกืืขื, ืื ืืจืืืก ืคืื ืื ืืึทืกืืขืจ_ืืึธืกื ืคึผืึทืจืึทืืขืืขืจ ืืืขืจื ืืื ืืขืืืืงืกื ืคืื 60 ืฆื 255 ืืืชืืืช, ืืื ืืึทืกืืขืจ_ืืกืขืจ ืฆื 128. ืื binlog_expire_logs_seconds ืืืึทืืขืืืืืง ืืื ืฆืืืขืืืืื ืฆื ืงืึทื ืคืืืืขืจ ืื ืขืงืกืคึผืขืจืืืฉืึทื ืฆืืื ืคืื ืื ืืืื ืขืจื ืงืืึธืฅ ืืื ืกืขืงืื ืืขืก (ืคืจืืขืจ, ืื ืืึทืฉืืขืืืง ืฆืืื ืืื ืืขืืืขื ืืืฉืืืกื ืืืืื ืืื ืืขื ืืืจื ืื ืขืงืกืคึผืืจืข_ืืึธืืก_ืืืึทืก ืืืึทืืขืืืืืง).
- ืื Galera ืกืื ืืฉืจืึธื ืึธืืก ืืืืื-ืืขื ืจืขืคึผืืึทืงืืืฉืึทื ืืขืงืึทื ืืืึทื ืืืคึผืืึทืืึทื ืฅ ืื wsrep_mode ืืืึทืืขืืืืืง ืฆื ืงืึทื ืคืืืืขืจ ืื WSREP (Write Set REPlication) API ืคึผืึทืจืึทืืขืืขืจืก. ืืขืจืืืืื ืงืึทื ืืืขืจืืฉืึทื ืคืื Galera ืคืื ืึทื ืขื ืงืจืืคึผืืื ืงืึธืืื ืืงืึทืฆืืข ืฆื TLS ืึธื ืกืืึธืคึผืคึผืื ื ืืขื ืงื ืืื.
- ืื ืกืืก-ืกืืฉืขืืึท ืกืืฉืขืืึท ืืื ืืืคึผืืึทืืขื ืึทื, ืืืึธืก ืึผืืื ืึท ืืึทืืืื ื ืคืื ืงืืงื, ืคืึทื ืืงืฉืึทื ื ืืื ืคึผืจืึธืืกืืืืฉืขืจื ืคึฟืึทืจ ืึทื ืึทืืืืืื ื ืืึทืืึทืืืืก ืึทืคึผืขืจืืืฉืึทื ื.
- ืฆืืืขืืืืื ืืื ืกื ืืืฉื ืคึฟืึทืจ ืึทื ืึทืืืืืื ื ืจืขืคึผืืึทืงืืืฉืึทื ืคืึธืจืฉืืขืืื ื.
- ืื INFORMATION_SCHEMA.KEYWORDS ืืื INFORMATION_SCHEMA.SQL_FUNCTIONS ืงืืงื ืืขื ืขื ืฆืืืขืืขืื ืฆื ืื ืืึทื ื ืคืื ืืื ืคึฟืึธืจืืึทืฆืืข ืืืฉื, ืืืืึทืื ืืืง ืึท ืจืฉืืื ืคืื ืคืึทืจืึทื ืขื ืืขืจืืื ืขื ืืื ืคืึทื ืืงืฉืึทื ื.
- TokuDB ืืื CassandraSE ืจืืคึผืึทืืึทืืึธืจืื ืืขื ืขื ืึทืืืขืงืืขื ืืืขื.
- ืื utf8 ืงืึธืืืจืื ื ืืื ืืจืืืขืจืืขืคืืจื ืคืื ืื ืคืืจ-ืืืืข ืคืึทืจืืจืขืืื ื utf8mb4 (U+0000..U+10FFFF) ืฆื ืื ืืจืื-ืืืืข utf8mb3 (ืืขืงื ืื ืืื ืืงืึธื ืงืืื U+0000..U+FFFF).
- ืฆืืืขืืืืื ืฉืืืฆื ืคึฟืึทืจ ืืึธืืขื ืึทืงืืึทืืืืืฉืึทื ืืื ืกืืกืืขื.
- ืื GSSAPI ืคึผืืืืื ืืื ืฆืืืขืืืืื ืฉืืืฆื ืคึฟืึทืจ ืึทืงืืืืืข Directory ืืจืืคึผืข ื ืขืืขื ืืื SIDs.
- ืฆืืืขืืืืื ืืฉืขืง ืคึฟืึทืจ ืืืึทืืืึทื ืคืื ืงืึทื ืคืืืืขืจืืืฉืึทื ืืขืงืข $ MARIADB_HOME/my.cnf ืืื ืึทืืืฉืึทื ืฆื $ MYSQL_HOME/my.cnf.
- ื ืื ืกืืกืืขื ืืืขืจืืึทืืึทืื binlog_expire_logs_seconds, innodb_deadlock_report, innodb_read_only_compressed, wsrep_mode ืืื Innodb_buffer_pool_pages_lru_freed ืืขื ืขื ืืืคึผืืึทืืขื ืึทื.
ืืงืืจ: opennet.ru