MySQL

Overview

MySQL, the popular and open-source relational database management system, seamlessly integrates with Motadata AIOps to provide comprehensive monitoring capabilities. With this integration, organizations gain real-time visibility into the performance and health of their MySQL databases. Monitor critical database metrics such as query execution times, transaction rates, and database size to ensure efficient data processing and retrieval.

Supported Versions

Versions
1.4.1
1.5.0
1.6.0
1.7.x
8.0

Prerequisites for MySQL Integration with Motadata AIOps:

• Ensure that the MySQL port (default: 3306) is open for the Motadata AIOps server.

• Ensure you have the necessary credentials, including the username and password, for Motadata AIOps to connect to the MySQL database.

• Ensure that JDBC is supported on the server where MySQL is configured.

• For agentless monitoring, ensure that the user has the required access for remote access to the MySQL server. For agent-based monitoring, this is not required.

• Ensure that the MySQL service is active and running on the server.

• Ensure you have the name of the MySQL database that you want to monitor.

• Confirm that the MySQL process and service are listed in the process and service monitor settings of Motadata AIOps. While these may be listed by default, verify that the names of the service and process match the specific MySQL version that you intend to monitor.

List of Supported KPIs

Name	Description	Type
mysql.query.cache.size.bytes	The size of the MySQL query cache in bytes.	Count
mysql.query.cache.hits	The number of hits in the MySQL query cache.	Count
mysql.query.cache.inserts	The number of inserts in the MySQL query cache.	Count
system.tags	The tags associated with the MySQL system.	String
mysql.installation.directory	The installation directory of MySQL.	String
mysql.data.directory	The data directory of MySQL.	String
started.time	The uptime of the MySQL system.	String
started.time.sec	The uptime of the MySQL system in seconds.	Count
mysql.version	The version of MySQL.	String
mysql.aborted.clients	The number of aborted client connections in MySQL.	Count
mysql.aborted.connections	The number of aborted connections in MySQL.	Count
mysql.received.bytes.rate	The rate of received bytes in MySQL.	Count
mysql.sent.bytes.rate	The rate of sent bytes in MySQL.	Count
mysql.connections	The current number of connections in MySQL.	Count
mysql.questions	The number of queries executed in MySQL.	Count
mysql.opened.connections	The total number of opened connections in MySQL.	Count
mysql.delayed.errors	The number of delayed errors in MySQL.	Count
mysql.delayed.writes	The number of delayed writes in MySQL.	Count
mysql.flushes.rate	The rate of flushes in MySQL.	Count
mysql.key.used.blocks	The number of used blocks for keys in MySQL.	Count
mysql.key.read.requests.rate	The rate of key read requests in MySQL.	Count
mysql.key.writes.rate	The rate of key writes in MySQL.	Count
mysql.key.write.requests.rate	The rate of key write requests in MySQL.	Count
mysql.not.flushed.delayed.rows	The number of delayed rows not yet flushed in MySQL.	Count
mysql.deleted.rows.rate	The rate of deleted rows in MySQL.	Count
mysql.inserted.rows.rate	The rate of inserted rows in MySQL.	Count
mysql.next.row.reads.rate	The rate of next row reads in MySQL.	Count
mysql.read.keys.rate	The rate of key reads in MySQL.	Count
mysql.updated.rows.rate	The rate of updated rows in MySQL.	Count
mysql.delayed.insert.threads	The number of threads for delayed inserts in MySQL.	Count
mysql.slow.launch.threads	The number of threads with slow launches in MySQL.	Count
mysql.cached.threads	The number of cached threads in MySQL.	Count
mysql.connected.threads	The number of currently connected threads in MySQL.	Count
mysql.created.threads	The number of threads created in MySQL.	Count
mysql.running.threads	The number of currently running threads in MySQL.	Count
mysql.thread.cache.size.bytes	The size of the thread cache in MySQL (in bytes).	Count
mysql.open.tables	The number of currently open tables in MySQL.	Count
mysql.open.files	The number of currently open files in MySQL.	Count
mysql.open.streams	The number of currently open streams in MySQL.	Count
mysql.select.full.joins.rate	The rate of full joins in MySQL SELECT statements.	Count
mysql.select.ranges.rate	The rate of range queries in MySQL SELECT statements.	Count
mysql.select.range.checks.rate	The rate of range checks in MySQL SELECT statements.	Count
mysql.select.scans.rate	The rate of table scans in MySQL SELECT statements.	Count
mysql.slave.opened.temp.tables	The number of temporary tables opened by MySQL replication slave.	Count
mysql.slow.queries	The number of slow queries detected in MySQL.	Count
mysql.sort.merge.passes.rate	The rate of merge passes during sorting in MySQL.	Count
mysql.sort.ranges.rate	The rate of range queries requiring sorting in MySQL.	Count
mysql.table.lock.waits	The number of table lock waits in MySQL.	Count
mysql.table.immediate.locks	The number of immediate table locks in MySQL.	Count
mysql.created.temp.disk.tables.rate	The rate at which temporary disk tables are created in MySQL.	Count
mysql.created.temp.files.rate	The rate at which temporary files are created in MySQL.	Count
mysql.created.temp.tables.rate	The rate at which temporary tables are created in MySQL.	Count
mysql.query.cache.hit.ratio.percent	The percentage of query cache hits in MySQL.	Count
mysql.key.buffer.size.bytes	The size of the key buffer in MySQL (in bytes).	Count
mysql.key.hit.ratio.percent	The percentage of key cache hits in MySQL.	Count
mysql.delete.multi.commands.rate	The rate of multi-delete commands in MySQL.	Count
mysql.select.commands.rate	The rate of SELECT commands in MySQL.	Count
mysql.delete.commands.rate	The rate of DELETE commands in MySQL.	Count
mysql.insert.commands.rate	The rate of INSERT commands in MySQL.	Count
mysql.key.reads.rate	The rate of key reads in MySQL.	Count
mysql.update.commands.rate	The rate of UPDATE commands in MySQL.	Count
mysql.process.user	The user associated with the MySQL process.	String
mysql.process.state	The state of the MySQL process.	String
mysql.process.command	The command executed by the MySQL process.	String
mysql.process.db	The number of databases associated with the MySQL process.	Count
mysql.process.info	Additional information about the MySQL process.	Count
mysql.process	The count of MySQL processes.	Count
mysql.process.host	The host name of the machine where the MySQL process is running.	String
mysql.process.time.ms	The execution time of the MySQL process in milliseconds.	Count
mysql.innodb.buffer.pool.sequential.reads.rate	The rate of sequential reads from the InnoDB buffer pool.	Count
mysql.innodb.buffer.pool.pages.data	The number of data pages in the InnoDB buffer pool.	Count
mysql.innodb.buffer.pool.dirty.pages	The number of dirty pages in the InnoDB buffer pool.	Count
mysql.innodb.buffer.pool.flush.pages.rate	The rate at which pages are flushed from the InnoDB buffer pool.	Count
mysql.innodb.buffer.pool.free.pages	The number of free pages in the InnoDB buffer pool.	Count
mysql.innodb.buffer.pool.misc.pages	The number of miscellaneous pages in the InnoDB buffer pool.	Count
mysql.innodb.buffer.pool.pages	The total number of pages in the InnoDB buffer pool.	Count
mysql.innodb.buffer.pool.random.ahead.reads	The number of random ahead reads from the InnoDB buffer pool.	Count
mysql.innodb.buffer.pool.read.requests.rate	The rate of read requests from the InnoDB buffer pool.	Count
mysql.innodb.buffer.pool.reads.rate	The rate of reads from the InnoDB buffer pool.	Count
mysql.innodb.buffer.pool.free.waits	The number of waits for free pages in the InnoDB buffer pool.	Count
mysql.innodb.buffer.pool.write.requests.rate	The rate of write requests to the InnoDB buffer pool.	Count
mysql.innodb.data.fsyncs.rate	The rate of data file fsyncs performed by InnoDB.	Count
mysql.innodb.data.pending.fsyncs	The number of pending data file fsyncs in InnoDB.	Count
mysql.innodb.data.pending.reads	The number of pending data reads in InnoDB.	Count
mysql.innodb.data.pending.writes	The number of pending data writes in InnoDB.	Count
mysql.innodb.data.reads.rate	The rate of data reads from InnoDB.	Count
mysql.innodb.data.writes.rate	The rate of data writes to InnoDB.	Count
mysql.innodb.double.write.written.pages.rate	The rate of doublewrite buffer written pages.	Count
mysql.innodb.double.write.writes.rate	The rate of writes to the doublewrite buffer.	Count
mysql.innodb.log.waits.rate	The rate of waits for InnoDB log flushes.	Count
mysql.innodb.log.write.requests.rate	The rate of log write requests in InnoDB.	Count
mysql.innodb.log.writes.rate	The rate of log writes in InnoDB.	Count
mysql.innodb.os.log.fsyncs.rate	The rate of operating system log file fsyncs in InnoDB.	Count
mysql.innodb.os.log.pending.fsyncs	The number of pending operating system log file fsyncs in InnoDB.	Count
mysql.innodb.os.log.pending.writes	The number of pending operating system log file writes in InnoDB.	Count
mysql.innodb.os.log.written.rate	The rate at which the MySQL InnoDB engine writes to the operating system log.	Count
mysql.innodb.page.size.bytes	The size of a page in the MySQL InnoDB storage engine.	Count
mysql.innodb.created.pages.rate	The rate at which pages are created in the MySQL InnoDB storage engine.	Count
mysql.innodb.read.pages.rate	The rate at which pages are read from the MySQL InnoDB storage engine.	Count
mysql.innodb.written.pages.rate	The rate at which pages are written to the MySQL InnoDB storage engine.	Count
mysql.innodb.row.lock.current.waits	The number of current row lock waits in the MySQL InnoDB storage engine.	Count
mysql.innodb.row.lock.time.ms	The time spent waiting for row locks in the MySQL InnoDB storage engine.	Count
mysql.innodb.average.row.lock.time.ms	The average time spent waiting for row locks in the MySQL InnoDB storage engine.	Count
mysql.innodb.row.lock.waits	The number of row lock waits in the MySQL InnoDB storage engine.	Count
mysql.innodb.deleted.rows.rate	The rate at which rows are deleted in the MySQL InnoDB storage engine.	Count
mysql.innodb.inserted.rows.rate	The rate at which rows are inserted in the MySQL InnoDB storage engine.	Count
mysql.innodb.read.rows.rate	The rate at which rows are read from the MySQL InnoDB storage engine.	Count
mysql.innodb.update.rows.rate	The rate at which rows are updated in the MySQL InnoDB storage engine.	Count
mysql.used.index.size.bytes	The size of the used index in bytes for the MySQL database.	Count
mysql.index.read.rows.rate	The rate at which rows are read from the index in the MySQL database.	String
mysql.index.fetches.rate	The rate at which index fetches occur in the MySQL database.	String
mysql.index.table.name	The name of the table associated with the index in the MySQL database.	String
mysql.index.database.name	The name of the database associated with the index in the MySQL database.	String
mysql.index.name	The name of the index in the MySQL database.	String
mysql.unused.index	The details of the unused index in the MySQL database.	String
mysql.unused.index.table.name	The name of the table associated with the unused index in the MySQL database.	String
mysql.unused.index.database.name	The name of the database associated with the unused index in the MySQL database.	String
mysql.unused.index.size.bytes	The size of the unused index in bytes for the MySQL database.	Count
mysql.missing.index.table.name	The name of the table associated with the missing index in the MySQL database.	String
mysql.missing.index.table.schema.name	The schema name of the table associated with the missing index in the MySQL database.	String
mssql.missing.index.column.name	The name of the column associated with the missing index in the MSSQL database.	String
mysql.missing.index	The details of the missing index in the MySQL database.	String
mysql.backup.table.commands	The number of backup table commands in MySQL.	Count
mysql.show.new.master.commands	The number of show new master commands in MySQL.	Count
mysql.load.master.table.commands	The number of load master table commands in MySQL.	Count
mysql.restore.table.commands	The number of restore table commands in MySQL.	Count
mysql.master.data.commands	The number of master data commands in MySQL.	Count
mysql.admin.commands	The number of admin commands in MySQL.	Count
mysql.analyze.commands	The number of analyze commands in MySQL.	Count
mysql.change.database.commands	The number of change database commands in MySQL.	Count
mysql.change.master.commands	The number of change master commands in MySQL.	Count
mysql.check.commands	The number of check commands in MySQL.	Count
mysql.create.database.commands	The number of create database commands in MySQL.	Count
mysql.drop.database.commands	The number of drop database commands in MySQL.	Count
mysql.flush.commands.rate	The rate at which flush commands occur in MySQL.	Count
mysql.grant.commands	The number of grant commands in MySQL.	Count
mysql.kill.commands	The number of kill commands in MySQL.	Count
mysql.optimize.commands	The number of optimize commands in MySQL.	Count
mysql.repair.commands	The number of repair commands in MySQL.	Count
mysql.reset.commands	The number of reset commands in MySQL.	Count
mysql.revoke.commands	The number of revoke commands in MySQL.	Count
mysql.alter.table.commands	The number of alter table commands in MySQL.	Count
mysql.create.function.commands	The number of create function commands in MySQL.	Count
mysql.create.index.commands	The number of create index commands in MySQL.	Count
mysql.create.table.commands	The number of create table commands in MySQL.	Count
mysql.drop.function.commands	The number of drop function commands in MySQL.	Count
mysql.drop.index.commands	The number of drop index commands in MySQL.	Count
mysql.drop.table.commands	The number of drop table commands in MySQL.	Count
mysql.rename.table.commands	The number of rename table commands in MySQL.	Count
mysql.handler.close.commands	The number of handler close commands in MySQL.	Count
mysql.handler.open.commands	The number of handler open commands in MySQL.	Count
mysql.handler.read.commands	The number of handler read commands in MySQL.	Count
mysql.set.option.commands	The number of set option commands in MySQL.	Count
mysql.slave.start.commands	The number of slave start commands in MySQL.	Count
mysql.slave.stop.commands	The number of slave stop commands in MySQL.	Count
mysql.insert.select.commands	The number of insert select commands in MySQL.	Count
mysql.load.commands	The number of load commands in MySQL.	Count
mysql.purge.commands	The number of purge commands in MySQL.	Count
mysql.replace.commands	The number of replace commands in MySQL.	Count
mysql.replace.select.commands	The number of replace select commands in MySQL.	Count
mysql.truncate.commands	The number of truncate commands in MySQL.	Count
mysql.show.binary.log.commands	The number of show binary log commands in MySQL.	Count
mysql.show.binary.log.event.commands	The number of show binary log event commands in MySQL.	Count
mysql.show.database.commands	The number of show database commands in MySQL.	Count
mysql.show.field.commands	The number of show field commands in MySQL.	Count
mysql.show.grant.commands	The number of show grant commands in MySQL.	Count
mysql.show.key.commands	The number of show key commands in MySQL.	Count
mysql.show.master.status.commands	The number of show master status commands in MySQL.	Count
mysql.show.open.table.commands	The number of show open table commands in MySQL.	Count
mysql.show.processlist.commands	The number of show processlist commands in MySQL.	Count
mysql.show.slave.host.commands	The number of show slave host commands in MySQL.	Count
mysql.show.slave.status.commands	The number of show slave status commands in MySQL.	Count
mysql.show.table.commands	The number of show table commands in MySQL.	Count
mysql.show.variable.commands	The number of show variable commands in MySQL.	Count
mysql.show.status.commands	The number of show status commands in MySQL.	Count
mysql.begin.transaction.commands.rate	The rate of begin transaction commands in MySQL.	Count
mysql.commit.transaction.commands.rate	The rate of commit transaction commands in MySQL.	Count
mysql.lock.table.commands	The number of lock table commands in MySQL.	Count
mysql.rollback.transaction.commands.rate	The rate of rollback transaction commands in MySQL.	Count
mysql.unlock.table.commands	The number of unlock table commands in MySQL.	Count
mysql.show.engine.log.commands	The number of show engine log commands in MySQL. (Random Metric)	Count