PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/row-constructor-optimization.html
Consider the following table, which has a primary key on (c1, c2, c3): CREATE TABLE t1 ( c1 INT, c2 INT, c3 INT, c4 CHAR(100), PRIMARY KEY(c1,c2,c3) ); In this query, the WHERE clause uses all columns in the index. row *************************** ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-preparation.html
If the source cluster is already in use, you can create a backup of the source and load this onto the replica to cut down on the amount of time required for the replica to synchronize itself with the source. ndb-connectstring=management_host[:port] ... Preparing the NDB Cluster for replication consists of the following steps: Check all MySQL servers for version compatibility (see Section 25.7.2, “General Requirements for NDB Cluster ...
https://dev.mysql.com/doc/refman/8.0/en/version-tokens-installation.html
To avoid this overhead, do not install it unless you plan to use it. This section describes how to install or uninstall Version Tokens, which is implemented in a plugin library file containing a plugin and loadable functions. For general information ...
https://dev.mysql.com/doc/refman/8.0/en/installing-source-distribution.html
Create the directory and go there: $> mkdir bld $> cd bld Configure the build directory. To do this, starting with mysql-src as your current working directory, create the directory build and then go there: $> mkdir build $> cd build Configure the ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-encrypted-file-component.html
To use component_keyring_encrypted_file for keystore management in the most common scenario, create two files: a manifest file that tells the server to load component_keyring_encrypted_file, and a configuration file that specifies where to store the ... Note component_keyring_encrypted_file is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-file-component.html
To use component_keyring_file for keystore management in the most common scenario, create two files: a manifest file that tells the server to load component_keyring_file, and a configuration file that specifies where to store the keys. Verify ...
https://dev.mysql.com/doc/refman/8.0/en/stored-routines-privileges.html
The MySQL grant system takes stored routines into account as follows: The CREATE ROUTINE privilege is needed to create stored routines. This privilege is granted automatically to the creator of a routine if necessary, and dropped from the creator ...The ALTER ROUTINE privilege is needed to alter or drop stored ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-failure-handling.html
User-created data (schemas, tables, tablespaces) and binary logs on the recipient are removed before data is cloned to the recipient data directory. When user-created data and binary logs are removed from the recipient data directory during a remote ... This section describes failure handing at different stages of a cloning ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-oci-plugin.html
As indicated by the preceding table, several plugin-related system variables are mandatory and must also be set: Oracle Cloud Infrastructure uses Oracle Cloud IDs (OCIDs) extensively to designate resources, and several keyring_oci parameters specify ... Note The keyring_oci plugin is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/view-check-option.html
The WITH CHECK OPTION clause can be given for an updatable view to prevent inserts to rows for which the WHERE clause in the select_statement is not true. In a WITH CHECK OPTION clause for an updatable view, the LOCAL and CASCADED keywords ...It ...