Releem / mysqlconfigurer

Releem is a simple MySQL tuning tool to improve database performance and reduce servers costs.
https://releem.com
GNU General Public License v3.0
256 stars 27 forks source link

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

Closed drupaladmin closed 4 months ago

drupaladmin commented 5 months ago

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 commented 5 months ago

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 commented 5 months ago

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 commented 4 months ago

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