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/keyring-functions-general-purpose.html
MySQL Server supports a keyring service that enables internal components and plugins to store sensitive information securely for later retrieval. MySQL Server also includes an SQL interface for keyring key management, implemented as a set of ...For ...
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/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/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/mysql-cluster-online-operations.html
The table to be altered must have an explicit primary key; the hidden primary key created by the NDB storage engine is not sufficient for this purpose. row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) NOT NULL ... MySQL NDB Cluster 8.0 supports online table schema changes using ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-add-node-example.html
Its use here to redistribute data onto a new NDB Cluster node group is an exception in this regard; when used in this way, no other keywords or identifiers follow REORGANIZE PARTITION. In this section we provide a detailed example illustrating how ...
https://dev.mysql.com/doc/refman/8.0/en/creating-ssl-files-using-openssl.html
This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and clients. See Section 8.3.3.1, “Creating SSL and RSA Certificates and Keys using MySQL”. Important Whatever method you use ...The first example shows a simplified procedure such as you might use from the command ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-summary-tables.html
The Performance Schema maintains tables for collecting current and recent statement events, and aggregates that information in summary tables. Section 29.12.6, “Performance Schema Statement Event Tables” describes the events on which statement ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-examples.html
Note This section describes locking information as exposed by the Performance Schema data_locks and data_lock_waits tables, which supersede the INFORMATION_SCHEMA INNODB_LOCKS and INNODB_LOCK_WAITS tables in MySQL 8.0. For similar discussion ...