事务

show VARIABLES like ‘%general_log%’

set global general_log=”off”;

mybatis实现事务

执行失败

1
2
3
4
5
6
7
8
2018-08-21T15:07:24.809453Z	   70 Query	SET autocommit=0
2018-08-21T15:07:24.814319Z	   70 Query	select * from user_account
2018-08-21T15:07:24.821225Z	   70 Query	select * from user_account
2018-08-21T15:07:24.823496Z	   70 Query	select @@session.transaction_read_only
2018-08-21T15:07:24.823972Z	   70 Query	INSERT INTO usercenter.user_account (user_name,id,user_id) VALUE ('fzz','10','1001')
2018-08-21T15:07:24.825636Z	   70 Query	rollback
2018-08-21T15:07:24.825907Z	   70 Query	SET autocommit=1
2018-08-21T15:07:24.826190Z	   70 Query	select @@session.transaction_read_only

执行成功

1
2
3
4
5
6
7
8
2018-08-21T15:30:17.288694Z	   80 Query	SET autocommit=0
2018-08-21T15:30:17.289481Z	   80 Query	select * from user_account
2018-08-21T15:30:17.291729Z	   80 Query	select * from user_account
2018-08-21T15:30:17.293055Z	   80 Query	select @@session.transaction_read_only
2018-08-21T15:30:17.293494Z	   80 Query	INSERT INTO usercenter.user_account (user_name,id,user_id) VALUE ('fzz','6','1001')
2018-08-21T15:30:17.296491Z	   80 Query	commit
2018-08-21T15:30:17.297089Z	   80 Query	SET autocommit=1
2018-08-21T15:30:17.297414Z	   80 Query	select @@session.transaction_read_only
1
2
3
4
5
6
7
A事务insert

B事务insert

A事务update

B事务update产生死锁

事务隔离级别会影响死锁的发生的可能性么？

文章链接 https://fangzongzhou.github.io/2018/08/21/计算机/技术文档/MYSQL/事务/