Search Results
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html
(Bug #36118772) Warnings for unused variables are turned into compilation errors when compiling with -DMYSQL_MAINTAINER_MODE=1. (WL #16138) Deprecation and Removal Notes Important Change: The deprecated mysql_native_password authentication plugin is ...(Bug #36301441) Audit log filtering by type, using error as the type, did not work ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-data-encryption.html
It uses Electronic Codebook (ECB) block encryption mode for tablespace key encryption and Cipher Block Chaining (CBC) block encryption mode for data encryption. When table_encryption_privilege_check is disabled (the default), the privilege check ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
The outcome of attempting to change the storage engine of a table is affected by whether the desired storage engine is available and the setting of the NO_ENGINE_SUBSTITUTION SQL mode, as described in Section 7.1.11, “Server SQL Modes”. To ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-tpch-quickstart.html
If it opens in JavaScript (JS) mode, run the following command to switch to SQL execution mode. Start MySQL Shell and connect to the DB System endpoint: $> mysqlsh Username@DBSystem_IP_Address_or_Host_Name Note MySQL Shell opens in SQL execution ...
https://dev.mysql.com/doc/refman/8.4/en/expired-password-handling.html
If disconnect_on_expired_password is disabled, the server puts the client in sandbox mode. For example: ALTER USER 'myuser'@'localhost' PASSWORD EXPIRE; For each connection that uses an account with an expired password, the server either disconnects ... MySQL provides password-expiration capability, which enables database administrators to require that users reset their ...
https://dev.mysql.com/doc/refman/8.4/en/events-configuration.html
(See next item.) DISABLED: This value renders the Event Scheduler nonoperational. When the Event Scheduler is DISABLED, the event scheduler thread does not run (and so does not appear in the output of SHOW PROCESSLIST). If the Event Scheduler status ... Events are executed by a special event scheduler thread; when we refer to the Event Scheduler, we actually refer to this ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-redo-log.html
Disabling Redo Logging You can disable redo logging using the ALTER INSTANCE DISABLE INNODB REDO_LOG statement. Disabling redo logging speeds up data loading by avoiding redo log writes and doublewrite buffering. It is permitted to shutdown and ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-member-actions.html
When this member action is enabled and taken, super read-only mode is disabled on the primary, so that the primary becomes read-write and accepts updates from a replication source server and from clients. When this member action is disabled and not ... The following functions can be used to enable and disable actions for members of a group to take in specified situations, and to reset the configuration to the default setting for all member ...
https://dev.mysql.com/doc/relnotes/connector-cpp/en/news-8-0-22.html
However, the option for compression algorithms is subject to the compression mode: If the compression mode is disabled, the compression algorithms option is ignored. (Bug #31329938) For connections made using X Plugin, the default compression mode ...URI mode follows X DevAPI URI mode: mysqlx_session_t *sess = mysqlx_get_session_from_url( "mysqlx://user:password@host:port/db?compression-algorithms=[lz4,zstd_stream]", &error); Option mode follows the string format used for SessionOption: mysqlx_session_option_set(opt, OPT_HOST("host_name"), OPT_USER("user"), OPT_PWD("password"), OPT_COMPRESSION_ALGORITHMS("lz4,zstd_stream"), PARAM_END)); These rules apply: Permitted algorithm names are zstd_stream, lz4_message, and deflate_stream, and their aliases zstd, lz4, and ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-sql-mode.html
This property is used to retrieve and set the SQL Modes for the current connection. The value should be a list of different modes separated by comma (","), or a sequence of modes, preferably using the constants.SQLMode class. To unset all modes, ...