ProHoster > ื‘ืœืึธื’ > ืื™ื ื˜ืขืจื ืขื˜ ื ื™ื™ึทืขืก > ืžืขืœื“ื•ื ื’ ืคื•ืŸ MySQL DBMS 9.6.0

ืžืขืœื“ื•ื ื’ ืคื•ืŸ MySQL DBMS 9.6.0

ืึธืจืึทืงืœ ื”ืึธื˜ ืึทืจื•ื™ืกื’ืขื’ืขื‘ืŸ ืึท ื ื™ื™ืข ืฆื•ื•ื™ื™ึทื’ ืคึฟื•ืŸ ื“ืขืจ MySQL 9.6.0 ื“ืึทื˜ืึทื‘ื™ื™ืก ืคืึทืจื•ื•ืึทืœื˜ื•ื ื’ ืกื™ืกื˜ืขื. MySQL ืงืึทืžื™ื•ื ื™ื˜ื™ ืกืขืจื•ื•ืขืจ 9.6.0 ื‘ื™ืœื“ืก ื–ืขื ืขืŸ ืคึฟืึทืจืึทืŸ ืคึฟืึทืจ ืึทืœืข ื”ื•ื™ืคึผื˜ ื“ื™ืกื˜ืจื™ื‘ื™ื•ืฉืึทื ื–. Linux, ืคืจื™ื™ ื‘ื™ ืขืก ื“ื™, macOS ะธ Windowsืœื•ื™ื˜ืŸ ืืจื•ื™ืกื’ืขื‘ื•ื ื’ ืžืึธื“ืขืœ ื•ื•ืึธืก ืื™ื– ืื™ื™ื ื’ืขืคื™ืจื˜ ื’ืขื•ื•ืึธืจืŸ ืื™ืŸ 2023, ื•ื•ืขืจื˜ MySQL 9.6 ืฆื•ื’ืขื˜ื™ื™ืœื˜ ืฆื•ื "ืื™ื ืึธื•ื•ืึทืฆื™ืข" ืฆื•ื•ื™ื™ื’. ืื™ื ืึธื•ื•ืึทืฆื™ืข ืฆื•ื•ื™ื™ื’ืŸ ื•ื•ืขืจืŸ ืจืขืงืึธืžืขื ื“ื™ืจื˜ ืคึฟืึทืจ ื™ืขื ืข ื•ื•ืึธืก ื•ื•ื™ืœืŸ ืคืจื™ืขืŸ ืฆื•ื˜ืจื™ื˜ ืฆื• ื ื™ื™ืขืจ ืคื•ื ืงืฆื™ืึธื ืึทืœื™ื˜ืขื˜. ื–ื™ื™ ื•ื•ืขืจืŸ ืืจื•ื™ืกื’ืขื’ืขื‘ืŸ ื™ืขื“ืข ื“ืจื™ื™ ื—ื“ืฉื™ื ืื•ืŸ ื•ื•ืขืจืŸ ื’ืขืฉื˜ื™ืฆื˜ ื‘ืœื•ื™ื– ื‘ื™ื– ื“ืขืจ ื•ื•ื™ื™ึทื˜ืขืจืขืจ ื”ื•ื™ืคึผื˜ ืืจื•ื™ืกื’ืขื‘ื•ื ื’ (ืœืžืฉืœ, ื ืึธืš ื“ืขืจ ืืจื•ื™ืกื’ืขื‘ื•ื ื’ ืคื•ืŸ ืฆื•ื•ื™ื™ื’ 9.6, ืื™ื– ืฉื˜ื™ืฆืข ืคึฟืึทืจ ืฆื•ื•ื™ื™ื’ 9.5 ืึธืคึผื’ืขืฉื˜ืขืœื˜ ื’ืขื•ื•ืึธืจืŸ). ืฉืคึผืขื˜ืขืจ ืคึผืœืึทื ื™ืจืŸ ื–ื™ื™ ืฆื• ืืจื•ื™ืกื’ืขื‘ืŸ LTS ืืจื•ื™ืกื’ืขื‘ื•ื ื’ 9.7, ืจืขืงืึธืžืขื ื“ื™ืจื˜ ืคึฟืึทืจ ื“ื™ืคึผืœื•ื™ืžืึทื ืฅ ื•ื•ืึธืก ื“ืึทืจืคืŸ ืคืึธืจื•ื™ืกื–ืึธื’ื‘ืืจืงื™ื™ื˜ ืื•ืŸ ืœืึทื ื’-ื˜ืขืจืžื™ืŸ ืคืขืกื˜ืงื™ื™ื˜. ื ืึธืš ื“ืขื LTS ืืจื•ื™ืกื’ืขื‘ื•ื ื’, ื•ื•ืขื˜ ืึท ื ื™ื™ืขืจ ืื™ื ืึธื•ื•ืึทืฆื™ืข ืฆื•ื•ื™ื™ื’ ื‘ืืฉืืคืŸ ื•ื•ืขืจืŸ: MySQL 10.0.

ื“ื™ ืœื™ืกื˜ืข ืคื•ืŸ โ€‹โ€‹ื‘ืึทืžืขืจืงื‘ืึทืจืข ืขื ื“ืขืจื•ื ื’ืขืŸ ืื™ืŸ MySQL 9.6 ืื™ื– ืื™ื“ืขื ื˜ื™ืฉ ืฆื•ื MySQL 9.5 ืขื ื“ืขืจื•ื ื’ ืœืึธื’. ืขืก ื ืขืžื˜ ืื•ื™ืš ืืจื™ื™ืŸ ื“ื™ ืคืจื™ืขืจ ื‘ืึทืžืขืจืงื˜ืข ื ืึทื˜ื•ืจ ืขื ื“ืขืจื•ื ื’ ืคึฟืึทืจ ื“ืขื "innodb_log_writer_threads" ืคึผืึทืจืึทืžืขื˜ืขืจ, ืึท ืขื ื“ืขืจื•ื ื’ ืฆื• ื“ืขื ืคืขืœื™ืงื™ื™ึทื˜ ื•ื•ืขืจื˜ ืคึฟืึทืจ ื“ืขื "binlog_transaction_dependency_history_size" ืคึผืึทืจืึทืžืขื˜ืขืจ, ื“ื™ ื“ืขืคึผืจืขืงืึทืฆื™ืข ืคื•ืŸ โ€‹โ€‹โ€‹โ€‹ื“ื™ SCRAM-SHA-1 ืึธื˜ืขื ื˜ืึทืงื™ื™ืฉืึทืŸ ืžืขื˜ืึธื“, ืื•ืŸ ื“ื™ ื‘ืึทื–ื™ื™ึทื˜ื™ืงื•ื ื’ ืคื•ืŸ ืฉื˜ื™ืฆืข ืคึฟืึทืจ ื“ื™ "group_replication_allow_local_lower_version_join" ืื•ืŸ "replica_parallel_type" ื•ื•ืขืจื™ืึทื‘ืึทืœืŸ. ื“ื™ ืึทืœื’ืขืžื™ื™ื ืข ืœื™ืกื˜ืข ืคื•ืŸ โ€‹โ€‹โ€‹โ€‹ืคื™ืงืกื™ื– ืื™ื– ืึทื ื“ืขืจืฉ ืื•ืŸ ื›ึผื•ืœืœ ื“ื™ ืคืืœื’ืขื ื“ืข ื‘ืึทืžืขืจืงื‘ืึทืจืข ืขื ื“ืขืจื•ื ื’ืขืŸ:

  • ื“ื™ ืื•ื™ื“ื™ื˜ ืกื™ืกื˜ืขื ืื™ื– ืื™ื‘ืขืจื’ืขืžืื›ื˜ ื’ืขื•ื•ืืจืŸ, ืื™ืžืคืœืขืžืขื ื˜ื™ืจื ื“ื™ื’ ื ืžืื“ื•ืœืืจืข ืื•ื™ื“ื™ื˜ ืœืื’ ืกื•ื‘ืกื™ืกื˜ืขื. ื“ืืก ืขืจืžืขื’ืœื™ื›ื˜ ื‘ืื–ื•ื ื“ืขืจืข ืื™ื ืกื˜ืืœืืฆื™ืข ืื•ืŸ ืคืืจื•ื•ืืœื˜ื•ื ื’ ืคื•ืŸ ืคืืจืฉื™ื“ืขื ืข ืื•ื™ื“ื™ื˜ ืœืื’ื™ื ื’ ืงืืžืคืื ืขื ื˜ืŸ, ื•ื•ื™ ืื•ื™ืš ืคืืจืคึผืฉื•ื˜ืขืจืŸ ืงืื ืคื™ื’ื•ืจืืฆื™ืข ืคื•ืŸ โ€‹โ€‹ืœืื’ ืคืืจืžืื˜ืŸ, ืื•ื™ื“ื™ื˜ ื˜ืขืงืข ืœืืงืืฆื™ืขืก, ืื•ืŸ ื‘ืืคืขืจื™ื ื’ ืคืืจืืžืขื˜ืขืจืก. ืขื ื“ืขืจืŸ ื“ื™ audit_log_rotate_on_size ืกื™ืกื˜ืขื ื•ื•ืขืจื™ืื‘ืœ ืคืืจืœืื ื’ื˜ ื™ืขืฆื˜ AUDIT_ADMIN ืคืจื™ื•ื•ื™ืœืขื’ื™ืขืก.
  • ื ื ื™ื™ืข ื“ืื˜ืŸ ืกื˜ืจื•ืงื˜ื•ืจ ืื•ืŸ ื ื ื™ื™ืข ืื™ื™ื ื’ืขื‘ื•ื™ื˜ืข ื‘ื™ื‘ืœื™ืื˜ืขืง ืคื•ืŸ ืคื•ื ืงืฆื™ืขืก ืคืืจืŸ ืืจื‘ืขื˜ืŸ ืžื™ื˜ ืกืขื˜ืก ืคื•ืŸ ื’ืœืื‘ืืœืข ื˜ืจืื ื–ืืงืฆื™ืข ืื™ื“ืขื ื˜ื™ืคื™ืฆื™ืจืขืจืก (GTIDs) ื’ืขื ื•ืฆื˜ ืื™ืŸ ืจืขืคืœื™ืงืืฆื™ืข ื•ื•ืขืจืŸ ื’ืขื ื•ืฆื˜. ื“ื™ ื ื™ื™ืข ืื™ืžืคืœืขืžืขื ื˜ืืฆื™ืข ืื™ื– ืžืขืจ ื”ื•ื™ืš ืคืึธืจืฉื˜ืขืœื•ื ื’ ืื•ืŸ ืคืืจืคึผืฉื•ื˜ืขืจื•ื ื’ ืคื•ืŸ ื“ืขื ืงืึธื“.
  • InnoDB ืกื˜ืึธืจื™ื“ื–ืฉ ื”ืื˜ ืคึฟืึทืจื‘ืขืกืขืจื˜ ื“ื™ ืขืคึฟืขืงื˜ื™ื•ื•ืงื™ื™ื˜ ืคึฟื•ืŸ ื“ื–ืฉืขื ืขืจื™ืจืŸ ืื™ื™ื ืฆื™ืงืึทืจื˜ื™ืงืข ืจืึธื•ื™ื“ ืื™ื“ืขื ื˜ื™ืคึฟื™ืงืึทื˜ืึธืจืŸ ืื™ืŸ ื˜ืึทื‘ืขืœืขืก ืึธืŸ ืขืจืฉื˜ื™ืงืข ืฉืœื™ืกืœืขืŸ. ืึท ืคึผืจืึธื‘ืœืขื ืžื™ื˜ ืื•ืžืจืขื›ื˜ืข ืึธืคึผื–ื•ืš ืคึฟื•ืŸ ื˜ืจืึทื ื–ืึทืงืฆื™ืขืก ื•ื•ืึธืก ื”ืึธื‘ืŸ ื’ืขื”ืึทื˜ ื“ืขื "PREPARED" ืกื˜ืึทื˜ื•ืก ืื™ืŸ ื“ืขืจ ืฆื™ื™ื˜ ืคึฟื•ืŸ ืึท ืงืจืึทืš ืื™ื– ื’ืขื•ื•ืึธืจืŸ ื’ืขืœืขื–ื˜.
  • ืฆื•ื’ืขื’ืขื‘ืŸ ืึท ื ื™ื™ืข ืึธืคึผืฆื™ืข "--container_aware" ื•ื•ืึธืก ืขืจืžืขื’ืœื™ื›ื˜ ื“ืขื˜ืขืงืฉืึทืŸ ืคื•ืŸ CPU ืื•ืŸ ื–ื›ึผืจื•ืŸ ืœื™ืžืึทืฅ ื’ืขืฉื˜ืขืœื˜ ืื™ืŸ ื“ืขื ืงืึทื ื˜ื™ื™ื ืขืจ ื‘ืขืฉืึทืก ืกื˜ืึทืจื˜ืึทืคึผ.
  • ืคืืจื‘ืจื™ื™ื˜ืขืจื˜ืข ืžืขื’ืœืขื›ืงื™ื™ื˜ืŸ ืคืืจ ืจืขืคึผืœื™ืงืึทืฆื™ืข ื“ื™ื‘ืึทื’ื™ื ื’.
  • ื“ื™ SQL ืคื•ื ืงืฆื™ืขืก MD5() ืื•ืŸ SHA1() ื–ืขื ืขืŸ ืืคื’ืขื˜ื™ื™ืœื˜ ืื™ืŸ ื ื‘ืื–ื•ื ื“ืขืจืŸ ืงืืžืคืื ืขื ื˜ "classic_hashing", ื•ื•ืืก ืงืขืŸ ื•ื•ืขืจืŸ ืื•ื™ืกื’ืขืœืืฉืŸ ืื•ื™ื‘ ื ื•ื™ื˜ื™ื’ ืฆื• ื‘ืœืืงื™ืจืŸ ื“ื™ ื ื•ืฆืŸ ืคื•ืŸ ื ื™ืฉื˜-ื–ื™ื›ืขืจืข ื”ืขืฉื™ื ื’ ืืœื’ืืจื™ื˜ืžืขืŸ.
  • ืคืขืจืฆืŸ ืฉื•ื•ืื›ืงื™ื™ื˜ืŸ ื–ืขื ืขืŸ ืคืืจืจืื›ื˜ืŸ ื’ืขื•ื•ืืจืŸ, ืฆื•ื•ื™ื™ ืคื•ืŸ ื•ื•ืขืœื›ืข ืงืขื ืขืŸ ืื•ื™ืกื’ืขื ื•ืฆื˜ ื•ื•ืขืจืŸ ืคื•ืŸ ื•ื•ื™ื™ื˜ื ืก. ื“ื™ ืขืจื ืกื˜ืกื˜ืข ืคืจืื‘ืœืขื, ื‘ืื•ืจื˜ื™ื™ืœื˜ ืืœืก ืงืจื™ื˜ื™ืฉืข ืฉื˜ืจืขื ื’ืงื™ื™ื˜ (9.8), ืื™ื– ืคืืจืืŸ ืื™ืŸ ื“ืขื ืืคื™ืฆื™ืขืœืŸ MySQL ื“ืืงืขืจ ื‘ื™ืœื“ ืื•ืŸ ืื™ื– ืคืืจื‘ื•ื ื“ืŸ ืžื™ื˜ ื ืฉื•ื•ืื›ืงื™ื™ื˜ ืื™ืŸ ื“ืขืจ SQLite ื‘ื™ื‘ืœื™ืื˜ืขืง (CVE-2025-6965), ื•ื•ืืก ื•ื•ืขืจื˜ ื’ืขื ื•ืฆื˜ ืื™ืŸ ื”ื™ืœืคืก-ื’ืขืฆื™ื™ื’ ืคืืจ ืงืื ืคื™ื’ื•ืจื™ืจืŸ ืื•ืŸ ืืจื‘ืขื˜ืŸ ืžื™ื˜ MySQL. ื“ื™ ืฆื•ื•ื™ื™ื˜ืข ืฉื•ื•ืื›ืงื™ื™ื˜ ื•ื•ืืก ืžืขืŸ ืงืขืŸ ืื•ื™ืกื ื•ืฆืŸ ืคื•ืŸ ื•ื•ื™ื™ื˜ื ืก, ื‘ืื•ืจื˜ื™ื™ืœื˜ ืืœืก ืฉื˜ืจืขื ื’ืงื™ื™ื˜ ืœืขื•ื•ืขืœ 7.5, ื•ื•ืขืจื˜ ื’ืขืคืืจืฉืืคื˜ ื“ื•ืจืš ื ื‘ืืคืขืจ ืื™ื‘ืขืจืคืœื•ืก (CVE-2025-9230) ืื™ืŸ ื“ืขืจ OpenSSL ื‘ื™ื‘ืœื™ืื˜ืขืง. ื•ื•ื™ื™ื ื™ื’ืขืจ ืขืจื ืกื˜ืข ืฉื•ื•ืื›ืงื™ื™ื˜ืŸ ืืคืขืงื˜ื™ืจืŸ OpenSSL, InnoDB, ื“ืขื ืืคื˜ื™ืžื™ื–ืขืจ, DDL, ื“ืขื ืคืืจืกืขืจ, Pluggable Auth, ืื•ืŸ Thread Pooling. ืคืจื˜ื™ื ื–ืขื ืขืŸ ื ืืš ื ื™ืฉื˜ ืืจื•ื™ืกื’ืขื’ืขื‘ืŸ ื’ืขื•ื•ืืจืŸ.

ืžืงื•ืจ: opennet.ru

ืงื•ื™ืคืŸ ืคืึทืจืœืึธื–ืœืขืš ื”ืึธืกื˜ื™ื ื’ ืคึฟืึทืจ ื–ื™ื™ื˜ืœืขืš ืžื™ื˜ DDoS ืฉื•ืฅ, VPS VDS ืกืขืจื•ื•ืขืจืก ๐Ÿ”ฅ ืงื•ื™ืคื˜ ืคืึทืจืœืขืกืœืขื›ืข ื•ื•ืขื‘ื–ื™ื™ื˜ืœ ื”ืึธืกื˜ื™ื ื’ ืžื™ื˜ DDoS ืฉื•ืฅ, VPS VDS ืกืขืจื•ื•ืขืจืก | ProHoster