Description
This template monitors metrics like temporary table delta utilization, full table scan utilization, open files, temporary files created, temporary table 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. While applying the template, the database port, Database Name, connection timeout need to be specified.
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
mysq.tmp.table.delta.util
Metric Details
| Applicable for | Device |
| Description | Temporary table delta utilization. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 MySQL Database Table Monitor |
| Unit | NULL |
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 | Device |
| Description | Temporary table utilization |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 MySQL Database Table Monitor |
| Unit | NULL |
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 | Device |
| Description | The rate of temporary files created by second. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 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 | Device |
| Description | The rate of temporary tables created by second. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 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 | Device |
| Description | Full table scan delta utilization |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 MySQL Database Table Monitor |
| Unit | NULL |
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 | Device |
| Description | Full table scan utilization |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 MySQL Database Table Monitor |
| Unit | NULL |
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 | Device |
| Description | Open files utilization |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 MySQL Database Table Monitor |
| Unit | NULL |
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 | Device |
| 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 | G2 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 | Device |
| Description | The number of tables that have been opened with my_open(). |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 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 | Device |
| Description | The number of times that a request for a table lock could be granted immediately. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 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