PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/problems-with-float.html
The following example uses DOUBLE to demonstrate how calculations that are done using floating-point operations are subject to floating-point error. Floating-point numbers sometimes cause confusion because they are approximate and not stored as ...
https://dev.mysql.com/doc/refman/8.0/en/proxy-users.html
The plugin that authenticates a given connection may request that the connecting (external) user be treated as a different user for privilege-checking purposes. This enables the external user to be a proxy for the second user; that is, to assume the ...
https://dev.mysql.com/doc/refman/8.0/en/range-optimization.html
For UPDATE and DELETE statements, if the optimizer falls back to a full table scan and the sql_safe_updates system variable is enabled, an error occurs rather than a warning because, in effect, no key is used to determine which rows to modify. The ...
https://dev.mysql.com/doc/refman/8.0/en/rebuilding-tables.html
For example, an error in a collation might have been corrected, necessitating a table rebuild to update the indexes for character columns that use the collation. This section describes how to rebuild or repair tables or indexes, which may be ...
https://dev.mysql.com/doc/refman/8.0/en/replica-io-thread-states.html
Waiting to reconnect after a failed master event read From MySQL 8.0.26: Waiting to reconnect after a failed source event read An error occurred while reading (due to disconnection). The following list shows the most common states you see in the ...
https://dev.mysql.com/doc/refman/8.0/en/replica-logs-relaylog.html
If a replica uses the default host-based relay log file names, changing a replica's host name after replication has been set up can cause replication to fail with the errors Failed to open the relay log and Could not find target log during relay log ... The relay log, like the binary log, consists of a set of numbered files containing events that describe database changes, and an index file that contains the names of all used relay log ...
https://dev.mysql.com/doc/refman/8.0/en/replication-asynchronous-connection-failover.html
When the feature is disabled, you do not need to configure the replication channel on the secondary group members, but if the primary goes offline or into an error state, replication stops for the channel. Beginning with MySQL 8.0.22, you can use ...
https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption.html
From MySQL 8.0.14, mysqlbinlog returns a suitable error if you attempt to read an encrypted binary log file directly, but older versions of mysqlbinlog do not recognize the file as a binary log file at all. From MySQL 8.0.14, binary log files and ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-load-data.html
If you need to recover from a replication error involving a LOAD DATA INFILE operation logged in statement format, and the replicated event is trusted, you could grant the FILE privilege to the PRIVILEGE_CHECKS_USER account temporarily, removing it ... LOAD DATA is considered unsafe for statement-based logging (see Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-max-allowed-packet.html
If you are replicating large column values (such as might be found in TEXT or BLOB columns) and max_allowed_packet is too small on the source, the source fails with an error, and the replica shuts down the replication I/O (receiver) thread.