Query Response Time not always work on replication queries

Bug #712393 reported by Oleg Tsarev
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
Low
Oleg Tsarev
5.1
Fix Released
Undecided
Oleg Tsarev
5.5
Fix Released
Low
Oleg Tsarev

Bug Description

This is usability and documentation bug

query response time (patch response_time_distribtuion.patch) doesn't count queries on slave (queries from SQL_Slave_Thread) without
log_slow_slave_statements=ON (patch slow_extended.patch)

To QA, following things:
1) Should or shouldn't QUERY_RESPONSE_TIME work when log_slow_slave_statements=OFF (notice: query_response_time implemented thought time passed to slow_query_log)
2) Create test-case for your decision
3) Check actual documentation and reflect this changes

Related branches

Oleg Tsarev (tsarev)
Changed in percona-server:
assignee: nobody → Valentine Gostev (core-longbow)
Revision history for this message
Stewart Smith (stewart) wrote :

Assigning to me to track advice from Percona consultants as to what should be correct behavior.

Changed in percona-server:
assignee: Valentine Gostev (core-longbow) → Stewart Smith (stewart)
Stewart Smith (stewart)
Changed in percona-server:
assignee: Stewart Smith (stewart) → nobody
Revision history for this message
Stewart Smith (stewart) wrote :

Peter says:

 I Think it is good to be able to have it on and off.

 I see cases when i would like to only see the user traffic (which someone is
 really waiting for)
 in other cases, both slave traffic and user traffic may be of the interest.

Revision history for this message
Stewart Smith (stewart) wrote :

So, this bug for tracking adding proper test cases, and https://bugs.launchpad.net/percona-server/+bug/785714 for tracking documentation of behavior.

Changed in percona-server:
importance: Undecided → Low
status: New → Triaged
assignee: nobody → Valentine Gostev (longbow)
Oleg Tsarev (tsarev)
Changed in percona-server:
assignee: Valentine Gostev (longbow) → Oleg Tsarev (tsarev)
status: Triaged → In Progress
Oleg Tsarev (tsarev)
Changed in percona-server:
status: In Progress → Fix Committed
Revision history for this message
Oleg Tsarev (tsarev) wrote :
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1846

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers