Is it better to use AUTOCOMMIT = 0

5 votes

4 answers

16077 views

                          Is it better to use (for perfomance tuning) AUTOCOMMIT = 0 before bulk inserts of data in MySQL, if the insert query looks like 

INSERT INTO SomeTable (column1, column2) VALUES (val1,val2),(val3,val4),... ?

Asked by zavg (151 rep)

May 15, 2013, 03:34 PM
Last activity: Nov 4, 2019, 12:53 AM

Is it better to use AUTOCOMMIT = 0

Related Questions