Maria DB
Overview
MariaDB, the robust 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 MariaDB databases. Monitor critical database metrics such as query execution times, transaction rates, and storage utilization to ensure efficient data processing and retrieval.
Supported Versions
| Versions |
|---|
| 10.3 (windows) |
| 10.4.13 (linux) |
Prerequisites for MariaDB Integration with Motadata AIOps:
Ensure that the MariaDB 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 MariaDB database.
Ensure that JDBC is supported on the server where MariaDB Database is configured.
For agentless monitoring, ensure that the user has the required access for remote access to the MariaDB server. For agent-based monitoring, this is not required.
Ensure that the MariaDB service is active and running on the server.
Ensure you have the name of the MariaDB database that you want to monitor.
Confirm that the MariaDB 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 MariaDB version that you intend to monitor.
By following these prerequisites, you can integrate MariaDB with Motadata AIOps and ensure smooth functioning of the monitoring process.
List of Supported KPIs
| Name | Description | Type |
|---|---|---|
| system.tags | The tags associated with the system | String |
| mariadb.connections | The number of active connections to MariaDB | Count |
| mariadb.query.cache.hit.ratio.percent | The percentage of queries served by the cache | Count |
| mariadb.aborted.clients | The number of client connections aborted | Count |
| mariadb.aborted.connections | The number of server connections aborted | Count |
| mariadb.opened.connections | The number of new connections opened | Count |
| mariadb.update.commands.rate | The rate of update commands executed | Count |
| mariadb.key.buffer.size.bytes | The size of the key buffer in bytes | Count |
| mariadb.key.used.blocks | The number of key blocks used in the key cache | Count |
| mariadb.installation.directory | The installation directory of MariaDB | String |
| mariadb.data.directory | The data directory of MariaDB | String |
| mariadb.version | The version of MariaDB | String |
| mariadb.received.bytes.rate | The rate of received bytes | Count |
| mariadb.sent.bytes.rate | The rate of sent bytes | Count |
| mariadb.questions | The number of queries sent to MariaDB | Count |
| mariadb.delayed.errors | The number of delayed insert errors | Count |
| mariadb.delayed.writes | The number of delayed writes to disk | Count |
| mariadb.flushes.rate | The rate at which data is flushed to disk | Count |
| mariadb.key.read.requests.rate | The rate of read requests to key cache | Count |
| mariadb.key.writes.rate | The rate of writes to the key cache | Count |
| mariadb.key.write.requests.rate | The rate of write requests to key cache | Count |
| mariadb.not.flushed.delayed.rows | The number of delayed rows not yet flushed | Count |
| mariadb.deleted.rows.rate | The rate of rows deleted from tables | Count |
| mariadb.inserted.rows.rate | The rate of rows inserted into tables | Count |
| mariadb.next.row.reads.rate | The rate of reads to the next row | Count |
| mariadb.read.keys.rate | The rate of keys read from key cache | Count |
| mariadb.updated.rows.rate | The rate of rows updated in tables | Count |
| mariadb.delayed.insert.threads | The number of threads handling delayed insert | Count |
| mariadb.slow.launch.threads | The number of threads with slow launch time | Count |
| mariadb.cached.threads | The number of threads in the thread cache | Count |
| mariadb.connected.threads | The number of currently connected threads | Count |
| mariadb.created.threads | The number of threads created | Count |
| mariadb.running.threads | The number of currently running threads | Count |
| mariadb.thread.cache.size.bytes | The size of the thread cache in bytes | Count |
| mariadb.open.tables | The number of currently open tables | Count |
| mariadb.open.files | The number of open files in MariaDB | Count |
| mariadb.open.streams | The number of open streams in MariaDB | Count |
| mariadb.select.full.joins.rate | The rate of full join operations in MariaDB | Count |
| mariadb.select.ranges.rate | The rate of range select operations in MariaDB | Count |
| mariadb.select.range.checks.rate | The rate of range check operations in MariaDB | Count |
| mariadb.select.scans.rate | The rate of table scan operations in MariaDB | Count |
| mariadb.slave.opened.temp.tables | The number of temporary tables opened by slaves | Count |
| mariadb.slow.queries | The number of slow queries in MariaDB | Count |
| mariadb.sort.merge.passes.rate | The rate of merge passes in sorting operations | Count |
| mariadb.sort.ranges.rate | The rate of range sort operations in MariaDB | Count |
| mariadb.table.lock.waits | The number of table lock waits in MariaDB | Count |
| mariadb.table.immediate.locks | The number of immediate table locks in MariaDB | Count |
| mariadb.created.temp.disk.tables.rate | The rate of temporary disk tables created | Count |
| mariadb.created.temp.files.rate | The rate of temporary files created | Count |
| mariadb.created.temp.tables.rate | The rate of temporary tables created | Count |
| mariadb.query.cache.size.bytes | The size of the query cache in bytes | Count |
| mariadb.query.cache.hits | The number of queries served from the cache | Count |
| mariadb.query.cache.inserts | The number of queries inserted into the cache | Count |
| mariadb.key.hit.ratio.percent | The percentage of key hits in MariaDB | Count |
| mariadb.delete.multi.commands.rate | The rate of multi-delete commands in MariaDB | Count |
| mariadb.select.commands.rate | The rate of select commands in MariaDB | Count |
| mariadb.delete.commands.rate | The rate of delete commands in MariaDB | Count |
| mariadb.insert.commands.rate | The rate of insert commands in MariaDB | Count |
| mariadb.key.reads.rate | The rate of key reads in MariaDB | Count |
| started.time | The time when the server was started | Count |
| started.time.sec | The uptime of the server in seconds | Count |
| mariadb.process.user | The user associated with the process | String |
| mariadb.process.state | The current state of the process | String |
| mariadb.process.command | The command executed by the process | String |
| mariadb.process.db | The database associated with the process | String |
| mariadb.process.info | Additional information about the process | String |
| mariadb.process.id | The unique identifier of the process | Count |
| mariadb.process.host | The host on which the process is running | String |
| mariadb.process.time.ms | The time spent by the process in milliseconds | String |
| mariadb.innodb.buffer.pool.pages.data | The number of data pages in the InnoDB buffer pool | Count |
| mariadb.innodb.buffer.pool.dirty.pages | The number of dirty pages in the InnoDB buffer pool | Count |
| mariadb.innodb.buffer.pool.flush.pages.rate | The rate of flushing pages from the InnoDB buffer pool | Count |
| mariadb.innodb.buffer.pool.free.pages | The number of free pages in the InnoDB buffer pool | Count |
| mariadb.innodb.buffer.pool.misc.pages | The number of miscellaneous pages in the InnoDB buffer pool | Count |
| mariadb.innodb.buffer.pool.pages | The total number of pages in the InnoDB buffer pool | Count |
| mariadb.innodb.buffer.pool.random.ahead.reads | The number of random ahead reads in the InnoDB buffer pool | Count |
| mariadb.innodb.buffer.pool.read.requests.rate | The rate of read requests to the InnoDB buffer pool | Count |
| mariadb.innodb.buffer.pool.reads.rate | The rate of reads from the InnoDB buffer pool | Count |
| mariadb.innodb.buffer.pool.free.waits | The number of waits for free pages in the InnoDB buffer pool | Count |
| mariadb.innodb.buffer.pool.write.requests.rate | The rate of write requests to the InnoDB buffer pool | Count |
| mariadb.innodb.data.fsyncs.rate | The rate of data fsyncs in the InnoDB storage engine | Count |
| mariadb.innodb.data.pending.fsyncs | The number of pending data fsyncs in the InnoDB storage engine | Count |
| mariadb.innodb.data.pending.reads | The number of pending data reads in the InnoDB storage engine | Count |
| mariadb.innodb.data.pending.writes | The number of pending data writes in the InnoDB storage engine | Count |
| mariadb.innodb.data.reads.rate | The rate of data reads from the InnoDB storage engine | Count |
| mariadb.innodb.data.writes.rate | The rate of data writes to the InnoDB storage engine | Count |
| mariadb.innodb.double.write.written.pages.rate | The rate of written pages by the InnoDB double write mechanism | Count |
| mariadb.innodb.double.write.writes.rate | The rate of writes by the InnoDB double write mechanism | Count |
| mariadb.innodb.log.waits.rate | The rate of log waits in the InnoDB storage engine | Count |
| mariadb.innodb.log.write.requests.rate | The rate of log write requests in the InnoDB storage engine | Count |
| mariadb.innodb.log.writes.rate | The rate of log writes in the InnoDB storage engine | Count |
| mariadb.innodb.os.log.fsyncs.rate | The rate of OS log fsyncs in the InnoDB storage engine | Count |
| mariadb.innodb.os.log.pending.fsyncs | The number of pending OS log fsyncs in the InnoDB storage engine | Count |
| mariadb.innodb.os.log.pending.writes | The number of pending OS log writes in the InnoDB storage engine | Count |
| mariadb.innodb.os.log.written.rate | The rate of OS log writes in the InnoDB storage engine | Count |
| mariadb.innodb.page.size.bytes | The size of an InnoDB page in bytes | Count |
| mariadb.innodb.created.pages.rate | The rate of created pages in the InnoDB storage engine | Count |
| mariadb.innodb.read.pages.rate | The rate of read pages from the InnoDB storage engine | Count |
| mariadb.innodb.written.pages.rate | The rate of written pages in the InnoDB storage engine | Count |
| mariadb.innodb.row.lock.current.waits | The current number of row lock waits in the InnoDB storage engine | Count |
| mariadb.innodb.row.lock.time.ms | The total time spent in row lock waits in the InnoDB storage engine | Count |
| mariadb.innodb.average.row.lock.time.ms | The average time spent in row lock waits in the InnoDB storage engine | Count |
| mariadb.innodb.row.lock.waits | The total number of row lock waits in the InnoDB storage engine | Count |
| mariadb.innodb.deleted.rows.rate | The rate of deleted rows in the InnoDB storage engine | Count |
| mariadb.innodb.inserted.rows.rate | The rate of inserted rows in the InnoDB storage engine | Count |
| mariadb.innodb.read.rows.rate | The rate of read rows from the InnoDB storage engine | Count |
| mariadb.innodb.update.rows.rate | The rate of updated rows in the InnoDB storage engine | Count |
| mariadb.admin.commands | The number of administrative commands executed | Count |
| mariadb.analyze.commands | The number of analyze commands executed | Count |
| mariadb.change.database.commands | The number of change database commands executed | Count |
| mariadb.change.master.commands | The number of change master commands executed | Count |
| mariadb.check.commands | The number of check commands executed | Count |
| mariadb.create.database.commands | The number of create database commands executed | Count |
| mariadb.drop.database.commands | The number of drop database commands executed | Count |
| mariadb.flush.commands.rate | The rate of flush commands executed | Count |
| mariadb.grant.commands | The number of grant commands executed | Count |
| mariadb.kill.commands | The number of kill commands executed | Count |
| mariadb.optimize.commands | The number of optimize commands executed | Count |
| mariadb.repair.commands | The number of repair commands executed | Count |
| mariadb.reset.commands | The number of reset commands executed | Count |
| mariadb.revoke.commands | The number of revoke commands executed | Count |
| mariadb.alter.table.commands | The number of alter table commands executed | Count |
| mariadb.create.function.commands | The number of create function commands executed | Count |
| mariadb.create.index.commands | The number of create index commands executed | Count |
| mariadb.create.table.commands | Number of Mariadb create table commands executed | Count |
| mariadb.drop.function.commands | Number of Mariadb drop function commands executed | Count |
| mariadb.drop.index.commands | Number of Mariadb drop index commands executed | Count |
| mariadb.drop.table.commands | Number of Mariadb drop table commands executed | Count |
| mariadb.rename.table.commands | Number of Mariadb rename table commands executed | Count |
| mariadb.handler.close.commands | Number of Mariadb handler close commands executed | Count |
| mariadb.handler.open.commands | Number of Mariadb handler open commands executed | Count |
| mariadb.handler.read.commands | Number of Mariadb handler read commands executed | Count |
| mariadb.set.option.commands | Number of Mariadb set option commands executed | Count |
| mariadb.insert.select.commands | Number of Mariadb insert select commands executed | Count |
| mariadb.load.commands | Number of Mariadb load commands executed | Count |
| mariadb.purge.commands | Number of Mariadb purge commands executed | Count |
| mariadb.replace.commands | Number of Mariadb replace commands executed | Count |
| mariadb.replace.select.commands | Number of Mariadb replace select commands executed | Count |
| mariadb.truncate.commands | Number of Mariadb truncate commands executed | Count |
| mariadb.show.binary.log.commands | Number of Mariadb show binary log commands executed | Count |
| mariadb.show.binary.log.event.commands | Number of Mariadb show binary log event commands executed | Count |
| mariadb.show.database.commands | Number of Mariadb show database commands executed | Count |
| mariadb.show.field.commands | Number of Mariadb show field commands executed | Count |
| mariadb.show.grant.commands | Number of Mariadb show grant commands executed | Count |
| mariadb.show.key.commands | Number of Mariadb show key commands executed | Count |
| mariadb.show.master.status.commands | Number of Mariadb show master status commands executed | Count |
| mariadb.show.open.table.commands | Number of Mariadb show open table commands executed | Count |
| mariadb.show.processlist.commands | Number of Mariadb show processlist commands executed | Count |
| mariadb.show.slave.host.commands | Number of Mariadb show slave host commands executed | Count |
| mariadb.show.slave.status.commands | Number of Mariadb show slave status commands executed | Count |
| mariadb.show.table.commands | Number of Mariadb show table commands executed | Count |
| mariadb.show.variable.commands | Number of Mariadb show variable commands executed | Count |
| mariadb.show.status.commands | Number of Mariadb show status commands executed | Count |
| mariadb.begin.transaction.commands.rate | Rate of Mariadb begin transaction commands | Count |
| mariadb.commit.transaction.commands.rate | Rate of Mariadb commit transaction commands | Count |
| mariadb.lock.table.commands | Number of Mariadb lock table commands executed | Count |
| mariadb.rollback.transaction.commands.rate | Rate of Mariadb rollback transaction commands | Count |
| mariadb.unlock.table.commands | Number of Mariadb unlock table commands executed | Count |
| mariadb.show.engine.log.commands | Number of Mariadb show engine log commands executed | Count |