Amazon MariaDB Database

Available Metrics

Possible metric types that can be tracked on a given resource.

Metric Type Data Type Description
AggregatedMetric
Object
Allows for aggregating existing metrics over a period of time. Useful for running sums or averages; also for extracting single data item from collection-based metrics
AmazonCloudWatchMetric
Double
Tracks Amazon CloudWatch metrics using latest AWS API - more info is here.
DatabaseActiveSessionCount
Double
Tracks the number of open sessions for the given database.
DatabaseMySqlQueries
Double
Tracks the number of statements executed by the server. This includes only statements sent to the server by clients and not statements executed within stored procedures.
DatabaseMySqlQueryErrors
Double
Tracks count of queries executed with error.
DatabaseMySqlReads
Double
Tracks the number of SELECT statements.
DatabaseMySqlUtilization
Double
Tracks various database statistics such as number of connections, performance metrics, etc.
DatabaseMySqlWrites
Double
Tracks the number of INSERT, UPDATE and DELETE statements.
DatabaseSize
Double
Tracks the size of the database in megabytes.
DatabaseSqlNumeric
Double
Tracks numeric value from custom user-defined SQL statement.
DatabaseSqlQuery
Object[]
Tracks a table-based collection of data retrieved via user-defined SQL statement.
DerivedMetric
Double
Allows for deriving new metrics from existing ones. Useful for combining existing metrics together or for multiplying metrics by a factor
LinkedMetric
Object
Allows for tracking of metrics from other resources. Useful when it is important to evaluate metrics from different resources side-by-side
ResourceStatus
String
Tracks overall status of the resource. This is an important metric as it is used to drive Uptime reports. Possible values: Ready, Down, Unknown and in some cases Stopped
ResponseTime
Double
Measures time to connect to resource

Available Commands

Possible commands that can be executed on a given resource. Ultimate subscription is required.

Command Type Description
WebRequest Runs custom WebRequest to specified URL

Default Templates

CloudMonix provided default monitoring templates.

Pre-configured Metrics

Metric Name Metric Type Description
ConnectionsActive DatabaseActiveSessionCount Tracks number of open connections to the database
Cpu AmazonCloudWatchMetric Average value of CPU utilization for the monitored SQL Amazon database
ErrorsCount DatabaseMySqlQueryErrors Count of executed queries with error
QueriesCount DatabaseMySqlQueries Count of executed statements (sent by client)
ReadIOPS AmazonCloudWatchMetric Tracks Read IOPS of current database instance
ReadsCount DatabaseMySqlReads Number of SELECT statements
ResponseTime ResponseTime Tracks resource's response time. Metric measures how long it took to open an active connection to MySql database in milliseconds
Size DatabaseSize Tracks database size in MBs
Status ResourceStatus Tracks the overall readiness status of the monitored resource. Possible values are: Ready, Down, Stopped and Unknown
WriteIOPS AmazonCloudWatchMetric Tracks Write IOPS of current database instance
WritesCount DatabaseMySqlWrites Number of INSERT, UPDATE and DELETE statements

Pre-configured Alerts

Alert Name Expression Severity Description
Database Approaching Max Size Size > 1900 Warning Disabled by default. Fires an alert when the size of the database approaches maximum limit.
Open Sessions Approaching Max Limit ConnectionsActive > 150 Warning Disabled by default. Number of open connections (sesssions) is approaching maximum limit.
Resource Outage Status == "Down" Error Raises an alert when connectivity cannot be established, after specified number of retries on the Advanced tab for sustained period of time
Slow Response ResponseTime > 15000 Warning Raises an alert if establishing a connection to monitored resource takes over 15 seconds for sustained period of time