mysqlconfigurer icon indicating copy to clipboard operation
mysqlconfigurer copied to clipboard

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

Open drupaladmin opened this issue 10 months ago • 2 comments

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 avatar Apr 13 '24 07:04 drupaladmin

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 avatar Apr 15 '24 16:04 drupaladmin

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 avatar Apr 16 '24 17:04 drupaladmin

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

drupaladmin avatar May 15 '24 11:05 drupaladmin