Transactions and Recovery

Set Transaction Name

SET TRANSACTION NAME 'namehere';

Create Savepoint

# like a commit, you can roll back to it, except it is less perniment
SAVEPOINT saveName;

ROLLBACK TO SAVEPOINT saveName;

Set autocommit

set autocommit on;
set autocommit off;
set autocommit 10;
show autocommit;