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
| Parameter | Description |
|---|---|
| Frequency | Warning Threshold | If the metric value satisfies the condition defined along with Warning Threshold value, then a notification is sent to the user. |
| Critical Threshold | If the metric value satisfies the condition defined along with Critical Threshold value, then a notification is sent to the user. |
| Alert | The 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
| Applicable for | CLOUD_PAAS_DB |
| Description | The number of times UPDATE command has been executed. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Command Monitor |
| Unit | psec |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.select.commands
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The number of times SELECT command has been executed. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Command Monitor |
| Unit | psec |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.delete.commands
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The number of times Delete command has been executed. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Command Monitor |
| Unit | psec |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.insert.commands
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The number of times Insert command has been executed |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Command Monitor |
| Unit | psec |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.rollback.commands
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The number of times RollBack command has been executed |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Command Monitor |
| Unit | psec |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.droptable.commands
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The number of times Drop Table command has been executed |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Command Monitor |
| Unit | psec |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.dropuser.commands
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The number of times DROP USER command has been executed. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Command Monitor |
| Unit | psec |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.dropdatabase.commands
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The number of times DROP DATABASE command has been executed |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Command Monitor |
| Unit | psec |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.createtable.commands
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The number of times CREATE TABLE command has been executed |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Command Monitor |
| Unit | psec |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.createuser.commands
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The number of times CREATE USER command has been executed |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Command Monitor |
| Unit | psec |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.createdatabase.commands
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The number of times CREATE DATABASE command has been executed |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Command Monitor |
| Unit | psec |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.slow.query.count
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | Slow Query Count |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Command Monitor |
| Unit | qpm |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.aborted.clients
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The number of connections that were aborted because the client died without closing the connection properly. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Connection Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.max.connections
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | Maximum Limit of Connections. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Connection Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.max.connections.connection_errors
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The number of connections refused due to internal server errors. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Connection Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.aborted.connects
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The number of failed attempts to connect to the MySQL server. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Connection Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.internal.connection.errors
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The 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. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Connection Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.ssl.client.connects
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The number of SSL connection attempts to an SSL-enabled master. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Connection Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.active.transactions
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | Number of active transactions |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Connection Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.server.connections
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The number of connection attempts (successful or not) to the MySQL server. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Connection Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.innodb.data.pending.reads
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The current number of pending reads. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database innoDB Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.innodb.data.pending.writes
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The total number of data writes. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database innoDB Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.innodb.bufferpool.pagesfree
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The number of free pages in the InnoDB Buffer Pool. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database innoDB Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.innodb.bufferpool.pagestotal
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The total number of pages in the InnoDB Buffer Pool. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database innoDB Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.innodb.buffer_pool_reads
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The number of logical reads that InnoDB could not satisfy from the buffer pool, and had to read directly from the disk. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database innoDB Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.innodb.buffer_pool_read_requests
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The number of reads done to the InnoDB buffer pool. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database innoDB Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.innodb.buffer_pool_write_requests
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The number of writes done to the InnoDB buffer pool. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database innoDB Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.innodb.bufferpool.dirtypages
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The current number of dirty pages in the InnoDB buffer pool. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database innoDB Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.innodb.bufferpool.utilization
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The utilization of the InnoDB Buffer Pool shown as fraction |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database innoDB Monitor |
| Unit | % |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.innodb.data.reads
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The total number of data reads (OS file reads). |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database innoDB Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.innodb.data.writes
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The total number of data writes. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database innoDB Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.innodb.row.lock.waits
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The number of times operations on InnoDB tables had to wait for a row lock. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database innoDB Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.innodb.row.lock.time
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The total time spent in acquiring row locks for InnoDB tables, in milliseconds. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database innoDB Monitor |
| Unit | ms |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.slave.status
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | Provides information about the configuration and status of the connection between the slave server and the master server. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Miscellaneous Monitor |
| Unit |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | EQUAL | Ends 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 Threshold | 0 | User defined |
| Critical Repeat Count | 1 | 1-12 |
| Alert | Yes | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.slave.seconds.behind.master
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The 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. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Miscellaneous Monitor |
| Unit |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | GREATER_THAN_EQUAL | Ends 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 Threshold | 10 | User defined |
| Warning Repeat Count | 1 | 1-12 |
| Critical Operator | GREATER_THAN_EQUAL | Ends 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 Threshold | 20 | User defined |
| Critical Repeat Count | 1 | 1-12 |
| Alert | Yes | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.system.uptime
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | System Uptime |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Miscellaneous Monitor |
| Unit | m |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | Yes | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.streams.open
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The number of streams that are open (used mainly for logging). |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Miscellaneous Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.bytes.received
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The number of bytes received from all clients. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Network Monitor |
| Unit | Bps |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.bytes.sent
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The number of bytes sent to all clients. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Network Monitor |
| Unit | Bps |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysq.tmp.table.delta.util
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | Temporary table delta utilization. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Table Monitor |
| Unit |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | GREATER_THAN_EQUAL | Ends 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 Threshold | 70 | User defined |
| Warning Repeat Count | 1 | 1-12 |
| Critical Operator | GREATER_THAN_EQUAL | Ends 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 Threshold | 90 | User defined |
| Critical Repeat Count | 1 | 1-12 |
| Alert | Yes | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysq.tmp.table.util
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | Temporary table utilization. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Table Monitor |
| Unit |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | GREATER_THAN_EQUAL | Ends 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 Threshold | 70 | User defined |
| Warning Repeat Count | 1 | 1-12 |
| Critical Operator | GREATER_THAN_EQUAL | Ends 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 Threshold | 90 | User defined |
| Critical Repeat Count | 1 | 1-12 |
| Alert | Yes | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.temporary.files.created
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The rate of temporary files created by second. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Table Monitor |
| Unit | psec |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.disk.temporarytables.created
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The rate of temporary tables created by second. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Table Monitor |
| Unit | psec |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.full.table.scan.delta.util
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | Full table scan delta utilization. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Table Monitor |
| Unit |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | GREATER_THAN_EQUAL | Ends 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 Threshold | 70 | User defined |
| Warning Repeat Count | 1 | 1-12 |
| Critical Operator | GREATER_THAN_EQUAL | Ends 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 Threshold | 90 | User defined |
| Critical Repeat Count | 1 | 1-12 |
| Alert | Yes | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.full.table.scan.util
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | Full table scan utilization. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Table Monitor |
| Unit |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | GREATER_THAN_EQUAL | Ends 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 Threshold | 70 | User defined |
| Warning Repeat Count | 1 | 1-12 |
| Critical Operator | GREATER_THAN_EQUAL | Ends 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 Threshold | 90 | User defined |
| Critical Repeat Count | 1 | 1-12 |
| Alert | Yes | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysq.open.files.util
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | Open files utilization |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Table Monitor |
| Unit |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | GREATER_THAN_EQUAL | Ends 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 Threshold | 70 | User defined |
| Warning Repeat Count | 1 | 1-12 |
| Critical Operator | GREATER_THAN_EQUAL | Ends 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 Threshold | 90 | User defined |
| Critical Repeat Count | 1 | 1-12 |
| Alert | Yes | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.open.files
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The 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 |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Table Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.open.tables
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The number of tables that have been opened with my_open(). |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Table Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.table.locks_immediate
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The number of times that a request for a table lock could be granted immediately. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Table Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.connected.threads.count
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | Connected Threads count |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Threads Monitor |
| Unit |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.created.threads
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The 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. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Threads Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.threads.cached.count
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The number of threads in the thread cache. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Threads Monitor |
| Unit |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.running.threads
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The number of threads that are not sleeping. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Threads Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.threads.stacksize
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The stack size for each thread. Many of the limits detected by the crash-me test are dependent on this value. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MySQL Database Threads Monitor |
| Unit |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph