G2 MySQL

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.

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.
G2 MySQL Database Network Monitor	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.