Search Results
https://dev.mysql.com/doc/refman/8.4/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.4/en/firewall-usage.html
Before using MySQL Enterprise Firewall, install it according to the instructions provided in Section 8.4.7.2, “Installing or Uninstalling MySQL Enterprise Firewall”. This section describes how to configure MySQL Enterprise Firewall using SQL ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-natural-language.html
It is possible to write a plugin that replaces the built-in full-text parser. By default or with the IN NATURAL LANGUAGE MODE modifier, the MATCH() function performs a natural language search for a string against a text collection. A collection is ...
https://dev.mysql.com/doc/refman/8.4/en/function-optimization.html
In the original statement, replace the expression with a reference to the variable, which the optimizer can treat as a constant value: SET @keyval = FLOOR(1 + RAND() * 49); UPDATE t SET col_a = some_expr WHERE id = @keyval; Assign the random value ...A function is nondeterministic if, given fixed values for its arguments, it can return different results for different ...
https://dev.mysql.com/doc/refman/8.4/en/general-thread-states.html
rename result table The thread is processing an ALTER TABLE statement, has created the new table, and is renaming it to replace the original table. The following list describes thread State values that are associated with general query processing ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-optimization.html
Whether use of temporary tables can be replaced by index access also depends on which parts of an index are used in a query, the conditions specified for these parts, and the selected aggregate functions. The most general way to satisfy a GROUP BY ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-change-primary.html
When this is done, the current primary becomes a read-only secondary, and the specified group member becomes the read/write primary; this replaces the usual primary election process (see Section 20.1.3.1, “Single-Primary Mode”). This section ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-cloning.html
You can install the plugin by issuing this statement: INSTALL PLUGIN group_replication SONAME 'group_replication.so'; You can initiate a cloning operation manually if the operation involves a group member on which Group Replication is running, ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-distributed-recovery.html
During a remote cloning operation, the existing data on the joining member is removed, and replaced with a copy of the donor's data. Whenever a member joins or rejoins a replication group, it must catch up with the transactions that were applied by ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-new-primary.html
This function replaces the usual primary election process; see Section 20.5.1.1, “Changing the Primary”, for more information. The following function enables you to set a member of a single-primary replication group to take over as the primary.