Search Results
MySQL 8.4 Reference Manual :: 19.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging
https://dev.mysql.com/doc/refman/8.4/en/replication-rbr-safe-unsafe.html
The “safeness” of a statement in MySQL replication refers to whether the statement and its effects can be replicated correctly using statement-based format. If this is true of the statement, we refer to the statement as safe; otherwise, we ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
Error number: 3992; Symbol: ER_DISABLE_GTID_MODE_REQUIRES_ASYNC_RECONNECT_OFF; SQLSTATE: HY000 Message: The @@GLOBAL.GTID_MODE = %s cannot be executed because Asynchronous Replication Connection Failover is enabled i.e. Error number: 6422; Symbol: ...Error number: 1591; Symbol: ER_NO_PARTITION_FOR_GIVEN_VALUE_SILENT; SQLSTATE: HY000 Message: Table has no partition for some existing values Error number: 1592; Symbol: ER_BINLOG_UNSAFE_STATEMENT; SQLSTATE: HY000 Message: Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = ...
https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html
With strict mode disabled, invalid dates such as '2004-04-31' are converted to '0000-00-00' and a warning is generated. NO_BACKSLASH_ESCAPES Enabling this mode disables the use of the backslash character (\) as an escape character within strings and ... The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system ...
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
If disconnect_on_expired_password: is disabled, the server permits the client to connect but puts it in sandbox mode. For inserts that specify NULL for such a column, the result is either an error for a single-row insert if strict SQL mode is ...
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-disable-gtids.html
However, if you have the possibility to take the servers offline when disabling GTIDs mode that process is easier. This section describes how to disable GTID transactions on servers that are already online. Before starting, all servers must meet ...
https://dev.mysql.com/doc/heatwave-aws/en/hw-aws-ha-disabling.html
Disabling high availability on a DB System 12.3.2 Disabling high availability on a DB System When disabling high availability on a DB system, the primary instance located in the preferred primary placement is converted to a standalone DB system and ...This task requires the following: A running DB system with high availability ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-disabling-enabling-channel.html
Disabling or Enabling a Channel 8.6.1 Disabling or Enabling a Channel Disabling a channel pauses the replication and enabling a channel resumes the replication. To disable or enable a Channel: In the MySQL HeatWave Console, select the Resources ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-metrics-table.html
SET GLOBAL innodb_monitor_disable = [counter-name|module_name|pattern|all]; innodb_monitor_reset: Resets counter values to zero. The innodb_monitor_disable and innodb_monitor_reset variables are supported on the command line only. Counters shown in ... The INNODB_METRICS table provides information about InnoDB performance and resource-related ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-command-options.html
Escaping may be disabled by using raw mode; see the description for the --raw option. In addition, output from the status (or \s) command includes this line when the option is enabled implicitly or explicitly: Binary data as: Hexadecimal To disable ...Batch mode results in nontabular output format and escaping of special ... mysql supports the following options, which can be specified ...
https://dev.mysql.com/doc/heatwave-aws/en/ha-enabling-disabling.html
Enabling and Disabling High Availability 12.3 Enabling and Disabling High Availability This section explains the enabling and disabling of high availability DB systems. Enabling high availability on a DB System Disabling high availability on a DB ...