悲观事务和乐观事务模型

  1. 查询事务模式
# 方式一:
mysql> show global variables like '%tidb_txn_mode%';
+---------------+-------------+
| Variable_name | Value       |
+---------------+-------------+
| tidb_txn_mode | pessimistic |
+---------------+-------------+
1 row in set (0.00 sec)

# 方式二:
mysql> select @@tidb_txn_mode;
+-----------------+
| @@tidb_txn_mode |
+-----------------+
| pessimistic     |
+-----------------+
1 row in set (0.00 sec)
  1. 修改事务模式
SET GLOBAL tidb_txn_mode ='pessimistic';
1 个赞