Description

This template monitors metrics like slow query count, create table commands, insert commands, droptable commands, drop database commands, 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