{"id":116891,"date":"2024-07-02T12:05:43","date_gmt":"2024-07-02T10:05:43","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/dostupna-subd-mysql-9-0-0"},"modified":"2024-07-02T12:05:43","modified_gmt":"2024-07-02T10:05:43","slug":"dostupna-subd-mysql-9-0-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/news\/dostupna-subd-mysql-9-0-0","title":{"rendered":"Rikthehet SGBD MySQL 9.0.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
Kompania Oracle krijoi nj\u00eb deg\u00eb t\u00eb re t\u00eb SGBD MySQL 9.0.0. Nd\u00ebrtime MySQL Community Server 9.0.0 jan\u00eb p\u00ebrgatitur p\u00ebr t\u00eb gjitha distribucione kryesore t\u00eb Linux, FreeBSD, macOS dhe Windows. N\u00eb kuad\u00ebr t\u00eb modelit t\u00eb implementuar vitin e kaluar p\u00ebr formimin e l\u00ebshimeve, MySQL 9.0 \u00ebsht\u00eb klasifikuar n\u00eb deg\u00ebt 'Innovation', n\u00eb t\u00eb cilat do t\u00eb p\u00ebrfshihen gjithashtu l\u00ebshimet e r\u00ebnd\u00ebsishme MySQL 9.1 dhe 9.2. Deg\u00ebt Innovation rekomandohen p\u00ebr ata q\u00eb duan t\u00eb ken\u00eb akses m\u00eb her\u00ebt n\u00eb funksionalitete t\u00eb reja, publikohen \u00e7do 3 muaj dhe mb\u00ebshteten vet\u00ebm deri n\u00eb publikimin e l\u00ebshimit tjet\u00ebr t\u00eb r\u00ebnd\u00ebsish\u00ebm (p\u00ebr shembull, pas daljes s\u00eb deg\u00ebs 9.1 do t\u00eb ndaloj\u00eb mb\u00ebshtetja p\u00ebr deg\u00ebn 9.0). Rreth nj\u00eb vit pasi parashikohet t\u00eb formohet l\u00ebshimi LTS, i cili do t\u00eb rekomandohet p\u00ebr implementime q\u00eb k\u00ebrkojn\u00eb parashikueshm\u00ebri dhe ruajtje t\u00eb q\u00ebndrueshm\u00ebris\u00eb p\u00ebr nj\u00eb periudh\u00eb t\u00eb gjat\u00eb. Pas deg\u00ebs LTS do t\u00eb formohet nj\u00eb deg\u00eb e re Innovation - MySQL 10.0.<\/p>\n
Ndryshimet kryesore n\u00eb MySQL 9.0:<\/p>\n
\n
Me ekzekutimin e konstruksionit 'EXPLAIN ANALYZE INTO' \u00ebsht\u00eb shtuar mund\u00ebsia e ruajtjes s\u00eb daljes n\u00eb formatin JSON n\u00eb nj\u00eb variab\u00ebl p\u00ebrdoruesi, e cila mund t\u00eb p\u00ebrdoret si argument n\u00eb funksionet p\u00ebr pun\u00ebn me JSON.\n
EXPLAIN ANALYZE FORMAT=JSON INTO @variable select_stmt<\/p>\n
\u00cbsht\u00eb e lejuar t\u00eb formohen shprehjet 'CREATE EVENT', 'ALTER EVENT' dhe 'DROP EVENT' si k\u00ebrkesa parametrike brenda procedurave t\u00eb ruajtura. Krijimi i k\u00ebrkesave parametrike b\u00ebhet duke p\u00ebrdorur shprehjen PREPARE, nd\u00ebrsa ekzekutimi - shprehjen EXECUTE.\n
CREATE PROCEDURE sp(n INT) \n FILLON \n SET @s1 = 'CREATE EVENT e ON SCHEDULE EVERY '; \n SET @s2 = ' SECOND \n STARTS CURRENT_TIMESTAMP + INTERVAL 10 SECOND \n ENDS CURRENT_TIMESTAMP + INTERVAL 2 MINUTE \n ON COMPLETION PRESERVE \n DO \n INSERT INTO d.t VALUES ROW(NULL, NOW(), FLOOR(RAND()*100));<\/p>\n
SET @s = CONCAT(@s1, n, @s2); \n PREPARE ps FROM @s; \n EXECUTE ps; \n DEALLOCATE PREPARE ps; \n END<\/p>\n
Jan\u00eb shtuar dy tabela t\u00eb reja sistemore, q\u00eb p\u00ebrmbajn\u00eb informacion rreth variablave sistemor\u00eb: variables_metadata - p\u00ebrmban informacion mbi emrat, fushat e veprimit, tipet dhe diapazonet e vlerave t\u00eb t\u00eb gjith\u00eb variablave sistemor\u00eb t\u00eb mb\u00ebshtetur nga MySQL server; global_variable_attributes - p\u00ebrmban vlerat e atributeve t\u00eb caktuara p\u00ebr variablat global\u00eb, si offline_mode dhe read_only.\n
\u00cbsht\u00eb hequr plugini serverit t\u00eb shpallur m\u00eb her\u00ebt t\u00eb vjet\u00ebruar mysql_native_password, i cili siguron autentifikimin p\u00ebrmes fjal\u00ebkalimeve. N\u00eb vend t\u00eb mysql_native_password rekomandohet p\u00ebrdorimi i plugin-it caching_sha2_password, q\u00eb p\u00ebrdor algoritmin SHA2 p\u00ebr hashim n\u00eb vend t\u00eb SHA1.\n
U shtua 15 variabla p\u00ebr konfigurimin dhe inspektimin e motorit MLE (Komponenti Multilingual Engine), i cili lejon p\u00ebrdorimin e kodit n\u00eb gjuh\u00eb t\u00eb ndryshme nga SQL n\u00eb procedurat e ruajtura dhe funksionet.\n<\/ul>\n