Added macOS/ARM support. (Bug #34017614)
On Windows, improved the generated INFO_BIN and INFO_SRC files. (Bug #33972317, Bug #34052301)
keyring_awsplugin has been updated to use the latest AWS Encryption SDK for C (version 1.9.186).
keyring_aws_regionvariable supports the additional AWS regions supported by the new SDK. Refer to the variable description for a list of supported AWS regions. (WL #14547)
SHOW PROCESSLISTstatement provides process information by collecting thread data from all active threads. However, because the implementation iterates across active threads from within the thread manager while holding a global mutex, it has negative performance consequences, particularly on busy systems.
SHOW PROCESSLISTimplementation is now available based on the new Performance Schema
processlisttable. This implementation queries active thread data from the Performance Schema rather than the thread manager and does not require a mutex:
To enable the alternative implementation, enable the
processlisttable is automatically created in the Performance Schema for new installations of MySQL 5.7.39, or higher, and upgrades to MySQL 5.7.39, or higher.
The alternative implementation of
SHOW PROCESSLISTalso applies to the mysqladmin processlist command.
The alternative implementation does not apply to the
PROCESSLISTtable or the
COM_PROCESS_INFOcommand of the MySQL client/server protocol.
To ensure that the default and alternative implementations yield the same information, certain configuration requirements must be met; see The processlist Table.
Important Change: The linked curl library for MySQL Server (Enterprise Edition) has been updated to version 7.83.1. (Bug #34138733)
Important Change: The linked OpenSSL library for MySQL Server has been updated to version 1.1.1o. Issues fixed in OpenSSL version 1.1.1o are described at https://www.openssl.org/news/cl111.txt and https://www.openssl.org/news/vulnerabilities.html. (Bug #34133985)
myisam_repair_threadssystem variable and myisamchk
--parallel-recoveroption were removed. (Bug #31052408, WL #14938)
InnoDB: A 4GB tablespace file size limit on Windows 32-bit systems has been removed. The limit was due to an incorrect calculation performed while extending the tablespace. (Bug #28934351)
Replication: The write sets extracted by MySQL Replication from transactions when the
transaction_write_set_extractionsystem variable is enabled (which is the default) are extracted from primary keys, unique keys, and foreign keys. They are used to detect dependencies and conflicts between transactions. Previously, write sets involving multi-column foreign keys were incorrectly identifying each column as a separate foreign key. The issue has now been fixed and foreign key write sets include all referenced key columns. (Bug #34095747, Bug #34144531)
Replication: When the
--replicate-same-server-idoption was used to make the replica not skip events that have its own server ID, if the log file was rotated, replication stopped with an error. The log rotation event now checks and applies the current value of the option. (Bug #89375, Bug #27492990)
Under certain circumstances
TRUNCATE performance_schema.accountscaused duplicated counts in
This occurred only if the following was true:
show_compatibility_56is set to 0, aggregating status variables by accounts, users and hosts.
If some hosts were not instrumented. For example, if
performance_schema_hosts_sizewas set to a low value.
Our thanks to Yuxiang Jiang and the Tencent team for the contribution. (Bug #34057013, Bug #106939)
Upgraded the bundled zlib library to zlib 1.2.12. Also made zlib 1.2.12 the minimum zlib version supported, and removed WITH_ZLIB from the WITH_SYSTEM_LIBS CMake option. (Bug #34015600)
If an incorrect value was set for the
binlog_checksumsystem variable during a session, a COM_BINLOG_DUMP command made in the same session to request a binary log stream from a source failed. The server now validates the specified checksum value before starting the checksum algorithm setup process. (Bug #32442749)