Autocommit In the context of data management, autocommit is the mode of operation of a database connection. Each individual database interaction (i.e., each SQL statement) submitted through the database connection in autocommit mode will be executed in its own transaction that is implicitly committed. An SQL statement executed in autocommit mode cannot be rolled back. Autocommit mode incurs per-statement transaction overhead, having often undesirable performance or resource utilisation impact.
The alternative to autocommit mode (non-autocommit) means that the SQL client application itself is responsible for issuing transaction initiation (start transaction) and termination (commit or rollback) commands. Transaction initiation command is often implied and not necessary. Non-autocommit mode enables grouping of multiple data manipulation SQL commands into a single atomic transaction.
