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/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. For additional options that can be set in ... 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/mysql-cluster-start-phases.html
These phases are the same as those reported in the output from the node_id STATUS command in the management client (see Section 25.6.1, “Commands in the NDB Cluster Management Client”). There are several different startup types and modes, as ...
https://dev.mysql.com/doc/refman/8.0/en/federated-usagenotes.html
Internally, the implementation uses SELECT, INSERT, UPDATE, and DELETE, but not HANDLER. The FEDERATED storage engine supports SELECT, INSERT, UPDATE, DELETE, TRUNCATE TABLE, and indexes. The insert_id and timestamp options are not propagated to the ...The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/nonpersistible-system-variables.html
SET PERSIST and SET PERSIST_ONLY enable global system variables to be persisted to the mysqld-auto.cnf option file in the data directory (see Section 15.7.6.1, “SET Syntax for Variable Assignment”). In this case, it cannot be set by users at ...
https://dev.mysql.com/doc/refman/8.0/en/security-plugins.html
MySQL includes several components and plugins that implement security features: Plugins for authenticating attempts by clients to connect to MySQL Server. A password-validation component for implementing password strength policies and assessing the ...For general discussion of the authentication process, see Section 8.2.17, “Pluggable ...
https://dev.mysql.com/doc/refman/8.0/en/account-activity-auditing.html
The User and Host column values in this row uniquely identify the account and correspond to the 'user_name'@'host_name' format in which account names are written in SQL statements. Its value is constructed from the User and Host columns of the user ... Applications can use the following guidelines to perform SQL-based auditing that ties database activity to MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/blackhole-storage-engine.html
However, because the BLACKHOLE table does not actually store any data, UPDATE and DELETE triggers are not activated: The FOR EACH ROW clause in the trigger definition does not apply because there are no rows. The BLACKHOLE storage engine acts as a ...To examine the source for the BLACKHOLE engine, look in the sql directory of a MySQL source ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-names.html
For example, utf8mb4_0900_ai_ci and latin1_swedish_ci are collations for the utf8mb4 and latin1 character sets, respectively. For example, utf8mb4_tr_0900_ai_ci and utf8mb4_hu_0900_ai_ci sort characters for the utf8mb4 character set using the rules ... MySQL collation names follow these conventions: A collation name starts with the name of the character set with which it is associated, generally followed by one or more suffixes indicating other collation ...
https://dev.mysql.com/doc/refman/8.0/en/charset-cp932.html
Why is cp932 needed? In MySQL, the sjis character set corresponds to the Shift_JIS character set defined by IANA, which supports JIS X0201 and JIS X0208 characters. (See http://www.iana.org/assignments/character-sets.) However, the meaning of ...
https://dev.mysql.com/doc/refman/8.0/en/gis-geometry-class-hierarchy.html
All classes have properties, and instantiable classes may also have assertions (rules that define valid class instances). The instantiable subclasses of Geometry are restricted to zero-, one-, and two-dimensional geometric objects that exist in ...