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/keyring-component-installation.html
For example, the InnoDB storage engine uses the keyring for tablespace encryption, so a keyring component or plugin must be loaded and available prior to InnoDB initialization. The database administrator has the responsibility for creating any ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-mgmd.html
All options that can be used with ndb_mgmd are shown in the following table. 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 ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-user-credentials.html
You must therefore set up a replication user with the correct permissions so that Group Replication can establish direct member-to-member replication channels. The process of creating the replication user for distributed recovery can be captured in ... Group Replication uses a distributed recovery process to synchronize group members when joining them to the ...
https://dev.mysql.com/doc/refman/8.0/en/alter-instance.html
ALTER INSTANCE ROTATE INNODB MASTER KEY This action rotates the master encryption key used for InnoDB tablespace encryption. To schedule regular rotation of the binary log master key on all applicable source and replica servers, you can enable the ... ALTER INSTANCE instance_action instance_action: { | {ENABLE|DISABLE} INNODB REDO_LOG | ROTATE INNODB MASTER KEY | ROTATE BINLOG MASTER KEY | RELOAD TLS [FOR CHANNEL {mysql_main | mysql_admin}] [NO ROLLBACK ON ERROR] | RELOAD KEYRING } ALTER INSTANCE defines actions applicable to a MySQL server ...
https://dev.mysql.com/doc/refman/8.0/en/charset-repertoire.html
The repertoire of a character set is the collection of characters in the set. String expressions have a repertoire attribute, which can have two values: ASCII: The expression can contain only ASCII characters; that is, characters in the Unicode ...
https://dev.mysql.com/doc/refman/8.0/en/drop-function-loadable.html
(DROP FUNCTION is also used to drop stored functions; see Section 15.1.29, “DROP PROCEDURE and DROP FUNCTION Statements”.) DROP FUNCTION is the complement of CREATE FUNCTION. It requires the DELETE privilege for the mysql system schema because ... DROP FUNCTION [IF EXISTS] function_name This statement drops the loadable function named ...
https://dev.mysql.com/doc/refman/8.0/en/example-storage-engine.html
mysql> CREATE TABLE test (i INT) ENGINE = EXAMPLE; Query OK, 0 rows affected (0.78 sec) mysql> INSERT INTO test VALUES(1),(2),(3); ERROR 1031 (HY000): Table storage engine for 'test' doesn't » have this option mysql> SELECT * FROM test; Empty set ... The EXAMPLE storage engine is a stub engine that does ...
https://dev.mysql.com/doc/refman/8.0/en/fractional-seconds.html
For example: CREATE TABLE t1 (t TIME(3), dt DATETIME(6)); The fsp value, if given, must be in the range 0 to 6. MySQL has fractional seconds support for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision: To define a ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-column-indexes.html
MySQL can create composite indexes (that is, indexes on multiple columns). If you specify the columns in the right order in the index definition, a single composite index can speed up several kinds of queries on the same table. A multiple-column ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-linear-hash.html
MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas regular hashing employs the modulus of the hashing function's value. We call this value V; it can be ...