zpcastaneda · September 24, 2018 06:28
diff --git a/mysql_header_footer.sql b/mysql_header_footer.sql
 -- 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';
	-- 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';