PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/repeat.html
[begin_label:] REPEAT statement_list UNTIL search_condition END REPEAT [end_label] The statement list within a REPEAT statement is repeated until the search_condition expression is true. statement_list consists of one or more statements, each ...
https://dev.mysql.com/doc/refman/5.7/en/replica-connection-thread-states.html
Opening master dump table This state occurs after Creating table from master dump. These thread states occur on a replica server but are associated with connection threads, not with the I/O or SQL threads. Changing master The thread is processing a ...
https://dev.mysql.com/doc/refman/5.7/en/replication-configuration.html
This section describes how to configure the different types of replication available in MySQL and includes the setup and configuration required for a replication environment, including step-by-step instructions for creating a new replication ...For ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-errors.html
For example, you might need to create a nonexistent table before you can start the replica again. If a statement produces the same error (identical error code) on both the source and the replica, the error is logged, but replication continues. If a ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-fractional-seconds.html
There may be problems replicating from a source server that understands fractional seconds to an older replica (MySQL 5.6.3 and earlier) that does not: For CREATE TABLE statements containing columns that have an fsp (fractional seconds precision) ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-load-data.html
When mysqlbinlog reads log events for LOAD DATA statements logged in statement-based format, a generated local file is created in a temporary directory. LOAD DATA is considered unsafe for statement-based logging (see Section 16.2.1.3, ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-memory.html
A change in max_heap_table_size takes effect for MEMORY tables that are created or updated using ALTER TABLE ... When a replication source server shuts down and restarts, its MEMORY tables become empty. To replicate this effect to replicas, the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-auto-positioning.html
The correct approach to recover from this situation is for the replica to replicate the missing transactions listed in the ER_FOUND_MISSING_GTIDS message from another source, or for the replica to be replaced by a new replica created from a more ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids.html
This section discusses the following topics: How GTIDs are defined and created, and how they are represented in a MySQL server (see Section 16.1.3.1, “GTID Format and Storage”). This section explains transaction-based replication using global ...
https://dev.mysql.com/doc/refman/5.7/en/replication-implementation.html
Tables are created or their structure modified, and data is inserted, deleted, and updated according to the changes that were originally made on the source. Replication is based on the replication source server keeping track of all changes to its ...