Search Results
https://dev.mysql.com/doc/internals/en/transactions-historical-note.html
First, observe that in BerkeleyDB the "auto-commit" mode causes automatic commit of operations that are atomic from the storage engine's perspective, such as a write of a record, but are too fine-grained to be atomic from the application's (MySQL's) ... "Statement transaction" is a non-standard term that comes from the days when MySQL supported the BerkeleyDB storage ...
https://dev.mysql.com/doc/internals/en/transactions-life-cycle.html
In non-autocommit mode, the same engines are registered in the normal transaction list. When a new connection is established, thd->transaction members are initialized to an empty state. If a statement uses any tables, all affected engines are ...
https://dev.mysql.com/doc/internals/en/user-level-locks.html
LOCK TABLE t1 IN SHARE MODE; --connection conn2 # Acquire the user level lock "mysqltest1". User-level locks are controlled with the SQL functions GET_LOCK(str,timeout) IS_FREE_LOCK(str) IS_USED_LOCK(str) RELEASE_LOCK(str) They can be used at ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-lockmode.html
Lock modes for read operations. SHARED: Set a shared lock on rows EXCLUSIVE: Set an exclusive lock on rows READ_COMMITTED: Set no locks but read the most recent committed values 4.3.1.18.1 Synopsis public final class LockMode extends, ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-session.html
Table 4.67 savePersistentAll(Iterable<?>) Parameter Description instances the instances to update 4.3.1.22.28 setLockMode(LockMode) public abstract void setLockMode(LockMode lockmode); Set the lock mode for read operations. Table 4.68 ...Session ...
https://dev.mysql.com/doc/ndbapi/en/ndb-nodejs-api-batch.html
A batch is executed in the context of the session's current state: this is autocommit if a transaction has not been started; this also includes the default lock mode and the partition key. When a batch is executed, all operations are executed; the ...
https://dev.mysql.com/doc/ndbapi/en/ndb-nodejs-api-session.html
A session is the main user access path to the database. Session extends Context getMapping(Object parameter, Function(Object err, Object mapping) callback); Get the mappings for a table or class. The parameter may be a table name, a mapped ...
https://dev.mysql.com/doc/ndbapi/en/ndb-nodejs-api-transaction.html
If it is automatic, (autocommit), every operation is performed as part of a new transaction that is automatically committed. Beginning, committing, and rolling back a transaction begin(); Begin a transaction. This method takes as its sole argument a ...
https://dev.mysql.com/doc/ndbapi/en/overview-mgm-api.html
The MGM API's principal structures model the states of individual modes (ndb_mgm_node_state), the state of the NDB Cluster as a whole (ndb_mgm_cluster_state), and management server response messages (ndb_mgm_reply). The NDB Cluster Management API, ...
https://dev.mysql.com/doc/ndbapi/en/overview-ndb-api.html
It is also possible to perform operations in a “no-commit” or deferred mode, to be committed at a later time. The NDB API is an object-oriented application programming interface for NDB Cluster that implements indexes, scans, transactions, and ...