1
Transactions
You are viewing an old version of this category. View
the current version here.
This is the main Knowledge Base category for MariaDB.
Follow any of the links below to find information on the topics you are interested in. If you would like to know more about anything that isn't documented, ask a question at the place where the answers should be and we will do our best to provide an answer for it!
-
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.