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/replication-options-binary-log.html
To use encryption, a keyring plugin must be installed and configured to supply MySQL Server's keyring service. For instructions to do this, see Section 8.4.4, “The MySQL Keyring”. Any supported keyring plugin can be used to store binary log ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-row-format.html
The B-tree index that represents an entire table is known as the clustered index, which is organized according to the primary key columns. The nodes of a secondary index structure contain the values of index columns and primary key columns. This ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-option-tables.html
ndb-distribution: Default distribution for new tables in NDBCLUSTER (KEYHASH or LINHASH, default is KEYHASH). ndb-log-exclusive-reads: Log primary key reads with exclusive locks; allow conflict resolution based on read conflicts. The following list ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-handling.html
This would be the case, for example, were custid a primary key of customers. Disabling ONLY_FULL_GROUP_BY is useful primarily when you know that, due to some property of the data, all values in each nonaggregated column not named in the GROUP BY are ... SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are not named in the GROUP BY ...
https://dev.mysql.com/doc/refman/8.0/en/tracing-example.html
row *************************** QUERY: SELECT SUM(alias2.col_varchar_nokey) AS c1, alias2.pk AS c2 FROM t1 AS alias1 STRAIGHT_JOIN t2 AS alias2 ON alias2.pk = alias1.col_int_key WHERE alias1.pk GROUP BY c2 ORDER BY alias1.col_int_key, alias2.pk This ...Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G ...
https://dev.mysql.com/doc/refman/8.0/en/explain.html
In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query execution plan (that is, an explanation of how MySQL would execute a query). The following discussion uses ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-dict-obj-tree.html
This is intended primarily for use in testing, but can be useful in visualizing hierarchies of NDB database objects. The dict_obj_tree table provides a tree-based view of table information from the dict_obj_info table. This means that you must know ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-member-actions.html
From MySQL 8.0.26, Group Replication has the capability to set actions for the members of a group to take in specified situations. The member actions configuration for a server can also be reset to the default after it has left the group.
https://dev.mysql.com/doc/refman/8.0/en/group-replication-upgrading-member.html
In a multi-primary mode group, when the upgrade has been completed successfully and the group is ready to process transactions, members that are intended as writeable primaries must be set to read-write mode. This section explains the steps ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlslap.html
--auto-generate-sql-guid-primary Command-Line Format --auto-generate-sql-guid-primary Type Boolean Default Value FALSE Add a GUID-based primary key to automatically generated tables. --auto-generate-sql-load-type=type Command-Line Format ...