PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-multiple-get-range-query.html
The daemon_memcached plugin supports multiple get operations (fetching multiple key-value pairs in a single memcached query) and range queries. Multiple get Operations The ability to fetch multiple key-value pairs in a single memcached query ...The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-tuning.html
get key_value Using System Memory For best performance, deploy the daemon_memcached plugin on machines that are configured as typical database servers, where the majority of system RAM is devoted to the InnoDB buffer pool, through the ... Because ...
https://dev.mysql.com/doc/refman/8.0/en/known-issues.html
Dropping a FOREIGN KEY constraint does not work in replication because the constraint may have another name on the replica. DELETE if you are deleting rows from a table that has foreign keys with ON DELETE CASCADE properties. SELECT if you have ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-print-backup-file.html
--backup-key, -K Command-Line Format --backup-key=key Introduced 8.0.31-ndb-8.0.31 Specify the key needed to decrypt an encrypted backup. --backup-key-from-stdin Command-Line Format --backup-key-from-stdin Introduced 8.0.31-ndb-8.0.31 Allow input of ...This can be any of the files (.Data, .ctl, or .log file) found in a cluster backup ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-tde-implementation.html
The secrets file contains a Node Master Key (NMK), a key used later to encrypt the different file types used for persistence. cac256e18b2ddf6b5ef82d99a72f18e864b78453cc7fa40bfaf0c40b91122d18 The per-node key hierarchy can be represented as follows: ... For NDB Transparent Data Encryption (TDE), data nodes encrypt user data at rest, with security provided by a password (file system password), which is used to encrypt and decrypt a secrets file on each data ...
https://dev.mysql.com/doc/refman/8.0/en/alter-tablespace.html
The UNDO keyword, introduced in MySQL 8.0.14, is used with the SET {ACTIVE | INACTIVE} clause to mark an InnoDB undo tablespace as active or inactive. A keyring plugin must be installed and configured before encryption can be enabled. ALTER ...It ...
https://dev.mysql.com/doc/refman/8.0/en/drop-tablespace.html
The UNDO keyword, introduced in MySQL 8.0.14, must be specified to drop an undo tablespace. mysql> CREATE TABLESPACE `ts1` ADD DATAFILE 'ts1.ibd' Engine=InnoDB; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY) TABLESPACE ts1 Engine=InnoDB; mysql> DROP ...
https://dev.mysql.com/doc/refman/8.0/en/federated-create-connection.html
For example: CREATE TABLE federated_table ( id INT(20) NOT NULL AUTO_INCREMENT, name VARCHAR(32) NOT NULL DEFAULT '', other INT(20) NOT NULL DEFAULT '0', PRIMARY KEY (id), INDEX name (name), INDEX other_key (other) ) ENGINE=FEDERATED DEFAULT ... To ...
https://dev.mysql.com/doc/refman/8.0/en/federated-create-server.html
If you are creating a number of FEDERATED tables on the same server, or if you want to simplify the process of creating FEDERATED tables, you can use the CREATE SERVER statement to define the server connection parameters, just as you would with the ...
https://dev.mysql.com/doc/refman/8.0/en/federated-create.html
To create a FEDERATED table you should follow these steps: Create the table on the remote server. Alternatively, make a note of the table definition of an existing table, perhaps using the SHOW CREATE TABLE statement. Create the table on the local ...