MySQL 8.0.35や8.2.0のリリースノートがまだ来ないが、githubのほうではtagが切られていたので、commit messageから新しい機能を探してみた。
$ cd mysql-server/ $ gch trunk Already on 'trunk' Your branch is up to date with 'origin/trunk'. $ gb 8.0 * trunk $ git rev-list -n 1 mysql-8.1.0 ea1efa9822d81044b726aab20c857d5e1b7e046a $ git rev-list -n 1 mysql-8.2.0 87307d4ddd88405117e3f1e51323836d57ab1f57 $ gl ea1efa9822d81044b726aab20c857d5e1b7e046a..87307d4ddd88405117e3f1e51323836d57ab1f57 --pretty=format:"%s" > commit_msg_between_81_and_82.txt
WL#から始まるのが新機能っぽいので、その一覧。 以下、commit_msg_between_81_and_82.txtを"WL#"でgrepした結果
$ cat commit_msg_between_81_and_82.txt | grep WL# WL#13220: Deprecate --character-set-client-handshake server option WL#8609: Deprecate old/new system variables WL#13220: Deprecate --character-set-client-handshake server option WL#15800: Deprecate usage of weak ciphers in server - Added deprecation message for weak ciphers WL#15257: Enhanced performance for set operations WL#15915 Deprecate INFORMATION_SCHEMA.PROCESSLIST Addendum to WL#15874: added the new privs to a test output WL#14717 - InnoDB: Bulk Ingest Feature V1 WL#15811: [InnoDB Changes] HeatWave Statically Guided Load WL#15811: HeatWave Statically Guided Load WL#15811: [InnoDB Changes] HeatWave Statically Guided Load WL#14190: Replace old terms in replication SQL commands on the SOURCE WL#15874: Separate privileges for definer object creation and orphan object protection WL#15697 Relax server version check to allow downgrade WL#12794 rw-splitting WL#12794 rw-splitting WL#12794 rw-splitting WL#15800: Deprecate usage of weak ciphers in server WL#15006: WebauthN authentication plugin WL#11006: Remove expire-logs-days WL#15655 Firewall: Make database the plugin is using configurable WL#11006: Remove expire-logs-days WL#15800: Deprecate usage of weak ciphers in server WL#15696 Firewall: Periodically reload data from tables WL#13180 Remove function WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS - postfix WL#15785 EXPLAIN FOR SCHEMA WL#11006: Remove expire-logs-days WL#15803: Support query attributes for prepared statements WL#13964: Deprecate binlog_transaction_dependency_tracking WL#15006: WebauthN authentication plugin WL#15400 Add externally visible progress changes during startup and shutdown WL#15755: MAKE SQL_AFTER_GTIDS WORK WITH MTA WL#12429 Add a --no-login-paths option to turn off login paths from being processed WL#14190: Replace old terms in replication SQL commands on the SOURCE WL#14190: Replace old terms in replication SQL commands on the SOURCE WL#15524 Patch #2 TLS-safe upgrade of mgm socket to transporter WL#15524 Patch #2 TLS-safe upgrade of mgm socket to transporter WL#15524 Patch #1 "START TLS" for management API WL#15667: Make mysql_native_password server plugin optional WL#15871 Deprecate allow_primary_reads routing destinations URI param WL#15628: Adding support for new string functions in HeatWave WL#15339 Remove transaction buffering when plugin is SUSPENDED WL#15339 step 1: Remove transaction buffering when plugin is SUSPENDED WL#15871 Deprecate allow_primary_reads routing destinations URI param WL#15841 Option to allow traffic when the sole reachable partition has no quorum WL#14854: Remove disconnect-slave-event-count and abort-slave-event-count WL#15755: MAKE SQL_AFTER_GTIDS WORK WITH MTA WL#12794 rw-splitting [17/17] - tests WL#12794 rw-splitting [16/17] - bootstrap WL#12794 rw-splitting [15/17] - binlog-dump WL#12794 rw-splitting [14/17] - prepared statements WL#12794 rw-splitting [13/17] - reset, change-user WL#12794 rw-splitting [12/17] - implicit commit WL#12794 rw-splitting [11/17] - query, per query WL#12794 rw-splitting [10/17] - allow/forbid statements WL#12794 rw-splitting [09/17] - query, ROUTER SET access-mode WL#12974 rw-splitting [08/17] - query, switch read-write/read-only WL#12794 rw-splitting [07/17] - lazy-connect, check super-read-only WL#12794 rw-splitting [06/17] - lazy-connect, wait-for-my-writes WL#12794 rw-splitting [05/17] - lazy-connect, replay trx-stmt + error-handling WL#12794 rw-splitting [04/17] - connect WL#12794 rw-splitting [03/17] - expected server-mode WL#12794 rw-splitting [02/17] - server-mode in destinations WL#12794 rw-splitting [01/17] - configuration WL#15199: PERFORMANCE_SCHEMA, OTEL METRICS INTERFACE WL#13180 Remove function WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS - step 1 WL#15524 post-push fixes (2nd set) WL#15524 post-push fixes WL#15524 Patch #17 Run more existing MTR tests with TLS WL#15524 Patch #16 Use TLS for Event Listener WL#15524 Patch #15 Visbility WL#15524 Patch #14 Add MGM TLS support to all remaining tools WL#15524 patch #13 ndb_waiter and new MTR tests WL#15524 Patch #12 MGM TLS in API Nodes, mysqld, and Cluster/J WL#15524 Patch #11 Use MGM TLS in TransporterRegistry and MgmtSrvr WL#15524 Patches #9 and #10: --ndb-mgm-tls in ndbd and ndb_mgmd WL#15524 Patch #8 TLS options in ndb_mgm WL#15524 Patch #7 Add --ndb-mgm-tls option to ndb_sign_keys WL#15524 Patch #6 Command authorization in MGM client WL#15524 Patch #5 Command authorization in MGM server WL#15524 Patch #4 MGM TLS Configuration WL#15524 Patch #3 Use TLS for upgraded transporter WL#15524 Patch #2 TLS-safe upgrade of mgm socket to transporter WL#15524 Patch #1 "START TLS" for management API WL#15154 post-push fixes WL#13964: Deprecate binlog_transaction_dependency_tracking WL#15154 patch #9 Implement rules for node startup WL#15154 patch #8 TLS key rotation WL#15154 patch #7 MTR tests WL#15154 patch #6 Add "encrypted" column to ndbinfo.transporters WL#15154 patch #5 Establish TLS WL#15154 patch #4 Transporter configuration WL#15154 patch #3 TLS negotiation WL#15154 patch #2 Preliminary SocketAuthenticator refactoring WL#15154 patch #1 config parameters WL#15166 patch #4 Win32 fixes WL#15166 patch #3 Testing NdbProcess and ndb_sign_keys WL#15166 patch #2 Ndbinfo certificates table WL#15166 patch #1 ndb_sign_keys WL#15135 third set of post-push fixes WL#15135 second set of post-push fixes WL#15135 post-push fix WL#15135 patch #6: Configure TLS in Cluster/J WL#15135 patch #5: Configure TLS in DB and MGM nodes WL#15135 patch #4: Configure TLS in API and MySQL nodes WL#15135 patch #3: add TlsKeyManager to TransporterRegistry WL#15135 patch #2: Class TlsKeyManager WL#15135 patch #1: NodeCertificate classes Revert "WL#14056 Support GSSAPI/Kerberos authentication on Windows using authentication_ldap_sasl_client plug-in" WL#14056 Support GSSAPI/Kerberos authentication on Windows using authentication_ldap_sasl_client plug-in WL#15563: RPL Libraries WL#15257 Enhanced performance for set operations WL#15662 Add options to mysqldump to skip views and utilize read ahead WL#15766: Deprecate automatic reconnecton in the C API WL#15491 - HeatWave Self-Load WL#15627: Adding Support for the following primitives in RAPID. WL#15688 HeatWave Eventual Consistency WL#15614 OpenSSL 3.0 support in Cluster v7.5, 7.6/MySQL 5.7 Revert of the following git pushes: * f39058ca7a98e47e8d58dd90cbf826abc8fd2d07 WL#15667: Make mysql_native_password server plugin optional * 0f843d5db24c5b792fd4cb99ec71bb2a7997edc7 Postfix for WL#15667 for missing headers. * f2194558f894ef8fae2420379cde57a8c468d8e1 Addendum 2 to the fix for WL#15667: re-record the non-windows test WL#15614 OpenSSL 3.0 support in Cluster v7.5, 7.6/MySQL 5.7 Addendum 2 to the fix for WL#15667: re-record the non-windows test to match the new variable. Postfix for WL#15667 for missing headers. WL#15667: Make mysql_native_password server plugin optional WL#15766: Deprecate automatic reconnecton in the C API WL#15751: Password policy: Enforce minimum number of changed characters WL#15614 OpenSSL 3.0 support in Cluster v7.5, 7.6/MySQL 5.7 WL#15614 OpenSSL 3.0 support in Cluster v7.5, 7.6/MySQL 5.7 WL#15661 Refactoring: create socket using actual address family WL#15662 Add options to mysqldump to skip views and utilize read ahead WL#13968 Deprecate sync_relay_log_info [Post-Push-Fix] WL#13968 Deprecate sync_relay_log_info [Post-Push-Fix] WL#13968 Deprecate sync_relay_log_info [Post-Push Fix] WL#15497: Add statement type "DDL" to transaction tracking facility Bug#34664197: `group_replication_set_as_primary()` does not wait for ongoing ALTER TABLE WL# 13968 : Deprecate sync_relay_log_info WL#15633 Add mysql_reset_connection_nonblocking WL#15426: Implement SHOW PARSE_TREE
WL#12794 rw-splittingが気になる。コネクションごとにread-only, read-write設定できるとか？
あとはサーバのダウングレードができるようになるのかな。(WL#15697 Relax server version check to allow downgrade)
Bug#から始まるのはバグフィックスだろう。
条件わからないけど、インパクト強いのはこれかなw
Bug#35713721 redo log is never flushed
