PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/alter-user.html
For each operation, the factor item specifies the FACTOR keyword preceded by the number 2 or 3 to indicate whether the operation applies to the second or third authentication factor. The clause following the DEFAULT ROLE keywords permits these ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-index-types.html
When you define a PRIMARY KEY on a table, InnoDB uses it as the clustered index. If there is no logical unique and non-null column or set of columns to use a the primary key, add an auto-increment column. If you do not define a PRIMARY KEY for a ...
https://dev.mysql.com/doc/refman/8.0/en/switchable-optimizations.html
The following list describes the permissible opt_name flag names, grouped by optimization strategy: Batched Key Access Flags batched_key_access (default off) Controls use of BKA join algorithm. For batched_key_access to have any effect when set to ...Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-enterprise-backup.html
This is because the backup_progress table on the server is a CSV table, for which primary keys are not supported. MySQL Enterprise Backup is a commercially-licensed backup utility for MySQL Server, available with MySQL Enterprise Edition. This ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbd-definition.html
Consider this table definition: CREATE TABLE example ( a INT NOT NULL, b INT NOT NULL, c INT NOT NULL, PRIMARY KEY(a), UNIQUE(b) ) ENGINE=NDBCLUSTER; For each record, there are 12 bytes of data plus 12 bytes overhead. There is a primary key hash ...
https://dev.mysql.com/doc/refman/8.0/en/replication-asynchronous-connection-failover-replica.html
In MySQL 8.0.27 and later, asynchronous connection failover for replicas is activated automatically for a replication channel on a Group Replication primary when you set SOURCE_CONNECTION_AUTO_FAILOVER=1 in the CHANGE REPLICATION SOURCE TO ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-functions-legacy.html
This occurs, for example, if a function does not support a specified algorithm, a key length is too short or long, or a string expected to be a key string in PEM format is not a valid key. asymmetric_decrypt(algorithm, crypt_str, key_str) Decrypts ... In releases before MySQL 8.0.30, MySQL Enterprise Encryption's functions are based on the openssl_udf shared ...
https://dev.mysql.com/doc/refman/8.0/en/change-master-to.html
GET_MASTER_PUBLIC_KEY = {0|1} Enables RSA key pair-based password exchange by requesting the public key from the source. For connections by accounts that authenticate using this plugin, the source does not send the public key unless requested, so it ...] CHANGE MASTER TO changes the parameters that the replica server uses for connecting to the source and for reading data from the ...
https://dev.mysql.com/doc/refman/8.0/en/replace.html
REPLACE works exactly like INSERT, except that if an old row in the table has the same value as a new row for a PRIMARY KEY or a UNIQUE index, the old row is deleted before the new row is inserted. The server recognizes but ignores the DELAYED ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-functions-plugin-specific.html
For each keyring plugin-specific function, this section describes its purpose, calling sequence, and return value. For information about general-purpose keyring functions, see Section 8.4.4.15, “General-Purpose Keyring Key-Management Functions”. keyring_aws_rotate_cmk() Associated keyring plugin: keyring_aws keyring_aws_rotate_cmk() rotates the AWS KMS ...