G2 MySQL Database Command Template
Description
G2 MySQL Database Command Template
Prerequisites
End device SSH credentials need to be added on End device itself.
Supported Metric
| Monitor Name | Metric Name | Metric Display Name | Unit | Description |
|---|---|---|---|---|
| G2 MySQL Database Command Monitor | mysql.update.commands | MySQL Update Commands | psec | The number of times UPDATE command has been executed. |
| mysql.select.commands | MySQL Select Command | psec | The number of times SELECT command has been executed | |
| mysql.delete.commands | MySQL Delete Command | psec | The number of times Delete command has been executed | |
| mysql.insert.commands | MySQL Insert Command | psec | The number of times Insert command has been executed | |
| mysql.rollback.commands | MySQL Rollback Command | psec | The number of times RollBack command has been executed | |
| mysql.droptable.commands | MySQL DropTable Command | psec | The number of times Drop Table command has been executed | |
| mysql.dropuser.commands | MySQL Dropuser Commands | psec | The number of times DROP USER command has been executed. | |
| mysql.dropdatabase.commands | MySQL DropDatabase Commands | psec | The number of times DROP DATABASE command has been executed. | |
| mysql.createtable.commands | MySQL CreateTable Commands | psec | The number of times CREATE TABLE command has been executed. | |
| mysql.createuser.commands | MySQL Createuser Commands | psec | The number of times CREATE USER command has been executed. | |
| mysql.createdatabase.commands | MySQL Createdatabase Commands | psec | The number of times CREATE DATABASE command has been executed. | |
| mysql.slow.query.count | MySQL Slow Query Count | qpm | MySQL Slow Query Count. |
G2 MySQL Database Connection Template
Description
G2 MySQL Database Connection Template
Prerequisites
No prerequisite
Supported Metric
| Monitor Name | Metric Name | Metric Display Name | Unit | Description |
|---|---|---|---|---|
| G2 MySQL Database Connection Monitor | mysql.aborted.clients | MySQL Aborted Clients | count | The number of connections that were aborted because the client died without closing the connection properly. |
| mysql.max.connections | MySQL Max Connections | count | Max Limit of Connections. | |
| mysql.max.connections.connection_errors | MySQL Max Connections Connection Errors | count | The number of connections refused due to internal server errors. | |
| mysql.aborted.connects | MySQL Aborted Connects | count | The number of failed attempts to connect to the MySQL server. | |
| mysql.internal.connection.errors | MySQL Internal Connection Errors | count | 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. | |
| mysql.ssl.client.connects | MySQL SSL Client Connects | count | The number of SSL connection attempts to an SSL-enabled master. | |
| mysql.active.transactions | MySQL Active Transactions | count | Number of active transactions | |
| mysql.server.connections | MySQL Server Connections | count | The number of connection attempts (successful or not) to the MySQL server. |
G2 MySQL Database innoDB statistics - RSE
Description
Monitors InnoDB statistics such as history list length alongside row operations in MySQL, covering inserts, updates, deletes, and reads.
Prerequisites
- The gateway version must be 14.0.0 or above.
- End device SSH credentials need to be added on End device itself.
- It requires either the SUPER or REPLICATION CLIENT privilege.
- Validated against mysql Server version: 5.7.36-0ubuntu0.18.04.1-log (Ubuntu). Applicable for: Opsramp Gateway v11.0.0 and above.
Supported Metric
| Monitor Name | Metric Name | Metric Display Name | Unit | Description |
|---|---|---|---|---|
| G2 MySQL Database innoDB statistics - RSE | system_linux_mysql_innodb_row_inserts | System Linux MySQL InnoDB Row Inserts | Count per sec | Monitors the number of row insert operations performed by InnoDB in the MySQL database. |
| system_linux_mysql_innodb_row_updates | System Linux MySQL InnoDB Row Updates | Count per sec | Monitors the number of row update operations performed by InnoDB in the MySQL database. | |
| system_linux_mysql_innodb_row_reads | System Linux MySQL InnoDB Row Reads | Count per sec | Monitors the number of row read operations performed by InnoDB in the MySQL database. | |
| system_linux_mysql_innodb_row_deletes | System Linux MySQL InnoDB Row Deletes | Count per sec | Monitors the number of row delete operations executed by InnoDB in the MySQL database. | |
| system_linux_mysql_innodb_history_list_length | System Linux MySQL InnoDB History List Length | Count | Monitors the length of InnoDB's history list, providing insights into query and transaction activity in MySQL. |
G2 MySQL Database innoDB Template
Description
G2 MySQL Database innoDB Template
Prerequisites
No prerequisite
Supported Metric
| Monitor Name | Metric Name | Metric Display Name | Unit | Description |
|---|---|---|---|---|
| G2 MySQL Database innoDB Monitor | mysql.innodb.data.pending.reads | MySQL Innodb Data Pending Reads | count | The current number of pending reads. |
| mysql.innodb.data.pending.writes | MySQL Innodb Data Pending Writes | count | The total number of data writes. | |
| mysql.innodb.bufferpool.pagesfree | MySQL Innodb Buffer Pool Pages free | count | The number of free pages in the InnoDB Buffer Pool. | |
| mysql.innodb.bufferpool.pagestotal | Mysql Innodb Bufferpool Pagestotal | count | The total number of pages in the InnoDB Buffer Pool. | |
| mysql.innodb.buffer_pool_reads | MySQL Innodb Bufferpool Reads | count | The number of logical reads that InnoDB could not satisfy from the buffer pool,and had to read directly from the disk. | |
| mysql.innodb.buffer_pool_read_requests | MySQL Innodb Bufferpool Read Requests | count | The number of reads done to the InnoDB buffer pool. | |
| mysql.innodb.buffer_pool_write_requests | MySQL Innodb Bufferpool Write Requests | count | The number of writes done to the InnoDB buffer pool. | |
| mysql.innodb.bufferpool.dirtypages | Mysql Innodb Bufferpool Dirtypages | count | The current number of dirty pages in the InnoDB buffer pool. | |
| mysql.innodb.bufferpool.utilization | MySQL Innodb Bufferpool Utilization | % | The utilization of the InnoDB Buffer Pool. Shown as fraction | |
| mysql.innodb.data.reads | MySQL Innodb Data Reads | count | The total number of data reads (OS file reads). | |
| mysql.innodb.data.writes | MySQL InnoDB Data Writes | count | The total number of data writes. | |
| mysql.innodb.row.lock.waits | MySQL Innodb Row Lock waits | count | The number of times operations on InnoDB tables had to wait for a row lock. | |
| mysql.innodb.row.lock.time | mysql Innodb Row Lock Time | ms | The total time spent in acquiring row locks for InnoDB tables,in milliseconds. |
G2 MySQL Database Miscellaneous Template
Description
G2 MySQL Database Miscellaneous Template
Prerequisites
No prerequisite
Supported Metric
| Monitor Name | Metric Name | Metric Display Name | Unit | Description |
|---|---|---|---|---|
| G2 MySQL Database Miscellaneous Monitor | mysql.slave.status | MySQL Slave Status | MySQL Slave Status. | |
| mysq.slave.seconds.behind.master | MySQL Slave behind master | MySQL Slave behind master. | ||
| mysql.system.uptime | MySQL System Uptime | m | MySQL System Uptime. | |
| mysql.streams.open | MySQL Streams Open | count | The number of streams that are open (used mainly for logging). |
G2 MySQL Database Network Template
Description
G2 MySQL Database Network Template
Prerequisites
No prerequisite
Supported Metric
| Monitor Name | Metric Name | Metric Display Name | Unit | Description |
|---|---|---|---|---|
| G2 MySQL Database Network Monitor | mysql.bytes.received | MySQL Bytes Received | Bps | The number of bytes received from all clients. |
| mysql.bytes.sent | MySQL Bytes Sent | Bps | The number of bytes sent to all clients. |
G2 MySQL Database Replication Status
Description
Monitors mysql replication status & slave behind master details along with mysql io/sql service running state details. This is applicable only for mysql slave resource.
Prerequisites
Supported Metric
| Monitor Name | Metric Name | Metric Display Name | Unit | Description |
|---|---|---|---|---|
| G2 MySQL Database Replication Status | mysql_Replication_Status | MySQL Replication Status | NULL | Returns 0 - if slave is not running,1 - if slave is running,2 - if slave NOT configured |
| mysql_slave_Sql_Running_Status | MySQL Slave SQL Running Status | NULL | Returns 0 - if slave SQL is not running,1 - if slave SQL is running,2 - if slave SQL NOT configured | |
| mysql_slave_Seconds_Behind_Master | MySQL Slave behind Master | s | MySQL Slave behind master in seconds | |
| mysql_slave_IO_Running_Status | MySQL Slave IO Running Status | NULL | Returns 0 - if slave IO is not running,1 - if slave IO is running,2 - if slave IO NOT configured | |
| mysql_slave_Sql_Running_State | MySQL Slave SQL Running State | NULL | The Running state of slave SQL service. Returns 1 - if sql state is "Making temporary file (append) before replaying LOAD DATA INFILE",2 - if sql state is "Making temporary file (create) before replaying LOAD DATA INFILE",3 - if sql state is "Reading event from the relay log",4 - if sql state is "Slave has read all relay log; waiting for more updates",5 - if sql state is "Waiting for an event from Coordinator",6 - if sql state is "Waiting for slave mutex on exit",7 - if sql state is "Waiting for Slave Workers to free pending events",8 - if sql state is "Waiting for the next event in relay log",9 - if sql state is "Waiting until MASTER_DELAY seconds after master executed event" | |
| mysql_slave_IO_State | MySQL Slave IO State | NULL | Input/output state of slave. Returns 1- if io state is "Checking master version",2 - if io state is "Connecting to master",3 - if io state is "Queueing master event to the relay log",4 - if io state is "Reconnecting after a failed binlog dump request",5 - if io state is "Reconnecting after a failed master event read",6 - if io state is "Registering slave on master",7 - if io state is "Requesting binlog dump",8 - if io state is "Waiting for its turn to commit",9 - if io state is "Waiting for master to send event",10 - if io state is "Waiting for master update",11 - if io state is "Waiting for slave mutex on exit",12 - if io state is "Waiting for the slave SQL thread to free enough relay log space",13 - if io state is "Waiting to reconnect after a failed binlog dump request",14 - if io state is "Waiting to reconnect after a failed master event read". |
G2 MySQL Database Table Template
Description
G2 MySQL Database Table Template
Prerequisites
No prerequisite
Supported Metric
| Monitor Name | Metric Name | Metric Display Name | Unit | Description |
|---|---|---|---|---|
| G2 MySQL Database Table Monitor | mysq.tmp.table.delta.util | MySL temporary table delta utilization | MySL temporary table delta utilization | |
| mysq.tmp.table.util | MySQL temporary table utilization | MySQL temporary table utilization | ||
| mysql.temporary.files.created | MySQL Temporary Files Created | psec | The rate of temporary files created by second. | |
| mysql.disk.temporarytables.created | MySQL Disk Temporary Tables Created | psec | The rate of temporary tables created by second. | |
| mysql.full.table.scan.delta.util | MySQL full table scan delta utilization | MySQL full table scan delta utilization | ||
| mysql.full.table.scan.util | MySQL full table scan utilization | MySQL full table scan utilization | ||
| mysq.open.files.util | MySQL Open file utilization | MySQL Open file utilization | ||
| mysql.open.files | MySQL Open Files | count | 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 | |
| mysql.open.tables | MySQL Open Tables | count | The number of tables that have been opened with my_open(). | |
| mysql.table.locks_immediate | MySQL Table Locks Immediate | count | The number of times that a request for a table lock could be granted immediately. |
G2 MySQL Database Threads Template
Description
G2 MySQL Database Threads Template
Prerequisites
No prerequisite
Supported Metric
| Monitor Name | Metric Name | Metric Display Name | Unit | Description |
|---|---|---|---|---|
| G2 MySQL Database Threads Monitor | mysql.connected.threads.count | MySQL Connected Threads count | MySQL Connected Threads count | |
| mysql.created.threads | MySQL Created Threads | count | 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. | |
| mysql.threads.cached.count | MySQL Cached Threads count | MySQL Cached Threads count | ||
| mysql.running.threads | MySQL Running Threads | count | The number of threads that are not sleeping. | |
| mysql.threads.stacksize | MySQL Threads Stacksize | NULL | The stack size for each thread. Many of the limits detected by the crash-me test are dependent on this value. |