MySQL transaction-isolation参数的设置

1.在my.cnf中的【mysqld】部分添加:

[mysqld]

transaction-isolation = read-committed

2.重启mysql数据库

mysql> show variables like ‘tx%’;
+—————+—————-+
| Variable_name | Value          |
+—————+—————-+
| tx_isolation  | READ-COMMITTED |
+—————+—————-+

摘自『https://anmh.wordpress.com/2010/06/30/mysql%EF%BC%9Atransaction-isolation%E5%8F%82%E6%95%B0%E7%9A%84%E8%AE%BE%E7%BD%AE/』

No Comments

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

粤ICP备15062915号-1