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

Add problematic query search method #6

Closed
altmannmarcelo opened this issue Apr 3, 2024 · 0 comments
Closed

Add problematic query search method #6

altmannmarcelo opened this issue Apr 3, 2024 · 0 comments
Labels
enhancement New feature or request

Comments

@altmannmarcelo
Copy link
Collaborator

Add an option to list the top X problematic queries based on a criteria. Possible values are:

  • count_star - number of times the query ran
  • sum_time - total time of all executions
  • sum_rows_sent - total rows sent
  • avg_time - time to run in avg (sum_time/count_star)
@altmannmarcelo altmannmarcelo added the enhancement New feature or request label Apr 3, 2024
altmannmarcelo added a commit that referenced this issue Sep 6, 2024
@altmannmarcelo
Refactor and Query Discovery Mode
ff95770 
- Refactor the code to make it more readable and maintainable. Added
    a new module `proxysql` to handle all the proxysql related
    functionalities.
- Refactor the code to use the `query` module to handle all the
    query discovery related functionalities.

- Added Query Discovery configuration. Now users can specify the
    query discovery mode in the configuration file. The set of rules
    to discover the queries are defined in the README.md file.

Closes: #6
altmannmarcelo added a commit that referenced this issue Sep 6, 2024
@altmannmarcelo
Refactor and Query Discovery Mode
ee1c7f9 
- Refactor the code to make it more readable and maintainable. Added
    a new module `proxysql` to handle all the proxysql related
    functionalities.
- Refactor the code to use the `query` module to handle all the
    query discovery related functionalities.

- Added Query Discovery configuration. Now users can specify the
    query discovery mode in the configuration file. The set of rules
    to discover the queries are defined in the README.md file.

Closes: #6
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@altmannmarcelo