Percona Server with XtraDB

Show distribution of query response time

Registered by Vadim Tkachenko on 2010-05-13

After talk with Baron, I've got idea to implement statistics on query response time.
statistic will be shown in INFORMATION_SCHEMA.QUERY_RESPONSE_TIME

statistic is

TIME | count
0.001 | 450
0.01 | 12023
0.1 | 122387
1 | 54

where line with TIME=1 shows COUNT of queries with execution Q_exec_time , and 1s<= Q_exec_time< 0.1s
line with TIME=0.1 is count of queries with 0.1s <= Q_exec_time < 0.01s
etc

- We need a way to FLUSH QUERY_RESPONSE_TIME, can we use TRUNCATE TABLE INFORMATION_SCHEMA.QUERY_RESPONSE_TIME for that ?

Blueprint information

Status:
Complete
Approver:
Percona developers
Priority:
Medium
Drafter:
Vadim Tkachenko
Direction:
Needs approval
Assignee:
Oleg Tsarev
Definition:
New
Series goal:
None
Implementation:
Implemented
Milestone target:
milestone icon 5.1-12.0
Started by
Oleg Tsarev on 2010-06-14
Completed by
Oleg Tsarev on 2010-07-07

Related branches

Sprints

Whiteboard

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.