MariaDB 12.0.2 ua faʻasaʻolotoina, faʻailogaina o le faʻasalalauga muamua o le lala 12.0. O le MariaDB 12.0 lala o loʻo faʻavasegaina o se faʻasalalauga faʻasalalau, faʻaauau le atinaʻeina malie o galuega, ma sui ai le lala MariaDB 11.8. MariaDB 12.1.1, o loʻo i ai le tulaga o se sui faʻamalolo, ua faʻasalalau i le taimi e tasi. O le a lagolagoina le lala MariaDB 12.0 seia oʻo ina faʻatūina le faʻasalalauga 12.1.2.
O le poloketi a le MariaDB o loʻo atiaʻe se tui mai MySQL e faʻatumauina le fesoʻotaʻiga i tua ma faʻaalia le tuʻufaʻatasia o masini faʻapipiʻi faʻapipiʻi ma agavaʻa maualuga. O le atinaʻeina o MariaDB o loʻo vaʻaia e le MariaDB Foundation tutoʻatasi, i le mulimulitaʻia o se faʻagasologa matala ma manino le atinaʻe e tutoatasi mai tagata faʻatau taʻitoʻatasi. MariaDB ua tuʻuina atu e fai ma sui mo MySQL i luga o le tele o tufatufaga Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) ma ua faʻatinoina i galuega tetele e pei o Wikipedia, Google Cloud SQL ma Nimbuzz.
Suiga i le lala MariaDB 12.0 e aofia ai:
- Fa'aopoopo le lagolago mo ki SSL e puipuia e upu fa'alilolilo. Upu fa'alilolilo e tatala ai SSL tusi faamaonia e mafai ona setiina e ala i le fesuiaiga ssl_passphrase pe faia e ala i le lima pe a amata le 'au'aunaga.
- Faʻaopoopo le faʻamatalaga "SET SESSION AUTHORIZATION" e fai ai se gaioiga i lalo o se isi tagata faʻaoga pe a faʻatulagaina avanoa talafeagai (o le faʻamatalaga e mafai ona manatu o se faʻatusa o le "sudo" mo le DBMS).
- Fa'aopoopo le lagolago mo SHA-2 hashes ile file_key_management.so plugin.
- Fa'aopoopoina le lagolago mo suiga vaivai o le fetu'u o le ituaiga SYS_REFCURSOR ua uma ona fa'avasegaina, e mafai ai ona toe fa'afo'i mai se fa'ailo mai faiga fa'apolopolo (i le OUT parameter) po'o mai galuega (i le fa'amatalaga RETURN). Ole suiga ole faiga "max_open_cursors" ua fa'aopoopoina e fa'atapula'a ai le aofa'i maualuga ole fa'atalatala fa'atasi ile taimi e tasi.
- Ole ituaiga TO_CHAR o lo'o lagolagoina nei le FM (Fill Mode) e 'alofia ai le fa'atumuina fa'aopoopo. Mo se fa'ata'ita'iga, ole fesili "SELECT CONCAT('/', TO_CHAR('2020-01-06 10:11:12', 'FMDAY'), '/');" o le a toe foi mai "/Aso Gafua/" nai lo le "/Aso Gafua /".
- Ole fa'aoga mariadb-check ma le fa'aaliga CHECK TABLE ua fa'afouina e lagolago ai laulau mai le afi SEQUENCE.
- Ua lagolagoina nei e le optimizer filifiliga (fa'ata'ita'iga) e a'afia ai le fausiaina o le fuafuaga fa'ata'atia: QB_NAME, NO_RANGE_OPTIMIZATION, NO_ICP, MRR, NO_MRR, BKA, NO_BKA, BNL, NO_BNL, SEMIJOIN, SUBQUERY, JOIN_FIXED_ORDER, JOIN_ORDER_ORDER, JOIN_PORDER, JOIN_ORDER_ORDER, JOIN_PORDER MAX_EXECUTION_TIME. O filifiliga e sui i le fesili i se faatulagaga e fetaui ma MySQL, mo se faʻataʻitaʻiga: SELECT /**+ BKA(t1) NO_BKA(t2) */ * FROM t1 INNER JOIN t2 WHERE …; FILIFILIA /*+ MAX_TAIMI_FA'ATA'IGA(1000) */ * MAI t1 TOTOGA FA'AIGA T2 O FEA …;
- Fa'aopoopo le lagolago mo galuega fou GIS (Geographic Information System): ST_Validate, MBRCoveredBy, ST_Simplif, ST_GeoHash, ST_LatFromGeoHash, ST_LongFromGeoHash, ST_PointFromGeoHash, ST_IsValid, ST_Collect.
- Fa'aopoopo le lagolago mo fa'aoso e mu i le tele o mea tutupu. O le fa'amatalaga CREATE TRIGGER e mafai nei ona lisi mea na tutupu e fetaui ma le fa'aogaina o le syntax "{ event [ OR ... ] }".
- O lo'o fa'asaoina nei e le Su'etusi fa'amatalaga e uiga i ports feso'ota'iga mo feso'ota'iga o lo'o sau i totonu o le fa'amaumauga su'etusi (muamua na'o le tagata talimalo na fa'aalia).
- O le fa'aoga mariadb e iai le "--script-dir" filifiliga e fa'amaoti ai se isi su'esu'ega su'esu'e mo fa'amaumauga e fa'atautaia e le SOURCE command.
- Ave'ese suiga na fa'agata muamua big_tables, large_page_size, ma storage_engine.
puna: opennet.ru
