Search Results
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbtransaction.html
A transaction consists of a list of operations represented by the NdbOperation class, or by one of its subclasses—NdbScanOperation, NdbIndexOperation, or NdbIndexScanOperation. After obtaining an NdbTransaction object, it is employed as follows: ...Types NdbTransaction defines 2 public types as shown in the following table: Table 2.67 NdbTransaction class types and descriptions Name Description CommitStatusType() Describes the transaction's commit status ExecType() Determines whether the transaction should be committed or rolled back Using ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-sql-result-sets.html
When you execute an SQL operation on a Session using the sql() method, an SqlResult is returned. Iterating over an SqlResult is identical to working with results from CRUD operations. An SqlResult combines a result set produced by, for example, ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-memory-per-fragment.html
Hash index pages: These are allocated as 8 KB subpages, and store the primary key hash index structure. Each row also has a primary key hash index entry (corresponding to the hidden primary key that is part of every NDB table). memory_per_fragment ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-transactions.html
This can be done by using the IGNORE INDEX index hint as part of the SELECT statement reading the table (see Section 10.9.4, “Index Hints”). This issue does not occur for queries that use index or table scans, even against NDB tables having BLOB ... A number of limitations exist in NDB Cluster with regard to the handling of ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-reference.html
Com_change_replication_source: Count of CHANGE REPLICATION SOURCE TO and CHANGE MASTER TO statements. Com_show_binary_log_status: Count of SHOW BINARY LOG STATUS statements; use instead of Com_show_master_status. Com_show_replica_status: Count of ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-table-info.html
The tbl_name argument can be either the name of a MyISAM table or the name of its index file, as described in Section 6.6.4, “myisamchk — MyISAM Table-Maintenance Utility”. “Record” and “row” are synonymous, as are “field” and ...
https://dev.mysql.com/doc/refman/8.4/en/general-thread-states.html
Sorting result For a SELECT statement, this is similar to Creating sort index, but for nontemporary tables. checking permissions The thread is checking whether the server has the required privileges to execute the statement. copy to tmp table The ...
https://dev.mysql.com/doc/internals/en/transactions-life-cycle.html
If a statement uses any tables, all affected engines are registered in the statement engine list. At the end of the statement, the server issues a commit or a rollback for all engines in the statement list. At this point the transaction flags of an ... When a new connection is established, thd->transaction members are initialized to an empty ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-triggers.html
Does MySQL have statement-level or row-level triggers? All triggers are FOR EACH ROW; that is, the trigger is activated for each row that is inserted, updated, or deleted. How are triggers managed in MySQL? Triggers can be created using the CREATE ...Where can I find the documentation for MySQL 8.4 triggers? ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-reference.html
The value is NULL, or a non-NULL account that has the format user_name@host_name: If the value is NULL, the firewall records allowlist rules for statements received from any account that is a member of the group. If the value is non-NULL, the ...