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/replication-gtids-auto-positioning.html
The correct approach to recover from this situation is to check manually whether the source and replica have diverged. These options specify the name of the log file and the starting position within the file, but with GTIDs the replica does not need ... GTIDs replace the file-offset pairs previously required to determine points for starting, stopping, or resuming the flow of data between source and ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-functions.html
This section provides examples of stored functions (see Chapter 23, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID ...GTID_SUBTRACT(): Returns the GTIDs from one GTID set that are not in ...
https://dev.mysql.com/doc/refman/5.7/en/replication-snapshot-method.html
If the database on the source contains existing data it is necessary to copy this data to each replica. This can be more efficient than using mysqldump and importing the file on each replica, because it skips the overhead of updating indexes as the ...There are different ways to dump the data from the ...
https://dev.mysql.com/doc/refman/5.7/en/server-option-variable-reference.html
For a version of this table that is specific to NDB Cluster, see Section 21.4.2.5, “NDB Cluster mysqld Option and Variable Reference”. This option is dynamic, but should be set only by server. The following table lists all command-line options, ...
https://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html
Typically, you do this using options on the CMake command line. This value is used as the parent location for several of the installation subdirectories. NDB 8.0.31 and later: Deprecated; use WITH_NDB instead ON WITH_NDBCLUSTER_STORAGE_ENGINE Prior ... The CMake program provides a great deal of control over how you configure a MySQL source ...
https://dev.mysql.com/doc/refman/5.7/en/windows-choosing-package.html
This format does not include an automated installer, and must be manually installed and configured. The package formats described in this section are: MySQL Installer MySQL noinstall ZIP Archives MySQL Docker Images Program Database (PDB) files ...
https://dev.mysql.com/doc/refman/5.7/en/alter-procedure.html
ALTER PROCEDURE proc_name [characteristic ...] characteristic: { COMMENT 'string' | LANGUAGE SQL | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA } | SQL SECURITY { DEFINER | INVOKER } } This statement can be used to change the ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-generated-columns.html
To work around this, drop the column, then add it with the new definition. This can lead to inconsistent data being returned and unexpectedly failed statements. For this reason, as of MySQL 5.7.13, ALTER TABLE operations that change the definition ... ALTER TABLE operations permitted for generated columns are ADD, MODIFY, and ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-problems.html
If something goes seriously wrong (although this shouldn't happen), MySQL may leave the old table as B-xxx. This is done because InnoDB and these operating systems cannot drop a table that is in use. If you get a duplicate-key error when using ...
https://dev.mysql.com/doc/refman/5.7/en/binlog-replication-configuration-overview.html
This section describes replication between MySQL servers based on the binary log file position method, where the MySQL instance operating as the source (where the database changes originate) writes updates and changes as “events” to the binary ...The information in the binary log is stored in different logging formats according to the database changes being ...