The Wayback Machine - https://web.archive.org/web/20201110183632/https://github.com/vitessio/vitess/issues/6177
Skip to content

/ vitess

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

Jump to bottom

Support configurable 'slow query' detection for vtgate #6177

Open
dtestVC opened this issue May 13, 2020 · 1 comment
Open

Support configurable 'slow query' detection for vtgate #6177

dtestVC opened this issue May 13, 2020 · 1 comment
Labels
Good First Issue Type: Enhancement

Comments

@dtestVC
Copy link

@dtestVC dtestVC commented May 13, 2020 •
edited

Feature Description

MySQL has the ability to configure when to log slow queries with the long_query_time option.

This request is to add similar support for vtgate that will allow vitess admins to configure what they determine are slow queries to be flagged as 'slow'. MySQL uses the SERVER_QUERY_WAS_SLOW flag to indicate this and update statistics.

Use Case(s)

  • provide vtgate level statistics about slow queries
  • filter for logging only slow queries
@indera-shsp
Copy link

@indera-shsp indera-shsp commented Nov 9, 2020 •
edited

This would be a nice addition.

Could someone post a an implementation sketch (where to start)?
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Good First Issue Type: Enhancement
Projects
None yet
Milestone
No milestone
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
3 participants
@morgo @indera-shsp @dtestVC
You can’t perform that action at this time.