MySQL Auto-commit

MySQL autocommit (auto-commit) is on by default, it has a certain impact on MySQL performance, for example, if you insert 1000 data, MySQL will commit1000 times, if we put autocommit off, through the program to control , only one commit is allowed.

1, we can set the autocommit

2, we can modify the MySQL configuration file my.cnf to close autocommit

init_connect= ' SET autocommit=0 ' #在mysqld里面加上这些内容

Other about MySQL transaction submission URLs:

http://blog.csdn.net/wenzi49312/article/details/8537727

MySQL Auto-commit