Skip to content
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.

Sign up for GitHub

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

Jump to bottom

对于增量场景的智能扫描（原：审核任务）应该提供可增量审核的方式 #687

Closed
sjjian opened this issue Jul 21, 2022 · 1 comment
Closed

对于增量场景的智能扫描（原：审核任务）应该提供可增量审核的方式 #687

sjjian opened this issue Jul 21, 2022 · 1 comment
Assignees
@ColdWaterLW
Labels
ee the problem for Enterprise Edition feature
Milestone
v1.2207.0

Comments

@sjjian
Copy link
Member

sjjian commented Jul 21, 2022

背景

对于慢日志，tidb 审计日志扫描类的审核，由于scanner使用的是增量扫描日志文件来实时提交sql到sqle，那么存在一个问题，即当某个存在问题的sql被修复后sqle内依然会对该sql进行审核，且目前无法避免掉。

方案

提供一个智能扫描任务的特有参数令sqle可以仅审核最近某段时间内的sql，并输出审核报告。

不足

当前的sql统计信息（sql语句池）内依然会存在该sql，后续可能通过其他方式处理。可能是页面提供手动关闭并说明原因。
@sjjian sjjian added ee the problem for Enterprise Edition feature labels Jul 21, 2022
@sjjian sjjian added this to the v1.2207.0 milestone Jul 21, 2022
@sjjian sjjian changed the title 对于增量场景的智能扫描应该提供可增量审核的方式 对于增量场景的智能扫描（原：审核任务）应该提供可增量审核的方式 Jul 21, 2022
@ColdWaterLW ColdWaterLW mentioned this issue Jul 22, 2022
Merged
@ColdWaterLW ColdWaterLW mentioned this issue Jul 22, 2022
Open
@sjjian sjjian closed this as completed Jul 22, 2022
@ColdWaterLW
Copy link
Collaborator

image
image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@ColdWaterLW ColdWaterLW

Labels
ee the problem for Enterprise Edition feature
Projects
None yet
Milestone
v1.2207.0
Development

No branches or pull requests
2 participants
@sjjian @ColdWaterLW