G2 MySQL Database Command Template

Description

G2 MySQL Database Command Template

Prerequisites

No prerequisite

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
G2 MySQL Database Command Monitormysql.update.commandsMySQL Update CommandspsecThe number of times UPDATE command has been executed.
mysql.select.commandsMySQL Select CommandpsecThe number of times SELECT command has been executed
mysql.delete.commandsMySQL Delete CommandpsecThe number of times Delete command has been executed
mysql.insert.commandsMySQL Insert CommandpsecThe number of times Insert command has been executed
mysql.rollback.commandsMySQL Rollback CommandpsecThe number of times RollBack command has been executed
mysql.droptable.commandsMySQL DropTable CommandpsecThe number of times Drop Table command has been executed
mysql.dropuser.commandsMySQL Dropuser CommandspsecThe number of times DROP USER command has been executed.
mysql.dropdatabase.commandsMySQL DropDatabase CommandspsecThe number of times DROP DATABASE command has been executed.
mysql.createtable.commandsMySQL CreateTable CommandspsecThe number of times CREATE TABLE command has been executed.
mysql.createuser.commandsMySQL Createuser CommandspsecThe number of times CREATE USER command has been executed.
mysql.createdatabase.commandsMySQL Createdatabase CommandspsecThe number of times CREATE DATABASE command has been executed.
mysql.slow.query.countMySQL Slow Query CountqpmMySQL Slow Query Count.

G2 MySQL Database Connection Template

Description

G2 MySQL Database Connection Template

Prerequisites

No prerequisite

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
G2 MySQL Database Connection Monitormysql.aborted.clientsMySQL Aborted ClientscountThe number of connections that were aborted because the client died without closing the connection properly.
mysql.max.connectionsMySQL Max ConnectionscountMax Limit of Connections.
mysql.max.connections.connection_errorsMySQL Max Connections Connection ErrorscountThe number of connections refused due to internal server errors.
mysql.aborted.connectsMySQL Aborted ConnectscountThe number of failed attempts to connect to the MySQL server.
mysql.internal.connection.errorsMySQL Internal Connection ErrorscountThe 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.connectsMySQL SSL Client ConnectscountThe number of SSL connection attempts to an SSL-enabled master.
mysql.active.transactionsMySQL Active TransactionscountNumber of active transactions
mysql.server.connectionsMySQL Server ConnectionscountThe 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 NameMetric NameMetric Display NameUnitDescription
G2 MySQL Database innoDB statistics - RSEsystem_linux_mysql_innodb_row_insertsSystem Linux MySQL InnoDB Row InsertsCount per secMonitors the number of row insert operations performed by InnoDB in the MySQL database.
system_linux_mysql_innodb_row_updatesSystem Linux MySQL InnoDB Row UpdatesCount per secMonitors the number of row update operations performed by InnoDB in the MySQL database.
system_linux_mysql_innodb_row_readsSystem Linux MySQL InnoDB Row ReadsCount per secMonitors the number of row read operations performed by InnoDB in the MySQL database.
system_linux_mysql_innodb_row_deletesSystem Linux MySQL InnoDB Row DeletesCount per secMonitors the number of row delete operations executed by InnoDB in the MySQL database.
system_linux_mysql_innodb_history_list_lengthSystem Linux MySQL InnoDB History List LengthCountMonitors 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 NameMetric NameMetric Display NameUnitDescription
G2 MySQL Database innoDB Monitormysql.innodb.data.pending.readsMySQL Innodb Data Pending ReadscountThe current number of pending reads.
mysql.innodb.data.pending.writesMySQL Innodb Data Pending WritescountThe total number of data writes.
mysql.innodb.bufferpool.pagesfreeMySQL Innodb Buffer Pool Pages freecountThe number of free pages in the InnoDB Buffer Pool.
mysql.innodb.bufferpool.pagestotalMysql Innodb Bufferpool PagestotalcountThe total number of pages in the InnoDB Buffer Pool.
mysql.innodb.buffer_pool_readsMySQL Innodb Bufferpool ReadscountThe 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_requestsMySQL Innodb Bufferpool Read RequestscountThe number of reads done to the InnoDB buffer pool.
mysql.innodb.buffer_pool_write_requestsMySQL Innodb Bufferpool Write RequestscountThe number of writes done to the InnoDB buffer pool.
mysql.innodb.bufferpool.dirtypagesMysql Innodb Bufferpool DirtypagescountThe current number of dirty pages in the InnoDB buffer pool.
mysql.innodb.bufferpool.utilizationMySQL Innodb Bufferpool Utilization%The utilization of the InnoDB Buffer Pool. Shown as fraction
mysql.innodb.data.readsMySQL Innodb Data ReadscountThe total number of data reads (OS file reads).
mysql.innodb.data.writesMySQL InnoDB Data WritescountThe total number of data writes.
mysql.innodb.row.lock.waitsMySQL Innodb Row Lock waitscountThe number of times operations on InnoDB tables had to wait for a row lock.
mysql.innodb.row.lock.timemysql Innodb Row Lock TimemsThe 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 NameMetric NameMetric Display NameUnitDescription
G2 MySQL Database Miscellaneous Monitormysql.slave.statusMySQL Slave StatusMySQL Slave Status.
mysq.slave.seconds.behind.masterMySQL Slave behind masterMySQL Slave behind master.
mysql.system.uptimeMySQL System UptimemMySQL System Uptime.
mysql.streams.openMySQL Streams OpencountThe 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 NameMetric NameMetric Display NameUnitDescription
G2 MySQL Database Network Monitormysql.bytes.receivedMySQL Bytes ReceivedBpsThe number of bytes received from all clients.
mysql.bytes.sentMySQL Bytes SentBpsThe 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 NameMetric NameMetric Display NameUnitDescription
G2 MySQL Database Replication Statusmysql_Replication_StatusMySQL Replication StatusNULLReturns 0 - if slave is not running,1 - if slave is running,2 - if slave NOT configured
mysql_slave_Sql_Running_StatusMySQL Slave SQL Running StatusNULLReturns 0 - if slave SQL is not running,1 - if slave SQL is running,2 - if slave SQL NOT configured
mysql_slave_Seconds_Behind_MasterMySQL Slave behind MastersMySQL Slave behind master in seconds
mysql_slave_IO_Running_StatusMySQL Slave IO Running StatusNULLReturns 0 - if slave IO is not running,1 - if slave IO is running,2 - if slave IO NOT configured
mysql_slave_Sql_Running_StateMySQL Slave SQL Running StateNULLThe 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_StateMySQL Slave IO StateNULLInput/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 NameMetric NameMetric Display NameUnitDescription
G2 MySQL Database Table Monitormysq.tmp.table.delta.utilMySL temporary table delta utilizationMySL temporary table delta utilization
mysq.tmp.table.utilMySQL temporary table utilizationMySQL temporary table utilization
mysql.temporary.files.createdMySQL Temporary Files CreatedpsecThe rate of temporary files created by second.
mysql.disk.temporarytables.createdMySQL Disk Temporary Tables CreatedpsecThe rate of temporary tables created by second.
mysql.full.table.scan.delta.utilMySQL full table scan delta utilizationMySQL full table scan delta utilization
mysql.full.table.scan.utilMySQL full table scan utilizationMySQL full table scan utilization
mysq.open.files.utilMySQL Open file utilizationMySQL Open file utilization
mysql.open.filesMySQL Open FilescountThe 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.tablesMySQL Open TablescountThe number of tables that have been opened with my_open().
mysql.table.locks_immediateMySQL Table Locks ImmediatecountThe 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 NameMetric NameMetric Display NameUnitDescription
G2 MySQL Database Threads Monitormysql.connected.threads.countMySQL Connected Threads countMySQL Connected Threads count
mysql.created.threadsMySQL Created ThreadscountThe 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.countMySQL Cached Threads countMySQL Cached Threads count
mysql.running.threadsMySQL Running ThreadscountThe number of threads that are not sleeping.
mysql.threads.stacksizeMySQL Threads StacksizeNULLThe stack size for each thread. Many of the limits detected by the crash-me test are dependent on this value.