Created by Sergei Glushchenko on 2013-06-05 and last modified on 2014-02-09
Get this branch:
bzr branch lp:~sergei.glushchenko/percona-server/5.5-ps-blueprint-scalability-metrics
Only Sergei Glushchenko can upload to this branch. If you are Sergei Glushchenko please log in for upload directions.

Branch merges

Related bugs

Related blueprints

Branch information

Recent revisions

461. By Sergei Glushchenko on 2014-02-09

Plugin for scalability metrics.
This is an audit plugin which provides following status variables
once loaded and enabled:
- scalability_metrics_elapsedtime - total time elapsed since starting point
- scalability_metrics_queries - number of completed queries since starting point
- scalability_metrics_concurrency - number of queries currently executed
- scalability_metrics_totaltime - total execution time of all queries
- scalability_metrics_busytime - server's total busy time
time is counted in microseconds.
There is also the global control variable named scalability_metrics_control
with possible values ON, OFF, RESET.
Setting the value to ON enables counting of metrics. Setting it to OFF disables
counting. By setting the value to RESET one can reset counters (status
variables) while continuing to count metrics.

Notes on implementation.
Three types of notifications are used to count these metrics (all three are of
MYSQL_AUDIT_GENERAL_LOG with command 'Query' and 'Execute' is considered a
query start event
query end event
Statistics calculated for each THD and stored in data structure
associated with THD. The only synchronization point is the atomic
variable used to track number of currently running queries. It is
used for the purpose of calculating server busy time. Once
variable becomes non-zero we start tracking busy time, once it
becomes zero, we stop doing it.

460. By <email address hidden> on 2013-02-28

Merge lp:~percona-core/percona-server/release-5.5.29-30.0

459. By <email address hidden> on 2013-02-27

Merge lp:~akopytov/percona-server/bug1123921

458. By <email address hidden> on 2013-02-27

Merge lp:~akopytov/percona-server/bug1132350

457. By <email address hidden> on 2013-02-27

Merge lp:~akopytov/percona-server/bug1132351

456. By <email address hidden> on 2013-02-27

Empty merge from Percona Server 5.1

455. By <email address hidden> on 2013-02-27

Empty merge from Percona Server 5.1

454. By <email address hidden> on 2013-02-26

Merge lp:~hrvojem/percona-server/rn-5.5.29-30.0-fix

453. By <email address hidden> on 2013-02-26

Merge lp:~akopytov/percona-server/bug1123915

452. By <email address hidden> on 2013-02-26

Merge lp:~akopytov/percona-server/bug1130655

Branch metadata

Branch format:
Branch format 7
Repository format:
Bazaar repository format 2a (needs bzr 1.16 or later)
Stacked on:
This branch contains Public information 
Everyone can see this information.