autocommit
A setting that causes a commit operation after each SQL statement. This mode is not recommended for working with InnoDB tables with transactions that span several statements. It can help performance for read-only queries on InnoDB tables, where it minimizes overhead from locking and generation of undo data, especially in MariaDB 5.6.4 and up. It is also appropriate for working with MyISAM tables, where transactions are not applicable.
See also commit.
See also locking.
See also SQL.
See also transaction.
See also undo.