{"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\/sk\/blog\/news\/dostupna-subd-mysql-9-0-0","title":{"rendered":"K dispoz\u00edcii je DBMS MySQL 9.0.0.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
Spolo\u010dnos\u0165 Oracle vytvorila nov\u00fa vetvu datab\u00e1zov\u00e9ho syst\u00e9mu MySQL 9.0.0. Verzie MySQL Community Server 9.0.0 s\u00fa pripraven\u00e9 pre v\u0161etky hlavn\u00e9 distrib\u00facie Linuxu, FreeBSD, macOS a Windows. V r\u00e1mci modelu vyd\u00e1vania, ktor\u00fd bol zaveden\u00fd minul\u00fd rok, bola verzia MySQL 9.0 zaraden\u00e1 do vetiev 'Innovation', do ktor\u00fdch bud\u00fa tie\u017e zaraden\u00e9 nasleduj\u00face v\u00fdznamn\u00e9 verzie MySQL 9.1 a 9.2. Vetvy Innovation s\u00fa odpor\u00fa\u010dan\u00e9 pre t\u00fdch, ktor\u00ed chc\u00fa sk\u00f4r z\u00edska\u0165 pr\u00edstup k novej funkcionalite, publikuj\u00fa sa ka\u017ed\u00e9 3 mesiace a s\u00fa podporovan\u00e9 iba do publik\u00e1cie nasleduj\u00facej v\u00fdznamnej verzie (napr\u00edklad po vydan\u00ed vetvy 9.1 bude podpora vetvy 9.0 ukon\u010den\u00e1). Pribli\u017ene za rok pl\u00e1nuj\u00fa vytvori\u0165 LTS vydanie, ktor\u00e9 bude odpor\u00fa\u010dan\u00e9 pre nasadenia, ktor\u00e9 potrebuj\u00fa predv\u00eddate\u013enos\u0165 a dlhodob\u00e9 zachovanie stabiln\u00e9ho spr\u00e1vania. Po vetve LTS bude vytvoren\u00e1 nov\u00e1 vetva Innovation \u2014 MySQL 10.0.<\/p>\n
Hlavn\u00e9 zmeny v MySQL 9.0:<\/p>\n
\n
Pri vykonan\u00ed kon\u0161trukcie 'EXPLAIN ANALYZE INTO' bola pridan\u00e1 mo\u017enos\u0165 ulo\u017eenia v\u00fdstupu vo form\u00e1te JSON do u\u017e\u00edvate\u013eskej premennej, ktor\u00e1 m\u00f4\u017ee by\u0165 n\u00e1sledne pou\u017eit\u00e1 ako argument v funkci\u00e1ch pre pr\u00e1cu s JSON.\n
EXPLAIN ANALYZE FORMAT=JSON INTO @variable select_stmt<\/p>\n
Umo\u017enilo sa formulovanie v\u00fdrazov 'CREATE EVENT', 'ALTER EVENT' a 'DROP EVENT' vo forme parametrizovan\u00fdch dotazov v r\u00e1mci ulo\u017een\u00fdch proced\u00far. Vytvorenie parametrizovan\u00e9ho dotazu sa uskuto\u010d\u0148uje pomocou v\u00fdrazu PREPARE, a vykonanie \u2014 pomocou v\u00fdrazu EXECUTE.\n
CREATE PROCEDURE sp(n INT) \n BEGIN \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
Boli pridan\u00e9 dve nov\u00e9 syst\u00e9mov\u00e9 tabu\u013eky, obsahuj\u00face inform\u00e1cie o syst\u00e9mov\u00fdch premenn\u00fdch: variables_metadata \u2014 obsahuje inform\u00e1cie o n\u00e1zvoch, rozsahu p\u00f4sobnosti, typoch a intervaloch hodn\u00f4t v\u0161etk\u00fdch podporovan\u00fdch syst\u00e9mov\u00fdch premenn\u00fdch datab\u00e1zov\u00fdm serverom MySQL; global_variable_attributes \u2014 obsahuje hodnoty atrib\u00fatov stanoven\u00fdch pre glob\u00e1lne premenn\u00e9, ako s\u00fa offline_mode a read_only.\n
Bol odstr\u00e1nen\u00fd predt\u00fdm vyhl\u00e1sen\u00fd zastaran\u00fd serverov\u00fd plugin mysql_native_password, ktor\u00fd zabezpe\u010duje autentifik\u00e1ciu pomocou hesiel. Namiesto mysql_native_password sa odpor\u00fa\u010da prejs\u0165 na pou\u017e\u00edvanie pluginu caching_sha2_password, ktor\u00fd na ha\u0161ovanie pou\u017e\u00edva algoritmus SHA2 namiesto SHA1.\n
Pridan\u00fdch 15 premenn\u00fdch na nastavenie a kontrolu MLE (Componenta viacjazy\u010dn\u00e9ho enginu), ktor\u00e1 umo\u017e\u0148uje pou\u017e\u00edva\u0165 v ulo\u017een\u00fdch proced\u00farach a funkci\u00e1ch k\u00f3d v jazykoch odli\u0161n\u00fdch od SQL.\n<\/ul>\n