Long queries

Description

There several problems with Long queries: 

  • Sometimes the default  length 1024  2048 is too small 

  • Truncated Queries must be properly presented on UI and user can understand why Explain or other features not working 

  • User need to be able increase the size  for query example/ fingerprint 

  • TBD 

Notes

We truncate long query in pmm-agent:
https://github.com/percona/pmm-agent/blob/main/utils/truncate/query.go

How to test

None

How to document

None

Smart Checklist

Activity

Show:

Michael Coburn March 7, 2022 at 10:46 PM

Hi team - what would it take to get this Epic into the backlog?  Given we're using Clickhouse I would love to see us make either the limit configurable or otherwise set it very large such as 10,000 characters.  Customers for example often use frameworks to build their SQL queries and thus have very little control over the length of the query string. Especially the framework Hibernate is known to create some gnarly queries which are easily overflowing the 2048 limit.

Would love to see us take action in 2022 on this!!

Details

Assignee

Reporter

Priority

Components

Epic Name

Smart Checklist

Created May 28, 2021 at 2:44 PM
Updated March 6, 2024 at 2:39 AM