-- set isolation for processing
SET SESSION tx_isolation = 'READ-COMMITTED';
-- set config for processing
SET SQL_SAFE_UPDATES = 0;
SET AUTOCOMMIT = 0;
START TRANSACTION;

-- save and apply
COMMIT;
SET AUTOCOMMIT = 1;
SET SQL_SAFE_UPDATES = 1;
-- return isolation setting
SET SESSION tx_isolation = 'REPEATABLE-READ';