Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

see user / source host for queries and be able to filter/group by them

Description

Just an idea what could be improved - it would be great to see user and source host for queries and be able to filter by them in QAN.

Right now I see User Name field in QAN but it seems to be doing nothing (shows n/a and pmm-managed users). And do not see username field when looking in query details.

How to test

None

How to document

None

Smart Checklist

Activity

Mikhail V. Solovyev (test) March 19, 2020 at 7:45 AM

Can I have both perf schema and slow logs used in PMM? Will this work normally? Taking into account that our slow logs do not log all requests, but only really slow ones (more then 0.5s).
 

Roma Novikov January 22, 2020 at 10:28 PM

looks like you using Performance Schema as source.
Try {{ pmm-admin add mysql --query-source=slowlog ... }} and you should start getting:

  • Client Host - the Host where the request to DB was originated

  • User name - will be populated better.

The problem is - Perf Schema is not providing this information so we can't collect it. For Slow log it's much more information so we getting it and you can filter it as well

Details

Assignee

Reporter

Priority

Needs QA

Yes

Needs Doc

Yes

Affects versions

Smart Checklist

Created January 13, 2020 at 12:38 PM
Updated March 6, 2024 at 4:58 AM