Search Results
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbeventoperation.html
NdbEventOperation Class Overview NdbEventOperation::clearError() (DEPRECATED) NdbEventOperation::execute() NdbEventOperation::getBlobHandle() NdbEventOperation::getEpoch() NdbEventOperation::getEventType() (DEPRECATED) ... This section provides ...
https://dev.mysql.com/doc/ndbapi/en/overview-operations.html
Unique key accesses are similar to primary key accesses, except that a unique key access is executed as a read on an index table followed by a primary key access on the table. However, only one request is sent from the MySQL Server, and the read of ... An NdbTransaction consists of a list of operations, each of which is represented by an instance of NdbOperation, NdbScanOperation, NdbIndexOperation, or NdbIndexScanOperation (that is, of NdbOperation or one of its child ...
https://dev.mysql.com/doc/refman/8.4/en/index-hints.html
They also work with multi-table DELETE statements, but not with single-table DELETE, as shown later in this section. (For the general syntax for specifying tables in a SELECT statement, see Section 15.2.13.2, “JOIN Clause”.) The syntax for ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-secondary-engine.html
To identify tables in the DB System that are defined with a secondary engine, query the CREATE_OPTIONS column in the INFORMATION_SCHEMA.TABLES table. If the CREATE_OPTIONS column contains both SECONDARY_ENGINE=RAPID and SECONDARY_LOAD=1, the table ...If not, ask your admin user to grant you the required ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-lakehouse-data-mapping.html
Creating Lakehouse Mapping 9.2 Creating Lakehouse Mapping For MySQL HeatWave Lakehouse to process data in Amazon S3, it needs to first map the data in files on S3 to a MySQL HeatWave Lakehouse table. Once the S3 data is provided, the schema for the ...Note: To map and load data into Lakehouse, the Amazon S3 bucket in which the data is located and the DB System must be in the same ...
https://dev.mysql.com/doc/refman/8.4/en/backup-types.html
This type of backup is suitable for large, important databases that need to be recovered quickly when problems occur. Logical backups save information represented as logical database structure (CREATE DATABASE, CREATE TABLE statements) and content ... This section describes the characteristics of different types of ...
https://dev.mysql.com/doc/refman/8.4/en/blackhole-storage-engine.html
When you create a BLACKHOLE table, the server creates the table definition in the global data dictionary. That is, you can include index declarations in the table definition. Inserts into a BLACKHOLE table do not store any data, but if statement ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-triggers.html
Can a table have multiple triggers with the same trigger event and action time? A.5.11. Is it possible for a trigger to update tables on a remote server? A.5.12. Information about triggers can be obtained by querying the INFORMATION_SCHEMA.TRIGGERS ...Where can I find the documentation for MySQL 8.4 triggers? ...
https://dev.mysql.com/doc/refman/8.4/en/intersect.html
query_expression_body INTERSECT [ALL | DISTINCT] query_expression_body [INTERSECT [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See Section 15.2.14, “Set Operations with UNION, INTERSECT, and EXCEPT” INTERSECT limits the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-limits.html
Memory consumed when data is inserted into an NDB table is not automatically recovered when deleted, as it is with other storage engines. Instead, the following rules hold true: A DELETE statement on an NDB table makes the memory formerly used by ...