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/innodb-online-ddl-operations.html
MySQL creates a new clustered index by copying the existing data from the original table to a temporary table that has the desired index structure. If the server exits while creating a new clustered index, no data is lost, but you must complete the ... Online support details, syntax examples, and usage notes for DDL operations are provided under the following topics in this ...
https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html
The functions in this section perform search operations on JSON values to extract data from them, report whether data exists at a location within them, or report the path to data within them. To check only whether any data exists at the path, use ...JSON_CONTAINS(target, candidate[, path]) Indicates by returning 1 or 0 whether a given candidate JSON document is contained within a target JSON document, or—if a path argument was supplied—whether the candidate is found at a specific path within the ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-system-variables.html
For the keyring_aws plugin to start successfully, the configuration file must exist and contain valid secret access key information, initialized as described in Section 6.4.4.5, “Using the keyring_aws Amazon Web Services Keyring Plugin”. At ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-add-node-basics.html
You must be careful that node IDs for any new data nodes added in the config.ini file do not overlap node IDs used by existing nodes. Perform a rolling restart of all existing NDB Cluster data nodes. It is not necessary (or usually even desirable) ... In this section, we list the basic steps required to add new data nodes to an NDB ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-mgmd.html
Otherwise—that is, if you wish to disable configuration caching for a management server that has already created a configuration cache—you must stop the management server, delete any existing configuration cache files manually, then restart the ... The management server is the process that reads the cluster configuration file and distributes this information to all nodes in the cluster that request ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-upgrade.html
An error occurs if a sys schema exists but has no version view, on the assumption that its absence indicates a user-created schema: A sys schema exists with no sys.version view. To upgrade in this case, remove or rename the existing sys schema first. If the file does not exist or is otherwise inaccessible, an error ... Each time you upgrade MySQL, you should execute mysql_upgrade, which looks for incompatibilities with the upgraded MySQL server: It upgrades the system tables in the mysql schema so that you can take ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-create-select.html
This includes the case that the destination table exists and IF NOT EXISTS is not given. When the destination table exists and IF NOT EXISTS is given, MySQL 5.7 ignores the statement completely; nothing is inserted or logged. SELECT statement to ...
https://dev.mysql.com/doc/refman/5.7/en/resignal.html
RESIGNAL is related to SIGNAL, but instead of originating a condition as SIGNAL does, RESIGNAL relays existing condition information, possibly after modifying it. Within a condition handler that catches a condition, one use for RESIGNAL alone is to ...RESIGNAL may change some or all information before passing it ...
https://dev.mysql.com/doc/refman/5.7/en/upgrade-binary-package.html
In-Place Upgrade Logical Upgrade In-Place Upgrade An in-place upgrade involves shutting down the old MySQL server, replacing the old MySQL binaries or packages with the new ones, restarting MySQL on the existing data directory, and upgrading any ...
https://dev.mysql.com/doc/refman/5.7/en/docker-mysql-more-topics.html
The following conditions must be met for the bind-mounting to work: The configuration file path-on-host-machine/my.cnf must already exist, and it must contain the specification for starting the server using the user mysql: [mysqld] user=mysql You ...