Make different presentation for unavailable metrics - FE

Description

The problem: 

When users trying to change Metric it's usually a lot of values and users need to know e lot about metrics. it's sometimes easy to select metric you  don't  have in the current selection 

 

User Story: 

As PMM user, I  need to see metrics which are not present in the current data set, so that i can easily see what's available for selection  

 

Proposed solution

1) have Metrics in the list sorted by "availability" and next by  A-Z  

2) Use different  "color"  (UX needed ) for presenting Available and unavailable metrics 

 

Suggested implementation:

 -  Extend API with an endpoint that returns a list all metrics with an indication which is available for given time range and selected filters.

 - Implement in qan-api2 method to select available metrics:

 

SELECT sum(m_query_time_cnt) AS query_time, sum(m_lock_time_cnt) AS lock_time, sum(m_rows_sent_cnt) AS rows_sent, sum(m_docs_returned_cnt) AS docs_returned .... FROM metrics WHERE 1 LIMIT 100┌─query_time─┬─lock_time─┬─rows_sent─┬─docs_returned─┐ │ 8848420 │ 8740021 │ 8827405 │ 0 │ └────────────┴───────────┴───────────┴───────────────┘

 

[UI part] UI can cancel the query if it runs longer then 3 sec and shows metrics that they already have with a note:

get only available metrics takes too long - show all queries

Or 

1) Selected metrics taking too long - showing all
2) Slow response from selected metrics - showing all
3) Your selected metrics are slow to respond - showing all instead

How to test

None

How to document

None

Attachments

3
  • 03 Aug 2020, 02:58 PM
  • 03 Aug 2020, 02:58 PM
  • 03 Aug 2020, 02:58 PM

Smart Checklist

Activity

Show:

Alexander Blinkov August 3, 2020 at 3:00 PM

This is the frontend part of the issue, was cloned from https://jira.percona.com/browse/PMM-6069

Details

Assignee

Reporter

Priority

Needs QA

Yes

Needs Doc

Yes

Story Points

Smart Checklist

Created August 3, 2020 at 2:58 PM
Updated November 13, 2024 at 8:30 AM

Flag notifications