oracle会话关闭自动提交,MariaDB 关闭 autocommit 功能

MysqL在执行一句数据库操作命令的时候，通常都是自动提交的。常用引擎下有两种： MyIsam和InnoDB，MyIsam是不支持事务处理的，但InnoDB支持，但InnoDB在不开启事务处理的情况下执行语句也会自动提交，因为MysqL有一个机制控制，那就是自动提交机制，在默认情况下是开启的，我们在开发过程中有些场景需要关闭自动提交来保证数据的一致性。https://www.cndba.cn/dave/article/2632

关闭方式有两种，一种是在控制台下命令执行，一种是在Mysql的配置文件中关闭。*

1 会话级关闭自动提交

mysql> show variables like 'autocommit';

+---------------+-------+

| Variable_name | Value |

+---------------+-------+

| autocommit | ON |

+---------------+-------+

1 row in set (0.00 sec)

mysql> set autocommit=0;

Query OK, 0 rows affected (0.00 sec)

mysql> show variables like 'autocommit';

+---------------+-------+

| Variable_name | Value |

+---------------+-------+

| autocommit | OFF |

+---------------+-------+

1 row in set (0.00 sec)

2 配置文件关闭

通过修改配置文件my.cnf文件，通过vim编辑my.cnf文件，在[mysqld]添加:

autocommit=0

然后重启mysql服务生效。https://www.cndba.cn/dave/article/2632https://www.cndba.cn/dave/article/2632

[root@http://www.cndba.cn/dave cndba]# service mysql restart

shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory

chdir: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory

Shutting down MySQL.. [ OK ]

Starting MySQL.180130 23:33:39 mysqld_safe Logging to '/mysql/data/Dave.err'.

180130 23:33:39 mysqld_safe Starting mysqld daemon with databases from /mysql/data

[ OK ]

[root@http://www.cndba.cn/dave cndba]#

[root@http://www.cndba.cn/dave mysql]# mysql -uroot -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or /g.

Your MySQL connection id is 12

Server version: 5.5.5-10.2.12-MariaDB-log MariaDB Server

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '/h' for help. Type '/c' to clear the current input statement.

mysql> show variables like 'autocommit';

+---------------+-------+

| Variable_name | Value |

+---------------+-------+

| autocommit | OFF |

+---------------+-------+

1 row in set (0.01 sec)

https://www.cndba.cn/dave/article/2632https://www.cndba.cn/dave/article/2632

https://www.cndba.cn/dave/article/2632

https://www.cndba.cn/dave/article/2632https://www.cndba.cn/dave/article/2632

版权声明：本文为博主原创文章，未经博主允许不得转载。