MariaDB 10.11 tso tawm ruaj khov

Thawj qhov ruaj khov tso tawm tshiab ntawm MariaDB 10.11 (10.11.2) DBMS ceg tau tshaj tawm, nyob rau hauv uas ib ceg los ntawm MySQL tau tsim kho uas tswj kev rov qab sib raug zoo thiab txawv los ntawm kev sib koom ua ke ntawm cov cav ntxiv thiab cov yam ntxwv siab heev. MariaDB txoj kev txhim kho yog saib xyuas los ntawm MariaDB Foundation ywj pheej, ua raws li txoj kev txhim kho qhib thiab pob tshab ntawm tus neeg muag khoom. MariaDB raug xa mus rau qhov chaw ntawm MySQL ntawm ntau Linux faib (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) thiab tau txais los ntawm cov haujlwm loj xws li Wikipedia, Google Cloud SQL, thiab Nimbuzz.

Tib lub sijhawm, 11.0 ceg yog nyob rau hauv kev sim alpha, uas muaj kev txhim kho tseem ceeb thiab kev hloov pauv uas cuam tshuam kev sib raug zoo. Lub koom haum MariaDB 10.11 tau raug cais raws li kev txhawb nqa mus sij hawm ntev thiab yuav raug tswj xyuas ib sab nrog MariaDB 11.x txog thaum Lub Ob Hlis 2028.

Kev txhim kho tseem ceeb hauv MariaDB 10.11:

  • Kev ua haujlwm "GRANT ... PUBLIC" tau ua tiav, nrog kev pabcuam uas koj tuaj yeem tso cai rau txhua tus neeg siv ntawm lub server ib zaug.
  • SUPER thiab "NYEEM XWB ADMIN" kev tso cai raug cais - "SUPER" txoj cai tsis suav nrog "READ ADMIN nkaus xwb" kev tso cai (lub peev xwm sau ntawv, txawm tias hom tau teeb tsa los nyeem nkaus xwb).
  • Nyob rau hauv "Tshaj tawm FORMAT = JSON" hom tshuaj xyuas, lub sijhawm siv los ntawm cov lus nug optimizer tau qhia.
  • Kev daws teeb meem kev ua tau zoo uas tshwm sim thaum nyeem los ntawm lub rooj nrog cov txheej txheem khaws cia, nrog rau thaum kuaj xyuas cov rooj tag nrho nrog cov txheej txheem khaws cia thiab cov txheej txheem.
  • Kev them nyiaj yug rau kev txuag thiab kho cov ntaub ntawv keeb kwm yav dhau los ntawm cov lus versioned tau ntxiv rau mariadb-dump utility.
  • Ntxiv qhov teeb tsa system_versioning_insert_history los tswj lub peev xwm los hloov pauv cov ntaub ntawv dhau los ntawm cov ntaub ntawv hauv cov rooj sib tham.
  • Tso cai hloov innodb_write_io_threads thiab innodb_read_io_threads teeb tsa ntawm ya yam tsis tas yuav rov pib lub server.
  • Ntawm Windows platform, Windows cov thawj coj tuaj yeem nkag rau hauv hauv paus rau MariaDB yam tsis tau nkag mus rau tus password.
  • Cov variables log_slow_min_examined_row_limit (min_examined_row_limit), log_slow_query (slow_query_log), log_slow_query_file (slow_query_log_file), thiab log_slow_query_time (long_query_time) tau hloov npe.

Tau qhov twg los: opennet.ru

Ntxiv ib saib