可以通过命令行设置全局或会话的隔离级别。 或重新启动并禁用会话的set [ session ] transactionisolationlevel { read uncommitted } repeatable read { read }
具体命令#设置全局隔离级别
setglobaltransactionisolationlevelrepeatableread;
setglobaltransactionisolationlevelreadcommitted;
setglobaltransactionisolationlevelreaduncommitted;
setglobaltransactionisolationlevelserializable;
#设置会话隔离级别
setsessiontransactionisolationlevelrepeatableread;
setsessiontransactionisolationlevelreadcommitted;
setsessiontransactionisolationlevelreaduncommitted;
setsessiontransactionisolationlevelserializable;
使用配置文件设置隔离级别[mysqld]
传输-隔离=可移除读取
传输-隔离=读取-已提交
传输-隔离=读取-未确认
翻译-隔离=序列化
查看隔离级别select @ @ global.transaction _ isolation
select @ @ session.transaction _ isolation
show variables like '%iso% ';