PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.3Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/8.0/en/adding-character-set.html
<collation name="latin1_swedish_ci" id="8" order="Finnish, Swedish"> <flag>primary</flag> <flag>compiled</flag> </collation> <collation name="latin1_danish_ci" id="15" order="Danish"/> ... For each collation listed in the <charset> element for the ... This section discusses the procedure for adding a character set to ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-formats.html
The following statement displays the possible names: SELECT REPLACE(EVENT_NAME, 'statement/sql/', '') AS name FROM performance_schema.events_statements_summary_global_by_event_name WHERE EVENT_NAME LIKE 'statement/sql/%' ORDER BY name; ... The MySQL ...