ืืึทืจืืึทDB 12.0.2 ืืื ืืจืืืกืืขืืขืื ืืขืืืึธืจื, ืืืึธืก ืืื ืื ืขืจืฉืืข ืกืืึทืืืืข ืืืืกืืึทืืข ืคึฟืื ืืขืจ 12.0 ืฆืืืืึทื. ืื ืืึทืจืืึทDB 12.0 ืฆืืืืึทื ืืืขืจื ืงืืึทืกืืคึฟืืฆืืจื ืืื ืึท ืจืึธืืืื ื ืืืืกืืึทืืข, ืคืึธืจืืขืฆื ืื ืืจืึทืืืขืืข ืึทื ืืืืืงืืื ื ืคึฟืื ืคึฟืื ืงืฆืืึธื ืึทืืืืขื, ืืื ืคึฟืึทืจืืืื ืื ืืึทืจืืึทDB 11.8 ืฆืืืืึทื. ืืึทืจืืึทDB 12.1.1, ืืืึธืก ืืึธื ืืขื ืกืืึทืืืก ืคึฟืื ืึท ืืืืกืืึทืืข ืงืึทื ืืืืึทื, ืืื ืืื ืืขืจ ืืขืืืขืจ ืฆืืื ืืจืืืกืืขืืขืื ืืขืืืึธืจื. ืื ืืึทืจืืึทDB 12.0 ืฆืืืืึทื ืืืขื ืืืขืจื ืืขืฉืืืฆื ืืื ืื 12.1.2 ืืืืกืืึทืืข ืืืขื ืืืขืจื ืืขืฉืึทืคึฟื.
ืื MariaDB ืคึผืจืืืขืงื ืืื ืืขืืืขืืึธืคึผืื ื ืึท ืืึธืคึผื ืคืื MySQL ืืืึธืก ืืืื ืืืื ื ืฆืืจืืง ืงืึทืืคึผืึทืืึทืืืืึทืื ืืื ืคึฟืขืึดืงืืืื ืื ืื ืึทืืจืืืฉืึทื ืคืื ื ืึธื ืกืืึธืจืืืืฉ ืขื ืืืฉืึทื ื ืืื ืึทืืืึทื ืกืืจืืข ืงืืืคึผืึทืืืืึทืืื. MariaDB ืึทื ืืืืืงืืื ื ืืื ืึธืืืืขืจืกืึทื ืืืจื ืื ืคืจืืึท MariaDB ืืืืงืืคึผืขืืืข, ื ืึธื ืึทื ืึธืคึฟื ืืื ืืจืึทื ืกืคึผืขืจืึทื ื ืึทื ืืืืืงืืื ื ืคึผืจืึธืฆืขืก ืืืึธืก ืืื ืคืจืืึท ืคืื ืืืื ืืืขื ืืึธืจืก. MariaDB ืืื ืกืึทืคึผืืืื ืืื ืึท ืคืึทืจืืืึทื ืคึฟืึทืจ MySQL ืืื ืคืืืข ืืื ืืงืก ืืืกืืจืืืืืฉืึทื ื (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) ืืื ืืื ืืืคึผืืึทืืขื ืึทื ืืื ืึทืืึท ืืจืืืก ืคึผืจืึทืืืฉืขืงืก ืืื Wikipedia, Google Cloud SQL ืืื Nimbuzz.
ืขื ืืขืจืื ืืขื ืืื ืื MariaDB 12.0 ืฆืืืืื ืึทืจืืึทื ื ืขืืขื:
- ืฆืืืขืืขืื ืฉืืืฆืข ืคึฟืึทืจ ืคึผืึทืจืึธื-ืืขืฉืืฆืืข SSL ืฉืืืกืืขื. ืคึผืึทืจืึธื ืฆื ืขืคึฟืขื ืขื ืกืกื ืกืขืจืืืคืืงืึทืฅ ืงืขื ืืืื ืืขืฉืืขืื ืืืขืจื ืืืจื ืื ssl_passphrase ืืืขืจืืึทืื ืืืขืจ ืืึทื ืืขื ืืืขื ืืขื ืกืืึทืจื ืืขื ืกืขืจืืืขืจ.
- ืฆืืืขืืขืื ืืขื ืืืืกืืจืืง "SET SESSION AUTHORIZATION" ืฆื ืืืจืืคืืจื ืื ืืงืฆืืข ืืื ืืขืจ ืื ืื ืืขืจื ืืื ืืฆืขืจ ืืืขื ืืขื ืฉืืขืื ืื ืฆืืืขืคืืกืืข ืคืจืืืืืืขืืืขืก (ืืขืจ ืืืืกืืจืืง ืงืขื ืืืืจืืื ืืืขืจื ืืืก ืื ืื ืืืื ืคืื "sudo" ืคืืจื DBMS).
- ืฆืืืขืืขืื ืฉืืืฆืข ืคึฟืึทืจ SHA-2 ืืขืฉืื ืฆื ืื file_key_management.so ืคึผืืืืื.
- ืฆืืืขืืขืื ืฉืืืฆืข ืคืืจ ืฉืืืืืข ืงืืจืกืึธืจ ืืืขืจืืึทืืืขื ืคืื ืืขื ืคืึธืจ-ืืขืคืื ืืจืื SYS_REFCURSOR ืืืคึผ, ืืืึธืก ืขืจืืืืื ืึท ืงืืจืกืึธืจ ืฆื ืืืขืจื ืฆืืจืืงืืขืืขืื ืคืื ืกืืึธืจื ืคึผืจืึธืืกืืืืฉืขืจื (ืืื ืืขื OUT ืคึผืึทืจืึทืืขืืขืจ) ืึธืืขืจ ืคืื ืคืื ืงืฆืืขืก (ืืื ืืขืจ RETURN ืกืืขืืืืขื ื). ืื ืกืืกืืขื ืืืขืจืืึทืืืข "max_open_cursors" ืืื ืฆืืืขืืขืื ืืขืืืึธืจื ืฆื ืืึทืืจืขื ืขืฆื ืื ืืึทืงืกืืืื ืฆืึธื ืคืื ืืืืืืฆืืืืื ืึธืคึฟืขื ืข ืงืืจืกืึธืจื.
- ืืขืจ TO_CHAR ืืืค ืฉืืืฆื ืืืฆื ืืขื FM (ืคืื ืืึธืืข) ืคึฟืึธืจืืึทื ืฆื ืคึฟืึทืจืืืึทืื ื ืึธื ืึธื ืคึฟืืื. ืืืฉื, ืื ืคึฟืจืึทืืข "SELECT CONCAT('/', TO_CHAR('2020-01-06 10:11:12', 'FMDAY'), '/');" ืืืขื ืฆืืจืืงืืขืื "/ืืึธื ืืืง/" ืึทื ืฉืืึธื "/ืืึธื ืืืง /".
- ืื mariadb-check ื ืืฆืืขืืงืืื ืืื ืื CHECK TABLE ืืืืกืืจืืง ืืขื ืขื ืืขืืืืจื ืืขืจืืืึทื ืืืงื ืฆื ืฉืืืฆื ืืืฉื ืคืื ืื SEQUENCE ืืึธืืึธืจ.
- ืืขืจ ืึธืคึผืืืืืืืจืขืจ ืฉืืืฆื ืืืฆื ืึธืคึผืฆืืขืก (ืืื ืฅ) ืืืึธืก ืืึธืื ืึทื ืืฉืคึผืขื ืืืืฃ ืืขืจ ืงืึทื ืกืืจืืงืฆืืข ืคึฟืื ืืขื ืึธืคึผืืืืืืึทืฆืืข ืคึผืืึทื: QB_NAME, NO_RANGE_OPTIMIZATION, NO_ICP, MRR, NO_MRR, BKA, NO_BKA, BNL, NO_BNL, SEMIJOIN, SUBQUERY, JOIN_FIXED_ORDER, JOIN_ORDER, JOIN_PREFIX, JOIN_SUFFIX ืืื MAX_EXECUTION_TIME. ืื ืึธืคึผืฆืืขืก ืืืขืจื ืึทืจืฒึทื ืืขืฉืืขืื ืืื ืืขืจ ืงืืืขืจื ืืื ืึท ืคึฟืึธืจืืึทื ืงืึธืืคึผืึทืืืื ืืื MySQL, ืืืฉื: SELECT /*+ BKA(t1) NO_BKA(t2) */ * FROM t1 INNER JOIN t2 WHERE โฆ; SELECT /*+ MAX_EXECUTION_TIME(1000) */ * FROM t1 INNER JOIN t2 WHERE โฆ;
- ืฆืืืขืืขืื ืฉืืืฆืข ืคึฟืึทืจ ื ืฒึทืข GIS (ืืขืึธืืจืึทืคึฟืืฉืข ืืื ืคึฟืึธืจืืึทืฆืืข ืกืืกืืขื) ืคืื ืงืฆืืขืก: ST_Validate, MBRCoveredBy, ST_Simplif, ST_GeoHash, ST_LatFromGeoHash, ST_LongFromGeoHash, ST_PointFromGeoHash, ST_IsValid, ST_Collect.
- ืฆืืืขืืขืื ืฉืืืฆืข ืคืืจ ืืจืืืขืจืก ืืืืก ืื ืฆืื ืื ืืื ืืืืฃ ืงืืืคื ืืขืฉืขืขื ืืฉื. ืื CREATE TRIGGER ืกืืขืืืืขื ื ืงืขื ืืืฆื ืืืกืื ืื ืืขืฉืขืขื ืืฉื ืืืืก ืฉืืืืขื ืืขืจืฆื ื ืืฆื ืืื ืื ืกืื ืืืงืก "{ event [ OR โฆ ] }".
- ืืขืจ ืืืืืื ืคึผืืืืื ืจืึทืืขืืืขื ืืืฆื ืืื ืคึฟืึธืจืืึทืฆืืข ืืืขืื ื ืขืฅ ืคึผืึธืจืื ืคึฟืึทืจ ืืื ืงืึทืืื ื ืงืึทื ืขืงืฉืึทื ื ืืื ืืขื ืืืืืื ืืึธื (ืคืจืืขืจ ืืื ื ืึธืจ ืืขืจ ืืึธืกื ืืขืืืืื ืืขืืืึธืจื).
- ืื mariadb ื ืืฆืืึทืจืงืืื ืืื ืึท "--script-dir" ืึธืคึผืฆืืข ืฆื ืกืคึผืขืฆืืคึฟืืฆืืจื ืึทื ืึทืืืขืจื ืึทืืืืืข ืืืื ืืืจืขืงืืึธืจื ืคึฟืึทืจ ืกืงืจืืคึผืื ืืืึธืก ืืืขืจื ืืขืืึธืคึฟื ืืืจื ืื SOURCE ืืึทืคึฟืขื.
- ืึทืืืขืงืืขื ืืืขื ืคืจืืขืจ ืืืคึผืจืืฉืืืืืื ืืืขืจืืึทืืึทืื big_tables, large_page_size, ืืื storage_engine.
ืืงืืจ: opennet.ru
