Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-database.html
The permitted values are 'Y' (encryption enabled) and 'N' (encryption disabled). On the other hand, for a function called within a SELECT, execution of the function body happens in prelocked mode. To prevent this from happening, binary logging must ...alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.usage.html
The following sections describe the command-line options for the different modes of operation of mysqlbackup. Use the hyperlinks at the option names to jump to the detailed descriptions for the options. Note The command options can also be ...
https://dev.mysql.com/doc/refman/8.4/en/log-destinations.html
If specified at server startup, general_log takes an optional argument of 1 or 0 to enable or disable the log. The general_log and slow_query_log variables indicate whether the general query log and slow query log are enabled (ON) or disabled (OFF).
https://dev.mysql.com/doc/refman/8.4/en/password-management.html
Disable password expiration: CREATE USER 'jeffrey'@'localhost' PASSWORD EXPIRE NEVER; ALTER USER 'jeffrey'@'localhost' PASSWORD EXPIRE NEVER; This expiration option overrides the global policy for all accounts named by the statement. If ... MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-startup-configuration.html
To enable or disable it explicitly, start the server with the performance_schema variable set to an appropriate value. For example, use these lines in the server my.cnf file: [mysqld] performance_schema=ON If the server is unable to allocate any ...
https://dev.mysql.com/doc/refman/8.4/en/query-log.html
To disable or enable the general query log or change the log file name at runtime, use the global general_log and general_log_file system variables. Set general_log to 0 (or OFF) to disable the log or to 1 (or ON) to enable it. You can also rename ... The general query log is a general record of what mysqld is ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover-replica.html
If you later disable SOURCE_CONNECTION_AUTO_FAILOVER for the channel on the primary, this is also broadcast to the secondary servers, and they change the status of the channel to match. When the mysql_start_failover_channels_if_primary member action ... Asynchronous connection failover for replicas is activated automatically for a replication channel on a Group Replication primary when you set SOURCE_CONNECTION_AUTO_FAILOVER=1 in the CHANGE REPLICATION SOURCE TO statement for the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-lifecycle.html
If binary logging is disabled on the replica, the GTID is persisted atomically by writing it directly into the mysql.gtid_executed table. If binary logging is disabled on the replica, the mysql.gtid_executed table is also a complete record of the ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/connectors/en/connector-net-programming-datetime-restricting.html
Users of MySQL 5.0.2 and higher can use the new traditional SQL mode to restrict invalid date values. For information on using the traditional SQL mode, see Server SQL Modes. The best solution to the date problem is to restrict users from entering ...