Description
This template monitors metrics like pending reads, buffer pool pages free, buffer pool reads, buffer pool utilization, 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.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