{"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\/lv\/blog\/news\/dostupna-subd-mysql-9-0-0","title":{"rendered":"Pieejama datub\u0101ze MySQL 9.0.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
Oracle uz\u0146\u0113mums ir izveidojis jaunu MySQL 9.0.0 datu b\u0101zes noda\u013cu. MySQL Community Server 9.0.0 b\u016bv\u0113jumi ir sagatavoti vis\u0101m galvenaj\u0101m Linux, FreeBSD, macOS un Windows distrib\u016bcij\u0101m. Saska\u0146\u0101 ar pag\u0101ju\u0161aj\u0101 gad\u0101 ieviesto laidiena izveides modeli, MySQL 9.0 ir klasific\u0113ts k\u0101 «Innovation» noda\u013ca, kurai tiks pievienoti ar\u012b n\u0101kamie noz\u012bm\u012bgie MySQL 9.1 un 9.2 laidieni. Innovation noda\u013cas ir ieteicamas tiem, kas v\u0113las agr\u0101k piek\u013c\u016bt jaun\u0101m funkcionalit\u0101t\u0113m, t\u0101s public\u0113 reizi trijos m\u0113ne\u0161os un tiek atbalst\u012btas tikai l\u012bdz n\u0101kam\u0101 noz\u012bm\u012bg\u0101 laidiena public\u0113\u0161anai (piem\u0113ram, p\u0113c noda\u013cas 9.1 par\u0101d\u012b\u0161an\u0101s atbalsts noda\u013cai 9.0 tiks p\u0101rtraukts). Aptuveni p\u0113c gada pl\u0101nots izveidot LTS laidienu, kur\u0161 tiks ieteikts ievie\u0161anai, kurai nepiecie\u0161ama prognoz\u0113jam\u012bba un ilgas nemain\u012bgas darb\u012bbas saglab\u0101\u0161ana. P\u0113c LTS noda\u013cas tiks izveidota jauna Innovation noda\u013ca \u2014 MySQL 10.0.<\/p>\n
Galvenie jaunin\u0101jumi MySQL 9.0:<\/p>\n
\n
Izpildot konstrukciju «EXPLAIN ANALYZE INTO», ir pievienota iesp\u0113ja saglab\u0101t izejas datus JSON form\u0101t\u0101 lietot\u0101ja main\u012bgaj\u0101, kuru p\u0113c tam var izmantot k\u0101 argumentu funkcij\u0101m darbam ar JSON.\n
EXPLAIN ANALYZE FORMAT=JSON INTO @variable select_stmt<\/p>\n
At\u013cauts noform\u0113t izteiksmes «CREATE EVENT», «ALTER EVENT» un «DROP EVENT» k\u0101 parametriz\u0113tus piepras\u012bjumus iek\u0161\u0113jos glab\u0101\u0161anas proced\u016br\u0101s. Parametriz\u0113ta piepras\u012bjuma izveide tiek veikta, izmantojot izteiksmi PREPARE, bet izpilde \u2014 izteiksmi EXECUTE.\n
CREATE PROCEDURE sp(n INT) \n S\u0100KT \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 BEIGAS<\/p>\n
Pievienotas divas jaunas sist\u0113mas tabulas, kas satur inform\u0101ciju par sist\u0113mas main\u012bgajiem: variables_metadata \u2014 satur inform\u0101ciju par visu atbalst\u012bto MySQL servera sist\u0113mas main\u012bgo nosaukumiem, darb\u012bbas jomu, tipiem un v\u0113rt\u012bbu diapazoniem; global_variable_attributes \u2014 satur atrib\u016btu v\u0113rt\u012bbas, kas nor\u0101d\u012btas glob\u0101lajiem main\u012bgajiem, piem\u0113ram, offline_mode un read_only.\n
Tika iz\u0146emts iepriek\u0161 atz\u012btais novecojis servera spraudnis mysql_native_password, kas nodro\u0161ina autentifik\u0101ciju ar parol\u0113m. Viet\u0101 mysql_native_password ieteicams izmantot spraudni caching_sha2_password, kas izmanto SHA2 algoritmu h\u0113\u0161o\u0161anai t\u0101 viet\u0101, lai izmantotu SHA1.\n
Pievienoti 15 main\u012bgie MLE (Multilingual Engine Component) dzin\u0113ja piel\u0101go\u0161anai un p\u0101rbaudei, \u013caujot izmantot proced\u016br\u0101s un funkcij\u0101s kodu valod\u0101s, kas at\u0161\u0137iras no SQL.\n<\/ul>\n