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

Restriction on bad SQL for server stability #470

Closed
ShiKaiWi opened this issue Dec 9, 2022 · 0 comments · Fixed by #494
Closed

Restriction on bad SQL for server stability #470

ShiKaiWi opened this issue Dec 9, 2022 · 0 comments · Fixed by #494
Labels
feature New feature or request

Comments

@ShiKaiWi
Copy link
Member

ShiKaiWi commented Dec 9, 2022

Describe This Problem

Currently, one SQL with no predicates querying on a very big table may cause large consumption of CPU and memory, leading to instability of server.

Proposal

We may need a module to do such things:

  • Based provided rules, prevent the execution of any SQL which may lead to instability of server;
  • Such rules are configurable, e.g. a rule for resolving the problem above may be called disable_query_without_predicate;

Additional Context

No response
@ShiKaiWi ShiKaiWi added the feature New feature or request label Dec 9, 2022
@ShiKaiWi ShiKaiWi mentioned this issue Dec 20, 2022
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
feature New feature or request
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

feat: support query limit by rule ShiKaiWi/ceresdb
1 participant
@ShiKaiWi