Search Results
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-_query.html
Return a map of key:value pairs that explain how the query will be or was executed. A Query instance represents a specific query with bound parameters. Table 4.37 deletePersistentAll() Parameter Description return the number of instances deleted ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbindexscanoperation.html
Description This type is used to describe an ordered key bound. Members Member names, types, and descriptions are shown in the following table: Table 2.47 IndexBound structure member names, types, and descriptions Name Type Description low_key const ...NdbIndexScanOperation Class Overview NdbIndexScanOperation::BoundType NdbIndexScanOperation::end_of_bound() NdbIndexScanOperation::getDescending() NdbIndexScanOperation::get_range_no() NdbIndexScanOperation::getSorted() NdbIndexScanOperation::IndexBound NdbIndexScanOperation::readTuples() NdbIndexScanOperation::reset_bounds() NdbIndexScanOperation::setBound() NdbIndexScanOperation Class Overview Parent class NdbScanOperation Child classes None Description The NdbIndexScanOperation class represents a scan operation using an ordered ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-model-import.html
The table to import should have the following columns, and their recommended parameters: chunk_id: INT AUTO_INCREMENT PRIMARY KEY model_object: LONGTEXT NOT NULL model_metadata: JSON DEFAULT NULL See Model Metadata. The model_metadata corresponding ... Use the ML_MODEL_IMPORT routine to import a pre-trained model into your model ...
https://dev.mysql.com/doc/refman/8.4/en/alter-user.html
For each operation, the factor item specifies the FACTOR keyword preceded by the number 2 or 3 to indicate whether the operation applies to the second or third authentication factor. The clause following the DEFAULT ROLE keywords permits these ...
https://dev.mysql.com/doc/refman/8.4/en/analyze-table.html
ANALYZE TABLE generates table statistics: ANALYZE TABLE without any HISTOGRAM clause performs a key distribution analysis and stores the distribution for the named table or tables. For MyISAM tables, ANALYZE TABLE for key distribution analysis is ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-statistics-table.html
For ANALYZE TABLE operations that update the key distribution, failure may occur even if the operation updates the table itself (for example, if it is a MyISAM table). If the index is the primary key, the name is always PRIMARY. EXPRESSION MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-index-types.html
When you define a PRIMARY KEY on a table, InnoDB uses it as the clustered index. If there is no logical unique and non-null column or set of columns to use a the primary key, add an auto-increment column. If you do not define a PRIMARY KEY for a ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-transactions.html
Unique key reads have their locks upgraded automatically by NDB to ensure a self-consistent read; BLOB reads also employ extra locking for consistency. You can help minimize issues with shared read locks by avoiding queries that use unique key ... A ...
https://dev.mysql.com/doc/refman/8.4/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.4/en/show-index.html
SHOW [EXTENDED] {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index information. row *************************** Table: city Non_unique: 0 Key_name: PRIMARY Seq_in_index: 1 Column_name: ID ...This statement requires some privilege for any column in the ...