lp:~sergei.glushchenko/percona-server/5.5-ps-blueprint-scalability-metrics

Branch merges

Propose for merging

No branches dependent on this one.

Merged into lp:percona-server/5.5 at revision 638

Alexey Kopytov (community): Approve on 2014-03-16

Diff: 688 lines (+639/-0)

8 files modified

mysql-test/include/have_scalability_metrics_plugin.inc (+21/-0)
mysql-test/include/plugin.defs (+1/-0)
mysql-test/r/scalability_metrics.result (+65/-0)
mysql-test/t/scalability_metrics-master.opt (+1/-0)
mysql-test/t/scalability_metrics.test (+81/-0)
plugin/scalability_metrics/CMakeLists.txt (+17/-0)
plugin/scalability_metrics/scalability_metrics.c (+451/-0)
sql/item_func.cc (+2/-0)

api

Related source package recipes

No recipes using this branch. (?)

Create packaging recipe

Related snap packages

Related bugs

Related blueprints

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_CLASS class).
MYSQL_AUDIT_GENERAL_LOG with command 'Query' and 'Execute' is considered a
query start event
MYSQL_AUDIT_GENERAL_RESULT and MYSQL_AUDIT_GENERAL_ERROR are considered a
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