PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/replication-administration-skip.html
For instructions to do this, see Section 9.5, “Point-in-Time (Incremental) Recovery”. Before skipping the transaction and restarting the replica, check these points: Is the transaction that stopped replication from an unknown or untrusted ... If ...
https://dev.mysql.com/doc/refman/9.7/en/replication-mode-change-online-disable-gtids.html
The only thing that differs is the point at which you wait for logged transactions to replicate. If you use binary logs for anything other than replication—for example, to perform point-in-time backup or restore—wait until you no longer need any ... This section describes how to disable GTID transactions on servers that are already ...
https://dev.mysql.com/doc/refman/9.7/en/replication-options-binary-log.html
Transactions are written to the binary log at the point when all the storage engines involved have confirmed that the transaction is prepared to commit. If you are using GTIDs for replication, this means that even when binary logging is later ...
https://dev.mysql.com/doc/refman/9.7/en/replication-options-gtids.html
If gtid_next=AUTOMATIC is used for the session, gtid_owned is populated only briefly during the execution of the commit statement for the transaction, so it cannot be observed from the session concerned, although it is listed if @@global.gtid_owned ... The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers ...
https://dev.mysql.com/doc/refman/9.7/en/replication-options-replica.html
This variable works in combination with the replica_checkpoint_period system variable in such a way that, when either limit is exceeded, the checkpoint is executed and the counters tracking both the number of transactions and the time elapsed since ... This section explains the server options and system variables that apply to replica servers and contains the following: Startup Options for Replica Servers System Variables Used on Replica Servers Specify the options either on the command line or in an option ...
https://dev.mysql.com/doc/refman/9.7/en/replication-rbr-safe-unsafe.html
In addition, statements using results from floating-point math functions—which are hardware-dependent—are always considered unsafe (see Section 19.5.1.12, “Replication and Floating-Point Values”). The “safeness” of a statement in MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/replication-rules-table-options.html
Having reached this point, if there are no table options, the replica simply executes all events. The starting point is the end of the evaluation of the database-level options, as described in Section 19.2.5.1, “Evaluation of Database-Level ...
https://dev.mysql.com/doc/refman/9.7/en/replication-solutions-switch.html
From that point on, all updates sent by Web Client to Replica 1 are written to the binary log of Replica 1, which then contains every update sent to Replica 1 since Source became unavailable. If you fail to do this, the replicas may pick up stale ...
https://dev.mysql.com/doc/refman/9.7/en/resignal.html
ERROR 1051 (42S02): Unknown table 'xx' At this point, the contents of the first (current) and second (stacked) diagnostics areas are the same. ERROR 1051 (42S02): Unknown table 'xx' At this point, if @a = 0, RESIGNAL pops the diagnostics area stack, ...RESIGNAL may change some or all information before passing it ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-types.html
The term most commonly used is geometry, defined as a point or an aggregate of points representing anything in the world that has a location. The Open Geospatial Consortium (OGC) is an international consortium of more than 250 companies, agencies, ...