New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Mycat2设置事务隔离级别不生效 #797

Open

1a23-pangqiu opened this issue May 30, 2023 · 0 comments

1a23-pangqiu commented May 30, 2023 •

edited

Loading

Mycat2-1.22
Mysql隔离级别是RC, Mycat是RR, 两者不统一, 更改Mycat事务隔离级别不生效, 如下:

配置用户

{
	"dialect":"mysql",
	"ip":null,
	"password":"123456",
	"transactionType":"proxy",
	"username":"root",
        "isolation":2
}

isolation
设置初始化的事务隔离级别
READ_UNCOMMITTED:1
READ_COMMITTED:2
REPEATED_READ:3,默认
SERIALIZABLE:4

重启Mycat之后查询事务级别还是RR, 不是RC

The text was updated successfully, but these errors were encountered:

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment