Metrics for scalability measurement

Percona Server has implemented extra scalability metrics in 5.5.37-35.0. These metrics allow using Little’s Law, queueing theory, and Universal Scalability Law to gain insights into server performance. This feature is implemented as a plugin.

Installation

Scalability Metrics plugin is shipped with Percona Server, but it is not installed by default. To enable the plugin you must run the following command:

INSTALL PLUGIN scalability_metrics SONAME 'scalability_metrics.so';

You can check if the plugin is loaded correctly by running:

SHOW PLUGINS;

The plugin should be listed in the output:

+--------------------------------+----------+--------------------+------------------------+---------+
| Name                           | Status   | Type               | Library                | License |
+--------------------------------+----------+--------------------+------------------------+---------+
...
| scalability_metrics            | ACTIVE   | AUDIT              | scalability_metrics.so | GPL     |
+--------------------------------+----------+--------------------+------------------------+---------+

System Variables

variable scalability_metrics_control
Version Info:
Command Line:

Yes

Scope:

Global

Dynamic:

Yes

Variable Type:

String

Default Value:

OFF

Values :

OFF, ON, RESET

This variable can be used to enable and disable the collection of metrics for scalability measurement. By setting the value to RESET all counters will be reset while continuing to count metrics.

Status Variables

variable scalability_metrics_elapsedtime
Version Info:
Variable Type:

Numeric

This status variable shows total time elapsed since metrics collection was started.

variable scalability_metrics_queries
Version Info:
Variable Type:

Numeric

This status variable shows number of completed queries since metrics collection was started.

variable scalability_metrics_concurrency
Version Info:
Variable Type:

Numeric

This status variable shows number of queries currently executed.

variable scalability_metrics_totaltime
Version Info:
Variable Type:

Numeric

This status variable shows total execution time of all queries, including the in-progress time of currently executing queries, in microseconds (ie. if two queries executed with 1 second of response time each, the result is 2 seconds).

variable scalability_metrics_busytime
Version Info:
Variable Type:

Numeric

This counter accounts the non-idle server time, that is, time when at least one query was executing.

Version Specific Information

  • 5.5.37-35.0 Scalability Metrics plugin has been implemented in Percona Server.
Percona Server
Call Us
+1-888-316-9775 (USA - Sales)
+1-208-473-2904 (USA - Sales)
+44-208-133-0309 (UK - Sales)
0-800-051-8984 (UK - Sales)
0-800-181-0665 (GER - Sales)
+1-877-862-4316 (Emergency)
+1-855-55TRAIN (Training)
+1-925-271-5054 (Training)

Table Of Contents

Previous topic

Thread Based Profiling

Next topic

Shared Memory Buffer Pool

This Page



© Copyright Percona LLC and/or its affiliates 2009-2014.
Except where otherwise noted, this documentation is licensed under the following license:
CC Attribution-ShareAlike 2.0 Generic
Created using Sphinx 1.1.3.
This documentation is developed in Launchpad as part of the Percona Server source code.
If you spotted innacuracies, errors, don't understood it or you think something is missing or should be improved, please file a bug.
]]>