Description

This template monitors metrics like update commands, rollback commands, slow query count, aborted connects, active transactions, InnoDB buffer pool reads, slave status, streams open, disk temporary tables created, connected threads count, etc.

Prerequisites

The database you want to monitor should connect from the Gateway. Gateway Management profile should be added to the device. Database type credentials should be added against the device in the portal.

Metric Parameters

Metric Parameters
ParameterDescription
Frequency
  • Frequency is the interval in which you want to probe and collect metric data from the target device/resource
  • Frequency is defined in minutes (min).
  • Warning ThresholdIf the metric value satisfies the condition defined along with Warning Threshold value, then a notification is sent to the user.
    Critical ThresholdIf the metric value satisfies the condition defined along with Critical Threshold value, then a notification is sent to the user.
    AlertThe alert value can be set to either Yes or No. If it is Yes, then an alert message is sent to the user.

    Metrics

    mysql.update.commands

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of times UPDATE command has been executed.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Command Monitor
    Unitpsec

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.select.commands

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of times SELECT command has been executed.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Command Monitor
    Unitpsec

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.delete.commands

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of times Delete command has been executed.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Command Monitor
    Unitpsec

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.insert.commands

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of times Insert command has been executed
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Command Monitor
    Unitpsec

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.rollback.commands

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of times RollBack command has been executed
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Command Monitor
    Unitpsec

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.droptable.commands

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of times Drop Table command has been executed
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Command Monitor
    Unitpsec

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.dropuser.commands

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of times DROP USER command has been executed.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Command Monitor
    Unitpsec

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.dropdatabase.commands

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of times DROP DATABASE command has been executed
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Command Monitor
    Unitpsec

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.createtable.commands

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of times CREATE TABLE command has been executed
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Command Monitor
    Unitpsec

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.createuser.commands

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of times CREATE USER command has been executed
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Command Monitor
    Unitpsec

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.createdatabase.commands

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of times CREATE DATABASE command has been executed
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Command Monitor
    Unitpsec

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.slow.query.count

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionSlow Query Count
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Command Monitor
    Unitqpm

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.aborted.clients

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of connections that were aborted because the client died without closing the connection properly.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Connection Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.max.connections

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionMaximum Limit of Connections.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Connection Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.max.connections.connection_errors

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of connections refused due to internal server errors.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Connection Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.aborted.connects

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of failed attempts to connect to the MySQL server.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Connection Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.internal.connection.errors

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of connections refused due to internal errors in the server, such as failure to start a new thread or an out-of-memory condition.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Connection Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.ssl.client.connects

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of SSL connection attempts to an SSL-enabled master.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Connection Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.active.transactions

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionNumber of active transactions
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Connection Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.server.connections

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of connection attempts (successful or not) to the MySQL server.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Connection Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.innodb.data.pending.reads

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe current number of pending reads.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database innoDB Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.innodb.data.pending.writes

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe total number of data writes.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database innoDB Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.innodb.bufferpool.pagesfree

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of free pages in the InnoDB Buffer Pool.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database innoDB Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.innodb.bufferpool.pagestotal

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe total number of pages in the InnoDB Buffer Pool.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database innoDB Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.innodb.buffer_pool_reads

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of logical reads that InnoDB could not satisfy from the buffer pool, and had to read directly from the disk.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database innoDB Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.innodb.buffer_pool_read_requests

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of reads done to the InnoDB buffer pool.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database innoDB Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.innodb.buffer_pool_write_requests

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of writes done to the InnoDB buffer pool.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database innoDB Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.innodb.bufferpool.dirtypages

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe current number of dirty pages in the InnoDB buffer pool.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database innoDB Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.innodb.bufferpool.utilization

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe utilization of the InnoDB Buffer Pool shown as fraction
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database innoDB Monitor
    Unit%

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.innodb.data.reads

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe total number of data reads (OS file reads).
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database innoDB Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.innodb.data.writes

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe total number of data writes.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database innoDB Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.innodb.row.lock.waits

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of times operations on InnoDB tables had to wait for a row lock.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database innoDB Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.innodb.row.lock.time

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe total time spent in acquiring row locks for InnoDB tables, in milliseconds.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database innoDB Monitor
    Unitms

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.slave.status

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionProvides information about the configuration and status of the connection between the slave server and the master server.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Miscellaneous Monitor
    Unit

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical OperatorEQUALEnds with, ==, !=, >=, <=, >, <, In Range, Out of range, Equals, Not equals, Equals Ignore Case, Not Equals Ignore Case, Contains, Not contains, Regex match, Regex no match, In string list, Not in string list, In List, Not in list, Starts with
    Critical Threshold0User defined
    Critical Repeat Count11-12
    AlertYesYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.slave.seconds.behind.master

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of seconds that the slave SQL thread is behind processing the master binary log. A high number (or an increasing one) can indicate that the slave is unable to handle events from the master in a timely fashion.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Miscellaneous Monitor
    Unit

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning OperatorGREATER_THAN_EQUALEnds with, ==, !=, >=, <=, >, <, In Range, Out of range, Equals, Not equals, Equals Ignore Case, Not Equals Ignore Case, Contains, Not contains, Regex match, Regex no match, In string list, Not in string list, In List, Not in list, Starts with
    Warning Threshold10User defined
    Warning Repeat Count11-12
    Critical OperatorGREATER_THAN_EQUALEnds with, ==, !=, >=, <=, >, <, In Range, Out of range, Equals, Not equals, Equals Ignore Case, Not Equals Ignore Case, Contains, Not contains, Regex match, Regex no match, In string list, Not in string list, In List, Not in list, Starts with
    Critical Threshold20User defined
    Critical Repeat Count11-12
    AlertYesYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.system.uptime

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionSystem Uptime
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Miscellaneous Monitor
    Unitm

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertYesYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.streams.open

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of streams that are open (used mainly for logging).
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Miscellaneous Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.bytes.received

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of bytes received from all clients.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Network Monitor
    UnitBps

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.bytes.sent

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of bytes sent to all clients.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Network Monitor
    UnitBps

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysq.tmp.table.delta.util

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionTemporary table delta utilization.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Table Monitor
    Unit

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning OperatorGREATER_THAN_EQUALEnds with, ==, !=, >=, <=, >, <, In Range, Out of range, Equals, Not equals, Equals Ignore Case, Not Equals Ignore Case, Contains, Not contains, Regex match, Regex no match, In string list, Not in string list, In List, Not in list, Starts with
    Warning Threshold70User defined
    Warning Repeat Count11-12
    Critical OperatorGREATER_THAN_EQUALEnds with, ==, !=, >=, <=, >, <, In Range, Out of range, Equals, Not equals, Equals Ignore Case, Not Equals Ignore Case, Contains, Not contains, Regex match, Regex no match, In string list, Not in string list, In List, Not in list, Starts with
    Critical Threshold90User defined
    Critical Repeat Count11-12
    AlertYesYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysq.tmp.table.util

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionTemporary table utilization.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Table Monitor
    Unit

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning OperatorGREATER_THAN_EQUALEnds with, ==, !=, >=, <=, >, <, In Range, Out of range, Equals, Not equals, Equals Ignore Case, Not Equals Ignore Case, Contains, Not contains, Regex match, Regex no match, In string list, Not in string list, In List, Not in list, Starts with
    Warning Threshold70User defined
    Warning Repeat Count11-12
    Critical OperatorGREATER_THAN_EQUALEnds with, ==, !=, >=, <=, >, <, In Range, Out of range, Equals, Not equals, Equals Ignore Case, Not Equals Ignore Case, Contains, Not contains, Regex match, Regex no match, In string list, Not in string list, In List, Not in list, Starts with
    Critical Threshold90User defined
    Critical Repeat Count11-12
    AlertYesYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.temporary.files.created

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe rate of temporary files created by second.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Table Monitor
    Unitpsec

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.disk.temporarytables.created

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe rate of temporary tables created by second.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Table Monitor
    Unitpsec

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.full.table.scan.delta.util

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionFull table scan delta utilization.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Table Monitor
    Unit

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning OperatorGREATER_THAN_EQUALEnds with, ==, !=, >=, <=, >, <, In Range, Out of range, Equals, Not equals, Equals Ignore Case, Not Equals Ignore Case, Contains, Not contains, Regex match, Regex no match, In string list, Not in string list, In List, Not in list, Starts with
    Warning Threshold70User defined
    Warning Repeat Count11-12
    Critical OperatorGREATER_THAN_EQUALEnds with, ==, !=, >=, <=, >, <, In Range, Out of range, Equals, Not equals, Equals Ignore Case, Not Equals Ignore Case, Contains, Not contains, Regex match, Regex no match, In string list, Not in string list, In List, Not in list, Starts with
    Critical Threshold90User defined
    Critical Repeat Count11-12
    AlertYesYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.full.table.scan.util

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionFull table scan utilization.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Table Monitor
    Unit

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning OperatorGREATER_THAN_EQUALEnds with, ==, !=, >=, <=, >, <, In Range, Out of range, Equals, Not equals, Equals Ignore Case, Not Equals Ignore Case, Contains, Not contains, Regex match, Regex no match, In string list, Not in string list, In List, Not in list, Starts with
    Warning Threshold70User defined
    Warning Repeat Count11-12
    Critical OperatorGREATER_THAN_EQUALEnds with, ==, !=, >=, <=, >, <, In Range, Out of range, Equals, Not equals, Equals Ignore Case, Not Equals Ignore Case, Contains, Not contains, Regex match, Regex no match, In string list, Not in string list, In List, Not in list, Starts with
    Critical Threshold90User defined
    Critical Repeat Count11-12
    AlertYesYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysq.open.files.util

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionOpen files utilization
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Table Monitor
    Unit

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning OperatorGREATER_THAN_EQUALEnds with, ==, !=, >=, <=, >, <, In Range, Out of range, Equals, Not equals, Equals Ignore Case, Not Equals Ignore Case, Contains, Not contains, Regex match, Regex no match, In string list, Not in string list, In List, Not in list, Starts with
    Warning Threshold70User defined
    Warning Repeat Count11-12
    Critical OperatorGREATER_THAN_EQUALEnds with, ==, !=, >=, <=, >, <, In Range, Out of range, Equals, Not equals, Equals Ignore Case, Not Equals Ignore Case, Contains, Not contains, Regex match, Regex no match, In string list, Not in string list, In List, Not in list, Starts with
    Critical Threshold90User defined
    Critical Repeat Count11-12
    AlertYesYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.open.files

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of files that have been opened with my_open() (a mysys library function). Parts of the server that open files without using this function do not increment the count
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Table Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.open.tables

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of tables that have been opened with my_open().
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Table Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.table.locks_immediate

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of times that a request for a table lock could be granted immediately.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Table Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.connected.threads.count

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionConnected Threads count
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Threads Monitor
    Unit

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.created.threads

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of threads created to handle connections. If Threads_created is big, you may want to increase the thread_cache_size value. The cache miss rate can be calculated as Threads_created/Connections.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Threads Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.threads.cached.count

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of threads in the thread cache.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Threads Monitor
    Unit

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.running.threads

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe number of threads that are not sleeping.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Threads Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    mysql.threads.stacksize

    Metric Details

    Metric Details
    Applicable forCLOUD_PAAS_DB
    DescriptionThe stack size for each thread. Many of the limits detected by the crash-me test are dependent on this value.
    CategoryApplication
    Collector TypeGateway
    Monitor NameAdvanced Cloud MySQL Database Threads Monitor
    Unit

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph