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.

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

Manage slow queries / error queries #18

Open
Reid00 opened this issue Sep 24, 2021 · 5 comments
Open

Manage slow queries / error queries #18

Reid00 opened this issue Sep 24, 2021 · 5 comments
Assignees
Labels
type/feature req Type: feature request

Comments

@Reid00
Copy link

Reid00 commented Sep 24, 2021

Is your feature request related to a problem? Please describe.
After building Dashboard, there are some slow queries/ error queries show up. i want to locate at which services or which queries happened, but there are no any method as i known to debug.

Describe the solution you'd like
currently, no

Describe alternatives you've considered
currently no

Additional context
no

@Sophie-Xie Sophie-Xie transferred this issue from vesoft-inc/nebula Sep 29, 2021
@Sophie-Xie Sophie-Xie added the type/feature req Type: feature request label Sep 29, 2021
@kqzh
Copy link

kqzh commented Sep 29, 2021

You can try modify nebula-stats-exporter's config, give service a unique name, and then, build query to locate it, https://github.com/vesoft-inc/nebula-stats-exporter

@nianiaJR
Copy link
Contributor

You can try modify nebula-stats-exporter's config, give service a unique name, and then, build query to locate it, https://github.com/vesoft-inc/nebula-stats-exporter

I think what @Reid00 means is to find the slow queries. When he finds there are slow queries show in the chart, it's meaningful to find which query caused this.

It's nice suggestion, we'll research supporting this, thanks @Reid00

@nianiaJR
Copy link
Contributor

Is your feature request related to a problem? Please describe. After building Dashboard, there are some slow queries/ error queries show up. i want to locate at which services or which queries happened, but there are no any method as i known to debug.

Describe the solution you'd like currently, no

Describe alternatives you've considered currently no

Additional context no

I find that our ngql has supportted showing the list of all queries, which may help you get the slow quries. Here's the link:https://docs.nebula-graph.io/2.5.1/3.ngql-guide/7.general-query-statements/6.show/18.show-queries/#syntax

@Reid00
Copy link
Author

Reid00 commented Oct 14, 2021

i do some tests on v2.5.1. It seems that just can query the running queries, if the query finished, output empty.
In truly scenario, we cannot star at the slow queries. if queries can be logged to somewhere, may be more make sense.

image

@bazingame
Copy link

i do some tests on v2.5.1. It seems that just can query the running queries, if the query finished, output empty. In truly scenario, we cannot star at the slow queries. if queries can be logged to somewhere, may be more make sense.

image

Not supporting this feature until now.😅

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/feature req Type: feature request
Projects
None yet
Development

No branches or pull requests

5 participants