[MXS-3557] Track average query duration for services and servers Created: 2021-05-19  Updated: 2022-03-23  Resolved: 2021-07-16

Status: Closed
Project: MariaDB MaxScale
Component/s: Core
Affects Version/s: None
Fix Version/s: 6.2.0

Type: Task Priority: Major
Reporter: markus makela Assignee: Niclas Antti
Resolution: Fixed Votes: 1
Labels: None

Sprint: MXS-SPRINT-133, MXS-SPRINT-134, MXS-SPRINT-135

 Description   

Currently the average query duration is tracked for servers only when a readwritesplit service uses it and is configured with slave_selection_criteria=ADAPTIVE_ROUTING. In addition, only queries classified as reads are tracked.

As query latency is a good metric for measuring the overall performance of a cluster, it should be tracked both at the service level as well as on the server level. Initially, the average should take into account all queries regardless of whether they are writes or reads.

The new statistic should be separate from the existing adaptive_avg_select_time statistic exposed in the servers REST API resource. This will keep the semantics of the existing statistic the same as it was in older releases.



 Comments   
Comment by Ivan Zlatoustov (Inactive) [ 2022-03-23 ]

Hi nantti what is the name of the new metric that counts all queries?

Generated at Thu Feb 08 04:22:16 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.