{"id":100127,"date":"2021-05-09T22:23:13","date_gmt":"2021-05-09T20:23:13","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-vysokoproizvoditelnoj-vstraivaemoj-subd-libmdbx-0-10"},"modified":"2021-05-09T22:23:13","modified_gmt":"2021-05-09T20:23:13","slug":"vypusk-vysokoproizvoditelnoj-vstraivaemoj-subd-libmdbx-0-10","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/news\/vypusk-vysokoproizvoditelnoj-vstraivaemoj-subd-libmdbx-0-10","title":{"rendered":"L\u00ebshimi i sistemit t\u00eb menaxhimit t\u00eb t\u00eb dh\u00ebnave t\u00eb integruar me performanc\u00eb t\u00eb lart\u00eb libmdbx 0.10","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
Pas tre muajsh zhvillimi, u l\u00ebshua biblioteca libmdbx 0.10.0 (MDBX) me implementimin e nj\u00eb baze t\u00eb dh\u00ebnash t\u00eb integruar, t\u00eb kompakt\u00eb, dhe me performanc\u00eb t\u00eb lart\u00eb, e klas\u00ebs \u00e7el\u00ebsi-vler\u00eb. Kodi libmdbx shp\u00ebrndahet n\u00ebn licenc\u00ebn OpenLDAP Public License. Libmdbx \u00ebsht\u00eb nj\u00eb ripunim i thell\u00eb i SGBD-s\u00eb LMDB dhe sipas zhvilluesve, tejkalon parardh\u00ebsin e saj n\u00eb shkall\u00ebzueshm\u00ebri, funksionalitete dhe performanc\u00eb. Raportohet se libmdbx \u00ebsht\u00eb deri n\u00eb 20% m\u00eb i shpejt\u00eb se LMDB n\u00eb skenar\u00ebt CRUD dhe deri n\u00eb 30% m\u00eb i shpejt\u00eb, n\u00ebse gjat\u00eb nd\u00ebrtimit t\u00eb libmdbx \u00ebsht\u00eb \u00e7aktivizuar kontrolli i brendsh\u00ebm n\u00eb nj\u00eb nivel t\u00eb krahasuesh\u00ebm me at\u00eb t\u00eb LMDB. <\/p>\n
Libmdbx ofron ACID, serializim t\u00eb ngurt\u00eb t\u00eb ndryshimeve dhe lexim jo-bllokues me shkall\u00ebzim linear p\u00ebr b\u00ebrthamat e CPU. N\u00eb libmdbx, v\u00ebmendje e madhe i kushtohet cil\u00ebsis\u00eb s\u00eb kodit, stabilitetit t\u00eb API-s\u00eb, testimit dhe verifikimeve automatike. P\u00ebrkrah automatikun e kompresionit, menaxhimin automatik t\u00eb madh\u00ebsis\u00eb s\u00eb BAZE, nj\u00eb format t\u00eb vet\u00ebm BAZE p\u00ebr nd\u00ebrtimet 32-bit dhe 64-bit, vler\u00ebsimin e v\u00ebllimeve t\u00eb mostrave sipas intervaleve (range query estimation). Ofron nj\u00eb mjet p\u00ebr kontrollin e integritetit t\u00eb struktur\u00ebs s\u00eb BAZE me disa mund\u00ebsi rikuperimi. Q\u00eb nga viti 2016, projekti financohet nga kompania Positive Technologies dhe q\u00eb nga viti 2017 p\u00ebrdoret n\u00eb produktet e saj, nd\u00ebrsa sanksionet e nd\u00ebrmarra nga qeveria e Shteteve t\u00eb Bashkuara ndaj Positive Technologies nuk kan\u00eb ndonj\u00eb ndikim t\u00eb duksh\u00ebm. <\/p>\n
Risi, p\u00ebrmir\u00ebsime dhe korrigjime t\u00eb r\u00ebnd\u00ebsishme, t\u00eb shtuar pas l\u00ebshimit t\u00eb kaluar: <\/p>\n
\n
Disponohet lidhja p\u00ebr Ruby nga Mahlon E. Smith dhe nj\u00eb version provues i lidhjeve p\u00ebr Python nga Noel Kuntze, jan\u00eb p\u00ebrdit\u00ebsuar lidhjet p\u00ebr GoLang nga Alexey Sharov.\n
P\u00ebr modin \u00abMDBX_WRITEMAP\u00bb, kur t\u00eb dh\u00ebnat e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave modifikohen drejtp\u00ebrdrejt n\u00eb RAM, \u00ebsht\u00eb realizuar nj\u00eb \u00abderdhje transparente\u00bb n\u00eb disk t\u00eb faqeve t\u00eb modifikuara t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave. Tani, pas p\u00ebrfundimit t\u00eb \u00e7do operacioni, k\u00ebto faqe menj\u00ebher\u00eb jan\u00eb plot\u00ebsisht t\u00eb gatshme p\u00ebr t'u shkruar n\u00eb disk dhe b\u00ebrthama e OS-s\u00eb mund t\u00eb zbres\u00eb vet\u00eb faqet e modifikuara n\u00eb disk, nd\u00ebrsa fiksoja e transaksionit nuk do t\u00eb k\u00ebrkoj\u00eb modifikimin e tyre. Si rezultat, n\u00eb skenar\u00ebt e ngarkuar me munges\u00eb RAM-i, volumi i operacioneve t\u00eb diskut mund t\u00eb reduktohet deri n\u00eb 2 her\u00eb.\n
\u00cbsht\u00eb realizuar d\u00ebbimi i kopjeve t\u00eb err\u00ebta t\u00eb faqeve t\u00eb modifikuara q\u00eb nuk jan\u00eb p\u00ebrdorur prej koh\u00ebsh, duke preferuar d\u00ebbimin e faqeve me vlera t\u00eb m\u00ebdha\/ t\u00eb gjata, t\u00eb cilat n\u00eb shumic\u00ebn e skenar\u00ebve modifikohen vet\u00ebm nj\u00eb her\u00eb p\u00ebr transaksion. Si rezultat, zvog\u00eblohet volumi i shk\u00ebmbimit me disqet dhe rritet performanca n\u00eb skenar\u00ebt me transaksione shum\u00eb t\u00eb m\u00ebdha.\n
\u00cbsht\u00eb realizuar nj\u00eb mod i \u00abmen\u00e7ur\u00bb p\u00ebr ndarjen e faqeve gjat\u00eb shtimit t\u00eb \u00e7el\u00ebsave. Tani, gjat\u00eb shtimit t\u00eb sekuencave t\u00eb renditura, garanton automatikisht plot\u00ebsimin e plot\u00eb t\u00eb faqeve, dhe n\u00eb rastet e tjera, nj\u00eb balancim m\u00eb optimal t\u00eb pem\u00ebs. Si rezultat, n\u00eb mesatare, faqet e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave plot\u00ebsohen m\u00eb optimalisht, dhe B-pema rezulton t\u00eb jet\u00eb m\u00eb e balancuar, gj\u00eb q\u00eb ndikon pozitivisht n\u00eb performanc\u00ebn.\n
Statistikat e operacioneve me faqe jan\u00eb shtuar, duke mund\u00ebsuar vler\u00ebsimin e sakt\u00eb t\u00eb kostos s\u00eb operacioneve modifikuese me DB.\n
\u00cbsht\u00eb eliminuar m\u00eb shum\u00eb se nj\u00ebzet n\u00ebnt\u00ebsh p\u00ebr t\u00eb gjetur dhe p\u00ebr t\u00eb p\u00ebrmir\u00ebsuar, duke p\u00ebrfshir\u00eb: jan\u00eb zgjidhur problemet me nd\u00ebrtimin p\u00ebrmes MinGW, p\u00ebrdorimi i `std::filesystem::path` n\u00eb iOS <= 13.0, nd\u00ebrtimi me objektiv n\u00eb versione m\u00eb t\u00eb vjetra t\u00eb Windows, etj.\n
N\u00eb p\u00ebrmbledhje, jan\u00eb b\u00ebr\u00eb m\u00eb shum\u00eb se 200 ndryshime n\u00eb 66 skedar\u00eb, jan\u00eb shtuar rreth 6500 rreshta, jan\u00eb fshir\u00eb rreth 4500. <\/ul>\n
Ve\u00e7an\u00ebrisht dua t\u00eb theksoj zgjedhjen e projektit Turbo-Geth (turbo-fork i Go-Ethereum) libmdbx si backend t\u00eb ri p\u00ebr ruajtjen, si dhe t\u00eb fal\u00ebnderoj ekipin e projektit (ve\u00e7an\u00ebrisht Aleksej Sharov, Artem Vorotnikov dhe Aleksej Akhunov) p\u00ebr ndihm\u00ebn e madhe n\u00eb testimin n\u00eb skenar\u00eb ekstreme t\u00eb p\u00ebrdorimit. N\u00eb ve\u00e7anti, n\u00eb k\u00ebt\u00eb m\u00ebnyr\u00eb \u00ebsht\u00eb zbuluar dhe eliminuar nj\u00eb defekt n\u00eb menaxhimin e leximit t\u00eb parashikuesh\u00ebm\/keshimit, i cili shkaktonte degradimin e performanc\u00ebs n\u00eb skenar\u00ebt e v\u00ebshtir\u00eb p\u00ebr t'u riprodhuar me DB t\u00eb m\u00ebdha. \n Burimi: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"