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

Slowest query is not showing the full query when I select the Inspect button. #291

Closed
drupaladmin opened this issue Apr 13, 2024 · 3 comments · Fixed by #304
Closed

Slowest query is not showing the full query when I select the Inspect button. #291

drupaladmin opened this issue Apr 13, 2024 · 3 comments · Fixed by #304

Comments

@drupaladmin
Copy link
Contributor

Hi, I'm checking out the new Query Analytics feature, which is very exciting to see, and in what is showing as our slowest query is not showing the full query when I select the Inspect button. I tried it with one of the smaller queries that show up and do see the query...but then when I switch to other queries they're showing that original query still and not updating to reflect the one I currently selected.

@drupaladmin
Copy link
Contributor Author

In Query Analytic, after clicking on "Inspect" the Modal open.
Expected: I see the full query display on the textbox
Result: The textbox with the query is empty

@drupaladmin
Copy link
Contributor Author

We've fixed the issue.

The root cause of the issue was sql-formatter script which failed because there were too long queries which were shortened according limitations - 1024 character per query.

Now you could see in the Dashboard shortened queries.

Please increase these variables to 2048
max_digest_length
performance_schema_max_digest_length

We're going to add them to Settings.

@drupaladmin
Copy link
Contributor Author

We added new setting Max Query Length to set these variables from web interface. After you set it, Releem automatically add new variables to configuration.

image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant