- 查询事务模式
# 方式一:
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)
- 修改事务模式
SET GLOBAL tidb_txn_mode ='pessimistic';