PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-mode-change-online-enable-gtids.html
If you use binary logs for anything other than replication, for example point in time backup and restore, wait until you do not need the old binary logs having transactions without GTIDs. This section describes how to enable GTID transactions, and ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/replication-options-reference.html
replica_checkpoint_group: Maximum number of transactions processed by multithreaded replica before checkpoint operation is called to update progress status. replica_checkpoint_period: Update progress status of multithreaded replica and flush relay ... The following two sections provide basic information about the MySQL command-line options and system variables applicable to replication and the binary ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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, ...
https://dev.mysql.com/doc/refman/8.0/en/symbolic-links-to-tables.html
It works directly on the file to which the symlink points. Note When you drop a table that is using symlinks, both the symlink and the file to which the symlink points are dropped. Note Symbolic link support as described here, along with the ...
https://dev.mysql.com/doc/refman/8.0/en/trigger-syntax.html
(ROLLBACK to SAVEPOINT is permitted because it does not end a transaction.). For nontransactional tables, such rollback cannot be done, so although the statement fails, any changes performed prior to the point of the error remain in effect. To ...