首页  编辑  

只读查询取消Table lock

Tags: /MySQL/   Date Created:

下面这句取消table lock:

       SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ;

下面这句恢复默认的MySQL MYISAM引擎的加锁级别:

       SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ ;