tom__bo’s Blog

MySQL!! MySQL!! @tom__bo

MySQL 8.1.0から8.2.0までのコミットメッセージのSubject一覧

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