1
Transactions
"An SQL-transaction (transaction) is a sequence of executions of SQL-statements that is atomic with respect to recovery. That is to say: either the execution result is completely successful, or it has no effect on any SQL-schemas or SQL-data."
— The SQL Standard
The InnoDB storage engine supports ACID-compliant transactions.
Transaction Articles
-
START TRANSACTION
Basic transaction control statements. -
COMMIT
Ends a transaction, making changes visible to subsequent transactions -
ROLLBACK
Cancel current transaction and the changes to data -
SET TRANSACTION
Sets the transaction isolation level. -
LOCK TABLES
Explicitly lock tables. -
SAVEPOINT
SAVEPOINT for a ROLLBACK. -
Metadata Locking
A lock which protects each transaction from external DDL statements. -
SQL statements That Cause an Implicit Commit
List of statements which implicitly commit the current transaction -
Transaction Timeouts
Timing out idle transactions -
UNLOCK TABLES
Explicitly releases any table locks held by the current session. -
WAIT and NOWAIT
Extended syntax so that it is possible to set lock wait timeout for certain statements. -
XA Transactions
Transactions designed to allow distributed transactions. -
READ COMMITTED
Each consistent read, even within the same transaction, sets and reads its own fresh snapshot. -
READ UNCOMMITTED
SELECT statements are performed in a non-locking fashion, but a possible ea... -
REPEATABLE READ
All consistent reads within the same transaction read the snapshot established by the first read. -
SERIALIZABLE
Similar to REPEATABLE READ, with SELECT ... LOCK IN SHARE MODE if autocommit is disabled.
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
