Search Results
https://dev.mysql.com/doc/ndbapi/en/ndb-index.html
The order of the columns matches the order in which they are added to the index. As with the addColumn() and addColumnName() methods, the indexes are numbered in the order in which they were added. Ordered indexes currently do not support logging to ...Index Class Overview Index Class Constructor Index::addColumn() Index::addColumnName() Index::addColumnNames() Index::getColumn() Index::getLogging() Index::getName() Index::getNoOfColumns() Index::getObjectStatus() Index::getObjectVersion() Index::getObjectId() Index::getTable() Index::getType() Index::setLogging Index::setName() Index::setTable() Index::setType() Index::Type Index Class Overview Parent class NdbDictionary Child classes None Description This class represents an index on an NDB Cluster table ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbtransaction.html
NdbTransaction::scanIndex() Description Perform an index range scan of a table, with optional ordering. For an ordered index scan, result_record must be a key record for the index to be scanned; that is, it must include (at a minimum) all of the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load.html
mysql> SET SESSION group_concat_max_len = 1000000; mysql> SELECT GROUP_CONCAT(log->>"$.sql" SEPARATOR ' ') FROM sys.heatwave_autopilot_report WHERE type = "sql" ORDER BY id; *************************** 1. Tables are loaded in sequence, ordered by ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-modifiers.html
WITH ROLLUP queries, to test whether NULL values in the result represent super-aggregate values, the GROUPING() function is available for use in the select list, HAVING clause, and ORDER BY clause. ORDER BY and ROLLUP can be used together, which ...
https://dev.mysql.com/doc/refman/8.4/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; TABLE statement in place of SELECT, as shown here: INSERT INTO ta TABLE tb; TABLE tb is equivalent to SELECT * FROM tb. In ... 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.4/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.4/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.4/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.4/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.4/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 ...