MariaDB

Home

Supported Platforms^[1] Connectors Directory^[2]

Description

Monitors performance and operational metrics for a MariaDB database.

community^[3] database^[4] linux^[5] windows^[6]

Source^[7]

Target

Typical platform: MariaDB^[8]

Operating systems: Microsoft Windows, Linux

Prerequisites

Leverages: MariaDB Server 11.8 or higher

Technology and protocols: SQL/JDBC

Examples

CLI

metricshub HOSTNAME -t win -c +MariaDB --jdbc -u USER --jdbc-url URL

metricshub.yaml

resourceGroups:
  <RESOURCE_GROUP>:
    resources:
      <HOSTNAME-ID>:
        attributes:
          host.name: <HOSTNAME> # Change with actual host name
          host.type: win
        connectors: [ +MariaDB ] # Optional, to load only this connector
        protocols:
          jdbc:
            port: <PORT>
            database: <DB_NAME>
            type: <type>
            url: <URL>
            username: <USERNAME> # Change with actual credentials
            password: <PASSWORD> # Encrypted using metricshub-encrypt

Connector Activation Criteria

The MariaDB connector will be automatically activated, and its status will be reported as OK if all the below criteria are met:

The SQL query below succeeds on the monitored database:

Metrics

Type	Collected Metrics	Specific Attributes
mariadb	`db.server.cache.operations{db.cache.state="hit", db.mariadb.cache.type="binlog_statement"}` `db.server.cache.operations{db.cache.state="miss", db.mariadb.cache.type="binlog"}` `db.server.cache.operations{db.cache.state="miss", db.mariadb.cache.type="binlog_statement"}` `db.server.cache.operations{db.io.direction="read", db.cache.state="hit", db.mariadb.engine="innodb"}` `db.server.cache.operations{db.io.direction="read", db.cache.state="miss", db.mariadb.engine="innodb"}` `db.server.cache.operations{db.io.direction="read", db.mariadb.engine="aria", db.cache.state="hit"}` `db.server.cache.operations{db.io.direction="read", db.mariadb.engine="aria", db.cache.state="miss"}` `db.server.cache.operations{db.io.direction="write", db.mariadb.engine="aria"}` `db.server.cache.operations{db.io.direction="write", db.mariadb.engine="innodb"}` `db.server.cache.read_ahead.operations{db.cache.read_ahead.state="random", db.mariadb.engine="innodb"}` `db.server.cache.read_ahead{db.mariadb.engine="innodb"}` `db.server.cache.read_head.evicted{db.mariadb.engine="innodb"}` `db.server.cache.requests{db.cache.request.type="flushed", db.mariadb.engine="innodb"}` `db.server.cache.usage{db.cache.state="data_clean", db.mariadb.engine="aria"}` `db.server.cache.usage{db.cache.state="data_clean", db.mariadb.engine="innodb"}` `db.server.cache.usage{db.cache.state="data_dirty", db.mariadb.engine="aria"}` `db.server.cache.usage{db.cache.state="data_dirty", db.mariadb.engine="innodb"}` `db.server.cache.usage{db.cache.state="free", db.mariadb.engine="aria"}` `db.server.cache.usage{db.cache.state="free", db.mariadb.engine="innodb"}` `db.server.connections.limit` `db.server.connections{db.connection.state="success"}` `db.server.connections{error.type="client_disconnected", db.connection.state="aborted"}` `db.server.connections{error.type="failed_attempt", db.connection.state="aborted"}` `db.server.current_connections{db.connection.state="active"}` `db.server.errors{error.type="lost_account_insert", db.mariadb.engine="performance_schema"}` `db.server.errors{error.type="lost_condition_instrument", db.mariadb.engine="performance_schema"}` `db.server.errors{error.type="lost_digest_instance", db.mariadb.engine="performance_schema"}` `db.server.errors{error.type="lost_file_handle", db.mariadb.engine="performance_schema"}` `db.server.errors{error.type="lost_file_instance", db.mariadb.engine="performance_schema"}` `db.server.errors{error.type="lost_file_instrument", db.mariadb.engine="performance_schema"}` `db.server.errors{error.type="lost_hosts_insert", db.mariadb.engine="performance_schema"}` `db.server.errors{error.type="lost_index_statistic", db.mariadb.engine="performance_schema"}` `db.server.errors{error.type="lost_locker", db.mariadb.engine="performance_schema"}` `db.server.errors{error.type="lost_memory_instrument", db.mariadb.engine="performance_schema"}` `db.server.errors{error.type="lost_metadata_lock", db.mariadb.engine="performance_schema"}` `db.server.errors{error.type="lost_mutex_instance", db.mariadb.engine="performance_schema"}` `db.server.errors{error.type="lost_mutex_instrument", db.mariadb.engine="performance_schema"}` `db.server.files{db.file.state="open", db.mariadb.engine="innodb"}` `db.server.io{db.io.direction="receive"}` `db.server.io{db.io.direction="transmit"}` `db.server.mariadb.cache.operations{db.cache.state="hit", db.mariadb.cache.type="binlog"}` `db.server.mariadb.commands{db.mariadb.command.type="begin"}` `db.server.mariadb.commands{db.mariadb.command.type="close_statement"}` `db.server.mariadb.commands{db.mariadb.command.type="commit"}` `db.server.mariadb.commands{db.mariadb.command.type="delete"}` `db.server.mariadb.commands{db.mariadb.command.type="execute_statement"}` `db.server.mariadb.commands{db.mariadb.command.type="insert"}` `db.server.mariadb.commands{db.mariadb.command.type="insert_select"}` `db.server.mariadb.commands{db.mariadb.command.type="prepare_statement"}` `db.server.mariadb.commands{db.mariadb.command.type="replace"}` `db.server.mariadb.commands{db.mariadb.command.type="reprepare_statement"}` `db.server.mariadb.commands{db.mariadb.command.type="rollback"}` `db.server.mariadb.commands{db.mariadb.command.type="rollback_to_savepoint"}` `db.server.mariadb.commands{db.mariadb.command.type="savepoint"}` `db.server.mariadb.commands{db.mariadb.command.type="select"}` `db.server.mariadb.commands{db.mariadb.command.type="update"}` `db.server.mariadb.doublewrite_buffer.operations{db.mariadb.engine="innodb"}` `db.server.mariadb.doublewrite_buffer.usage{db.mariadb.engine="innodb"}` `db.server.mariadb.galera_cluster.nodes` `db.server.mariadb.galera_replication.flow_control.utilisation` `db.server.mariadb.galera_replication.parallel_transactions.limit` `db.server.mariadb.galera_replication.queue_size{db.server.write-sets="receive"}` `db.server.mariadb.galera_replication.queue_size{db.server.write-sets="send"}` `db.server.mariadb.galera_replication.status{state="false\|true"}` `db.server.mariadb.galera_replication.up{state="false\|true"}` `db.server.mariadb.handlers{db.mariadb.handler.type="commit"}` `db.server.mariadb.handlers{db.mariadb.handler.type="delete"}` `db.server.mariadb.handlers{db.mariadb.handler.type="discover"}` `db.server.mariadb.handlers{db.mariadb.handler.type="external_lock"}` `db.server.mariadb.handlers{db.mariadb.handler.type="icp_attempts"}` `db.server.mariadb.handlers{db.mariadb.handler.type="icp_match"}` `db.server.mariadb.handlers{db.mariadb.handler.type="multi_range_read_init"}` `db.server.mariadb.handlers{db.mariadb.handler.type="multi_range_read_key_refills"}` `db.server.mariadb.handlers{db.mariadb.handler.type="multi_range_read_rowid_refills"}` `db.server.mariadb.handlers{db.mariadb.handler.type="prepare"}` `db.server.mariadb.handlers{db.mariadb.handler.type="read_"random"}` `db.server.mariadb.handlers{db.mariadb.handler.type="read_"random_next"}` `db.server.mariadb.handlers{db.mariadb.handler.type="read_first"}` `db.server.mariadb.handlers{db.mariadb.handler.type="read_key"}` `db.server.mariadb.handlers{db.mariadb.handler.type="read_last"}` `db.server.mariadb.handlers{db.mariadb.handler.type="read_next"}` `db.server.mariadb.handlers{db.mariadb.handler.type="read_previous"}` `db.server.mariadb.handlers{db.mariadb.handler.type="read_random_deleted"}` `db.server.mariadb.handlers{db.mariadb.handler.type="rollback"}` `db.server.mariadb.handlers{db.mariadb.handler.type="savepoint"}` `db.server.mariadb.handlers{db.mariadb.handler.type="savepoint_rollback"}` `db.server.mariadb.handlers{db.mariadb.handler.type="tmp_delete"}` `db.server.mariadb.handlers{db.mariadb.handler.type="tmp_update"}` `db.server.mariadb.handlers{db.mariadb.handler.type="tmp_write"}` `db.server.mariadb.handlers{db.mariadb.handler.type="update"}` `db.server.mariadb.handlers{db.mariadb.handler.type="write"}` `db.server.mariadb.replication.galera_cluster.status{state="failed\|ok"}` `db.server.page.size{db.mariadb.engine="innodb"}` `db.server.pending_operations{db.io.direction="read", db.mariadb.engine="innodb"}` `db.server.pending_operations{db.io.direction="write", db.mariadb.engine="innodb"}` `db.server.queries{db.query.state="normal"}` `db.server.queries{db.query.state="slow"}` `db.server.row_lock.current_waits{db.mariadb.engine="innodb"}` `db.server.row_lock.time{db.mariadb.engine="innodb"}` `db.server.row_lock.waits{db.mariadb.engine="innodb"}` `db.server.row_operations{db.row_operation.type="delete", db.mariadb.engine="innodb"}` `db.server.row_operations{db.row_operation.type="insert", db.mariadb.engine="innodb"}` `db.server.row_operations{db.row_operation.type="read", db.mariadb.engine="innodb"}` `db.server.row_operations{db.row_operation.type="update", db.mariadb.engine="innodb"}` `db.server.storage.io{db.io.direction="read", db.mariadb.engine="innodb"}` `db.server.storage.io{db.io.direction="write", db.mariadb.engine="aria"}` `db.server.storage.io{db.io.direction="write", db.mariadb.engine="innodb"}` `db.server.storage.operations{db.io.direction="read", db.mariadb.engine="innodb"}` `db.server.storage.operations{db.io.direction="write", db.mariadb.engine="innodb"}` `db.server.table_cache.operations{db.cache.state="hit"}` `db.server.table_cache.operations{db.cache.state="miss"}` `db.server.table_cache.operations{db.cache.state="overflow"}` `db.server.table_locks{db.lock.state="immediate"}` `db.server.table_locks{db.lock.state="waited"}` `db.server.tables` `db.server.temp_tables{db.temp_table.storage="disk"}` `db.server.temp_tables{db.temp_table.storage="memory"}` `db.server.threads{db.thread.state="cached"}` `db.server.threads{db.thread.state="connected"}` `db.server.threads{db.thread.state="created"}` `db.server.threads{db.thread.state="running"}` `db.server.uptime`	`db.namespace` `db.server.name` `db.system` `db.version` `id`

Search Results for {{siteSearch | truncate:'50'}}

No results.

MetricsHub MetricsHub Community Connectors 1.0.18

Search Results for {{siteSearch | truncate:'50'}}

MetricsHub
MetricsHub Community Connectors 1.0.18