New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
perf: 作业包含大量主机,执行作业请求响应时间过长 #1697
Labels
Comments
原因如果 jdbc 为设置rewriteBatchedStatements= false (默认), 那么即使是调用 Statement.executeBatch(), 也是逐个执行 SQL。关于rewriteBatchedStatements这个参数的介绍:
参考 |
wangyu096
changed the title
perf: 接口传入大量目标主机或含有大量主机的节点或动态分组时响应时间过长优化
perf: 作业包含大量主机,执行作业请求响应时间过长
Jun 28, 2023
wangyu096
added a commit
to wangyu096/bk-job
that referenced
this issue
Jun 29, 2023
wangyu096
added a commit
to wangyu096/bk-job
that referenced
this issue
Jun 29, 2023
wangyu096
added a commit
to wangyu096/bk-job
that referenced
this issue
Jun 30, 2023
wangyu096
added a commit
to wangyu096/bk-job
that referenced
this issue
Jun 30, 2023
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
快速执行接口传入的执行目标解析出的主机超过3k时,响应时间超过30s,导致某些超时参数设置较短的客户端超时。
导致超时的慢查询语句:
insert into
job_execute
.task_instance_host
(task_instance_id
,host_id
,ip
,ipv6
) values (?, ?, ?, ?)需要优化。
The text was updated successfully, but these errors were encountered: