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/mysql-upgrade.html
If the table cannot be repaired, see Section 2.10.12, “Rebuilding or Repairing Tables or Indexes” for manual table repair strategies. InnoDB tablespace encryption requires that the keyring plugin to be used be loaded prior to InnoDB ... Each ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-errors.html
This includes the case that a statement produces an error on the source or the replica, but not both. To address the issue, connect to the replica manually and determine the cause of the problem. For example, if the replication SQL thread records a ... If a statement produces the same error (identical error code) on both the source and the replica, the error is logged, but replication ...
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/create-database.html
To use this statement, you need the CREATE privilege for the database. If you manually create a directory under the data directory (for example, with mkdir), the server considers it a database directory and it shows up in the output of SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/drop-table.html
Be careful with this statement! For each table, it removes the table definition and all table data. If the table is partitioned, the statement removes the table definition, all its partitions, all data stored in those partitions, and all partition ...