1. 关于事务的

1.1 查看事务的隔离接级别

select @@transaction_isolation;

1.2 设置事务的隔离级别

set transaction_isolation='read-uncommitted';

2. 关于锁的

2.1 用共享锁的方式去查询

select * from account where id = 1 lock in share mode;

2.2 用排它锁的方式去查询

select * from account where id = 1 for update;