Percona Server with XtraDB

Add times to counters in SHOW STATUS

Registered by Vadim Tkachenko on 2010-04-20

(proposed by Baron)

Simply adding timers and sizes to the existing counters.
The storage engine API would be the most helpful thing; timing for file
accesses would be the next thing. So for example, if you do

SHOW STATUS LIKE 'Handler%';

You should see Handler_write, Handler_write_time, Handler_write_bytes
(optional).

This would already be better than the Performance Schema in my opinion!
I think we should avoid gettimeofday and use clock_gettime instead for
high-resolution low-overhead timing. I think this is more important
and easier than the ring buffer of SQL statements.

After adding this for the Handler calls, I would suggest adding it for
most or all of the other counters.

Blueprint information

Status:
Not started
Approver:
None
Priority:
Undefined
Drafter:
Vadim Tkachenko
Direction:
Needs approval
Assignee:
None
Definition:
Discussion
Series goal:
None
Implementation:
Unknown
Milestone target:
None

Related branches

Sprints

Whiteboard

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.