1.打开开关
hava_statement_timeout
是否开启语jv执行超时
2.设置超时时间
用于服务端对select语句进行超时时间限制;
mysql5.6,max_statement_time(ms)
mysql5.7,max_execution_time(ms)
超过配置时间,mysql就终止select语句的执行,客户端抛异常:
query execution was interrupted,max_execution_time exceeded.
三种设置粒度:
(1)全局设置
set global max_execution_time=1000;
(2)对某个session设置
set session max_execution_time=1000;
(3)对某个语句设置
select max_execution_time=1000 sleep(10),a.*from test a;