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/group-replication-single-primary-mode.html
20.1.3.1.1 Primary Election Algorithm The automatic primary member election process involves each member looking at the new view of the group, ordering the potential new primary members, and choosing the member that qualifies as the most suitable.
https://dev.mysql.com/doc/refman/8.0/en/insert-select.html
For example: INSERT INTO tbl_temp2 (fld_id) SELECT tbl_temp1.fld_order_id FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100; Beginning with MySQL 8.0.19, you can use a TABLE statement in place of SELECT, as shown here: INSERT INTO ta TABLE tb; TABLE ... INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-memory-per-fragment.html
Secondary ordered indexes are fragmented and distributed in the same way as the base table. Ordered index fragments are T-tree structures which maintain a balanced tree containing row references in the order implied by the indexed columns. The tree ... memory_per_fragment Table: Notes memory_per_fragment Table: Examples The memory_per_fragment table provides information about the usage of memory by individual ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-operations-per-fragment.html
This currently has the following formats: Base table: DbName/def/TblName BLOB table: DbName/def/NDB$BLOB_BaseTblId_ColNo Ordered index: sys/def/BaseTblId/IndexName Unique index: sys/def/BaseTblId/IndexName$unique The $unique suffix shown for unique ... The operations_per_fragment table provides information about the operations performed on individual fragments and fragment replicas, as well as about some of the results from these ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-what-is-new.html
It is possible to make such changes from any connected SQL node, but recommended practice is to do so from a designated SQL node only, since the order of execution of statements affecting privileges from different SQL nodes cannot be guaranteed to ... The following sections describe changes in the implementation of MySQL NDB Cluster in NDB Cluster 8.0 through 8.0.44, as compared to earlier release ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html
Invocation Syntax There are in general three ways to use mysqldump—in order to dump a set of one or more tables, a set of one or more complete databases, or an entire MySQL server—as shown here: mysqldump [options] db_name [tbl_name ...] ... The ...
https://dev.mysql.com/doc/refman/8.0/en/nested-join-optimization.html
In the first query, the parentheses can be omitted: The grammatical structure of the join expression dictates the same order of execution for join operations. Thus, for our query with outer joins, only one nesting order is possible. However, because ...The following discussion refers to the join syntax described in Section 15.2.13.2, “JOIN ...
https://dev.mysql.com/doc/refman/8.0/en/option-files.html
Option File Processing Order Option File Syntax Option File Inclusions Option File Processing Order MySQL looks for option files in the order described in the following discussion and reads any that exist. On Windows, MySQL programs read startup ...
https://dev.mysql.com/doc/refman/8.0/en/table.html
Given the existence of a table named t, the following two statements produce identical output: TABLE t; SELECT * FROM t; You can order and limit the number of rows produced by TABLE using ORDER BY and LIMIT clauses, respectively. For limiting which ... TABLE is a DML statement introduced in MySQL 8.0.19 which returns rows and columns of the named ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-connection-compression.html
The algorithm names zstd_stream, lz4_message, and deflate_stream can be specified in any combination, and the order and lettercase are not important. The list of permitted compression algorithms in priority order (from MySQL 8.0.22). If the server ... From MySQL 8.0.19, X Plugin supports compression of messages sent over X Protocol ...