MySQL Disable autocommit

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. Set the autocommit via set

Mysql> set global init_connect="set autocommit=0"; //Prompt you to set up with a higher-privileged financial account

Mysql> set autocommit=0;

Mysql> SELECT @ @autocommit; //Check the settings of the autocommit

2. Modify the MySQL configuration file my.cnf

[Mysqld]

init_connect=' SET autocommit=0 ' //Add these to mysqld

With the second approach, one thing to note is that the permissions of the MySQL user cannot be greater than the permissions of the user who started the MySQL, otherwise init_connect= ' SET autocommit=0 ' will not function at all and will not report any errors

MySQL Disable autocommit