G2 MySQL Database Command Template
Description
G2 MySQL Database Command Template
Prerequisites
No prerequisite
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.
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
- 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 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. |