{"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\/novosti-interneta\/dostupna-subd-mysql-9-0-0","title":{"rendered":"Baza e t\u00eb dh\u00ebnave MySQL 9.0.0 \u00ebsht\u00eb e disponueshme","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
Kompania Oracle ka formuar nj\u00eb deg\u00eb t\u00eb re t\u00eb SGBD MySQL 9.0. Nd\u00ebrtimet e MySQL Community Server 9.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 lan\u00e7imit t\u00eb ndihmuar vitin e kaluar, MySQL 9.0 i p\u00ebrket deg\u00ebve \u00abInovacion\u00bb, n\u00eb t\u00eb cilat do t\u00eb p\u00ebrfshihen edhe versionet e tjera t\u00eb r\u00ebnd\u00ebsishme MySQL 9.1 dhe 9.2. Deg\u00ebt e Inovacionit rekomandohen p\u00ebr ata q\u00eb duan t\u00eb ken\u00eb qasje m\u00eb her\u00ebt n\u00eb funksionalitete t\u00eb reja, publikohen \u00e7do 3 muaj dhe mb\u00ebshteten vet\u00ebm deri n\u00eb publikimin e versionit tjet\u00ebr t\u00eb r\u00ebnd\u00ebsish\u00ebm (p\u00ebr sh\u00ebmbull, pas shfaqjes s\u00eb deg\u00ebs 9.1 do t\u00eb pezullohet mb\u00ebshtetja p\u00ebr deg\u00ebn 9.0). Rreth nj\u00eb vit m\u00eb von\u00eb \u00ebsht\u00eb planifikuar t\u00eb formohet nj\u00eb version LTS, i cili do t\u00eb rekomandohet p\u00ebr implementime q\u00eb kan\u00eb nevoj\u00eb p\u00ebr parashikueshm\u00ebri dhe ruajtje t\u00eb q\u00ebndrueshm\u00ebris\u00eb s\u00eb sjelljes. Pas deg\u00ebs LTS do t\u00eb formohet nj\u00eb deg\u00eb e re Inovacioni \u2014 MySQL 10.0.<\/p>\n
Ndryshimet kryesore n\u00eb MySQL 9.0:<\/p>\n
\n
N\u00eb ekzekutimin e konstrukcionit \u00abEXPLAIN ANALYZE INTO\u00bb \u00ebsht\u00eb shtuar mund\u00ebsia e ruajtjes s\u00eb t\u00eb dh\u00ebnave n\u00eb formatin JSON n\u00eb nj\u00eb variab\u00ebl p\u00ebrdoruesi, e cila mund t\u00eb p\u00ebrdoret m\u00eb pas si argument n\u00eb funksionet p\u00ebr pun\u00eb me JSON.\n
EXPLAIN ANALYZE FORMAT=JSON INTO @variable select_stmt<\/p>\n
Lejohet form\u00ebsimi i shprehjeve \u00abCREATE EVENT\u00bb, \u00abALTER EVENT\u00bb dhe \u00abDROP EVENT\u00bb si k\u00ebrkesa parametrizuese brenda procedurave t\u00eb ruajtura. Krijimi i nj\u00eb k\u00ebrkese parametrizuese realizohet duke p\u00ebrdorur shprehjen PREPARE, nd\u00ebrsa ekzekutimi \u2014 shprehjen EXECUTE.\n
CREATE PROCEDURE sp(n INT) \n FILLIM \n SET @s1 = \u00abCREATE EVENT e ON SCHEDULE EVERY \u00ab; \n SET @s2 = \u00bb 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))\u00bb;<\/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 sistemike, q\u00eb p\u00ebrmbajn\u00eb informacion p\u00ebr variablat sistemor\u00eb: variables_metadata \u2014 p\u00ebrmban informacion p\u00ebr emrat, fushat e aplikimit, tipet dhe gamat e vlerave t\u00eb t\u00eb gjith\u00eb variablave sistemor\u00eb t\u00eb mb\u00ebshtetur nga MySQL-serveri; global_variable_attributes \u2014 p\u00ebrmban vlerat e caracter\u00edstica t\u00eb caktuara p\u00ebr variablat global\u00eb, si offline_mode dhe read_only.\n
\u00cbsht\u00eb hequr plagini server mysql_native_password, i cili siguron autentikimin me fjal\u00ebkalime, i cili ishte shpallur m\u00eb par\u00eb si t\u00ebrhequr. N\u00eb vend t\u00eb mysql_native_password, rekomandohet kalimi n\u00eb p\u00ebrdorimin e plugin-it caching_sha2_password, i cili p\u00ebrdor algoritmin SHA2 p\u00ebr hashing n\u00eb vend t\u00eb SHA1.\n
Jan\u00eb shtuar 15 variabla p\u00ebr konfigurimin dhe inspektimin e motorit MLE (Komponenti i Motorit Multilingv), 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