MySQL
Seamlessly integrate MySQL with Motadata AIOps to gain real-time database performance insights, proactive monitoring, and optimized query and resource management for efficient operations.
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 |
Explore More Integrations
Browse our comprehensive integrations catalog to discover all supported platforms and services.