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
| Title | Description |
|---|---|
| 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. |
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.
© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/transactions/