commit
A SQL statement that ends a transaction, making permanent any changes made by the transaction. It is the opposite of rollback, which undoes any changes made in the transaction.
InnoDB uses an optimistic mechanism for commits, so that changes can be written to the data files before the commit actually occurs. This technique makes the commit itself faster, with the tradeoff that more work is required in case of a rollback.
By default, MariaDB uses the autocommit setting, which automatically issues a commit following each SQL statement.
See also autocommit.
See also optimistic.
See also rollback.
See also SQL.
See also transaction.