SELECT /*+ MAX_EXECUTION_TIME(1000) */ status, count(*) FROM articles GROUP BY status ORDER BY status; //sql中设置注释表示超时
SET SESSION MAX_EXECUTION_TIME=2000; //设置会话过期
SET GLOBAL MAX_EXECUTION_TIME=2000; //设置全局执行超时
ERROR 3024 (HY000): Query execution was interrupted, maximum statement execution time exceeded
mysql5.7.22 sql查询超时设置
最新推荐文章于 2024-08-16 10:39:25 发布